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