Does DELETE close a lookup?

[fp at casabellagallery.com]

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:

1    -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
@key*  ? If:                                                                   ?
       Then: lookup ref = asorderd  k=40   i=A -npx b="(brw=12 fill=asc)*1     >
2     -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ? If: not ref                                                           ?
       Then: end                                                               ?
3    -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ? If:                                                                   ?
       Then: delete ref                                                        ?
4    -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ? If: ref                                                               ?
       Then: show "@Its there ..."                                             ?

and line 4 is TRUE every time.  

Remember that filePro tells us that the alias is true not that the record
status, which I think is what you wonder about.  

Now, the alias will remain open until close ref is executed or program exits.
Some will argue that it will close upon "end" but we know that is not the
case.

Regards,


---
Jose Lerebours
954  559  7186
http://www.fpgroups.com