Protecting lookups to free records

[Jeff Harrison]

--- "Mike Schwartz (PC Support & Services, Appleton,
WI)" <mschw at athenet.net> wrote:

>      I was having a converstation this afternoon
> with another programmer,
> and we were debating whether or not we should be
> protecting a lookup
> to a free record.  We both usually do it, but the
> lookup wizard in
> filePro doesn't offer the "protect" option when you
> setup a lookup
> free, and I don't believe the wizard has ever
> offered that.
> 
>      Is that something that I should add to the
> wishlist, or have many of
> you asked for that in the past?  I'm running filePro
> on SCO Unix,
> both are 5.0.5
> 
>      The wizard is nice, especially for the new
> filePro trainees I am
> working with, but it has one other shortcoming that
> bothers me:
> 
>      I would also like the wizard to be able to
> handle a lookup with a
> complex embedded variable, like:
> 
> lookup art=artfile k=(@rn&za&zd) i=A -bx
> 
>      Have any of you asked for this on the wishlist?
> 

I have asked about the protected lookups in the past,
and the answer that I received was that free record
lookups are automatically protected.  You don't need
to use the -p flag.  You can try it yourself to see
that this is so.  Just do a free record lookup, then
execute a msgbox and then on another session try to go
into update mode on that record.  You will see that
the record is indeed locked.


Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest way to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com