Does DELETE close a lookup?
Kenneth Brody
kenbrody at bestweb.net
Mon Dec 3 06:52:03 PST 2007
Quoting Jay R. Ashworth (Sun, 2 Dec 2007 18:29:33 -0500):
> On Sun, Dec 02, 2007 at 03:37:41PM -0700, fp at casabellagallery.com wrote:
>> Jay wondered:
>> > If I have a lookup open, and decide I want to DELETE the free record I
>> > just allocated through it, will
>> >
>> > IF: tag
>> >
>> > be false after that? By definition, I mean; I'm sure I could test it,
>> > but I'm equally sure that might not be authoritative, and the help file
>> > doesn't seem to say, on either end.
>>
>> Well, I did run a test using code:
[...]
>> and line 4 is TRUE every time.
>
> Well, I guess that proves that DELETE doesn't imply CLOSE.
>
> I believe that to be a bug. It's especially a bug if I can't CLOSE
> *after* I delete: I'm going to have code working against that alias
> tag, and I don't want it to blow up if I've had to delete the record
> (which I won't always do...)
Well, two things...
First, I believe that you are using the term CLOSE improperly here. The
only thing (besides exiting) that will CLOSE a lookup is CLOSE. However,
"if not lookupname" does not mean the file is "closed". It means "did
the lookup fail?" Also, a failed lookup does _not_ close the file.
Remember -- the lookup did succeed. The fact that you deleted the record
that you found does not change that fact.
Finally, I'm not sure what you mean by "[you] can't CLOSE after [you]
delete [the lookup]". First, you can certainly CLOSE the lookup if you
want to, regardless of the success/fail state. Second, unless you are
finished with the file, why do you want/need to close it?
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list