inconsistent Query works second time it's run

#11

David-W-Fenton wrote:

Quote:

"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> wrote in
news:iaabbj$br1$1 (AT) news (DOT) eternal-september.org:

Composer wrote:
What do you mean, ADO is dead?

I guess I have to slightly disagree with David.

ADO of course is as dead as DAO.

DAO is *not* dead -- it is in continual development in tandem with
the Jet/ACE database engine.

OK, point conceded.

Quote:

ADO.Net is the new paradigm. Additionally,
DAO is single-threaded, so if your application is multi-threaded
(such as a web application), you need to use ADO.

Web applications should not be using a Jet/ACE datastore, precisely
because of this issue.

Not even small-scale intranet applications such as are used in many
locations? Please, get off the high horse. The advantages of using asp
instead of fat clients that don't need to be installed everwhere they are
used are very appealing to IT depts such as the one I work for.

Quote:

In the present case, the issue was not even ADO but JRO, and JRO was
being recommended to do something that DAO can already

So? The OP was looking for an ADO solution. Jeez!

Quote:

The number of things ADO can do with Jet/ACE that DAO can't is
actually pretty small. Of those things, very, very few of them are
essential or even very useful.

So? The fact that some developers do find them useful is irrelevant? I think
not.

#12

"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> wrote in
news:iacvnb$fgf$1 (AT) news (DOT) eternal-september.org:

Quote:

David-W-Fenton wrote:
"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> wrote in
news:iaabbj$br1$1 (AT) news (DOT) eternal-september.org:

ADO.Net is the new paradigm. Additionally,
DAO is single-threaded, so if your application is multi-threaded
(such as a web application), you need to use ADO.

Web applications should not be using a Jet/ACE datastore,
precisely because of this issue.

Not even small-scale intranet applications such as are used in
many locations? Please, get off the high horse. The advantages of
using asp instead of fat clients that don't need to be installed
everwhere they are used are very appealing to IT depts such as the
one I work for.

The issue is not the capacity of the database -- there are plenty of
sites that are completely within the realm of what could be handled
easily by Jet/ACE.

But the mismatch between web server memory/process/thread management
and Jet/ACE's capabilities is fatal, in my opinion. There's too much
potential for problems that I'd never recommend it, even though I'm
a big fan of Jet/ACE.

That said, Michael Kaplan's Trigeminal.com is using a Jet database
(assuming he hasn't changed it since he told us about it many, many
years ago).

But I still wouldn't recommend it, or ever implement it for a client
(even on an Intranet).

Quote:

In the present case, the issue was not even ADO but JRO, and JRO
was being recommended to do something that DAO can already

So? The OP was looking for an ADO solution. Jeez!

And was provided a JRO solution. JRO is not ADO. It's a separate
library. ADO can't do what was required, DAO can.

Quote:

The number of things ADO can do with Jet/ACE that DAO can't is
actually pretty small. Of those things, very, very few of them
are essential or even very useful.

So? The fact that some developers do find them useful is
irrelevant? I think not.

I didn't say that.

You're just arguing, not contributing any new information.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#13

Composer wrote:

Quote:

And batch updates were never a possibility for my app. *One user
presses one button and I have to react to it.

On Oct 28, 9:11 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid

wrote:

Quote:

I really don't know what the hell you're talking about. You replied
to one of my posts from over a month ago and are bringing up issues
not addressed in my post. So I really don't have a clue what the
hell you're talking about with this SEEK tangent.

Um, pardon me, David, but please read your post of 25 September
8:14pm,
where you recommended that I "convert the
sequential process into a set-based process that uses a single SQL
UPDATE statement to make all the changes in a batch".

You may know a lot more about this technology than I know, but
you waste a lot of your energy dissing people for no good reason.

#14

Composer <composer (AT) uwclub (DOT) net> wrote in
news:7d3a5ae5-05c2-409b-9502-d7a4091778d0 (AT) r4g2000prj (DOT) googlegroups.com
:

Quote:

Composer wrote:

And batch updates were never a possibility for my app. *One
user presses one button and I have to react to it.

On Oct 28, 9:11 pm, "David-W-Fenton"
NoEm... (AT) SeeSignature (DOT) invalid> wrote:

I really don't know what the hell you're talking about. You
replied to one of my posts from over a month ago and are bringing
up issues not addressed in my post. So I really don't have a clue
what the hell you're talking about with this SEEK tangent.

Um, pardon me, David, but please read your post of 25 September
8:14pm,
where you recommended that I "convert the
sequential process into a set-based process that uses a single SQL
UPDATE statement to make all the changes in a batch".

And the word "SEEK" is in there where?

Quote:

You may know a lot more about this technology than I know, but
you waste a lot of your energy dissing people for no good reason.

I'm to blame for your introduction of topics that weren't relevant?

\/\/hatever.

<plonk>

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

inconsistent Query works second time it's run

comp.databases.ms-access comp.databases.ms-access

Re: inconsistent Query works second time it's run - 10-28-2010 , 06:07 PM

Re: inconsistent Query works second time it's run - 10-29-2010 , 05:13 PM

Re: inconsistent Query works second time it's run - 11-05-2010 , 07:15 AM

Re: inconsistent Query works second time it's run - 11-05-2010 , 03:44 PM