Re: Another Database SQL Update question
- From: "Jeff Grippe" <jeff@xxxxxxxxx>
- Date: Tue, 19 Feb 2008 09:25:31 -0500
I think what is going on here is that at one point, I had a problem that
made no sense and I decided that _TALLY wasn't reliable.
Meanwhile, as I said earlier, it is all over my code.
When I use it, I use it the way everyone says it should be used.
I do SELECT......FROM..... and then I immediately capture the value of
_TALLY
I think I'll go back to trusting it since all of the places where I use it,
it works just fine.
Thanks,
Jeff
"Gene Wirchenko" <genew@xxxxxxxx> wrote in message
news:bh5dr3dkqgt9msitoegno4593a6hfe5rnk@xxxxxxxxxx
"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote:
The mistake most people make with _Tally is that there are other commands
besides queries that set it. You have to grab the value *immediately*
after
a query or you might get a _Tally for some other action.
I've never seen it give a wrong value.
I go with Dan here. When I use it, I use it immediately,
typically:
<_tally value generating statement>
howmany=_tally
The assignment is before anything else, period.
This problem is reminescent of the parameters() function which
could throw one for a loop due to an OKL triggering.
[snip]
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
.
- References:
- Another Database SQL Update question
- From: Jeff Grippe
- Re: Another Database SQL Update question
- From: Jeroen van Kalken
- Re: Another Database SQL Update question
- From: Jeff Grippe
- Re: Another Database SQL Update question
- From: Paul Pedersen
- Re: Another Database SQL Update question
- From: Jeff Grippe
- Re: Another Database SQL Update question
- From: Dan Freeman
- Re: Another Database SQL Update question
- From: Gene Wirchenko
- Another Database SQL Update question
- Prev by Date: Re: Append from "Excel File" TYPE XL8 give 1661 error if file saved from Excel 2007
- Next by Date: Re: Another Database SQL Update question
- Previous by thread: Re: Another Database SQL Update question
- Next by thread: QLRe: Another Database SQL Update question
- Index(es):
Relevant Pages
|