record number in free record lookup

Richard Kreiss rkreiss at verizon.net
Fri Feb 3 06:27:46 PST 2012


Top post from phone:

To get the new record number after the lookup free add rn=new(@rn). This will be the new record number. 

Be careful about record numbers as Filepro will add new records to deleted records. So it is possible that a new record may be added which has a lower record number the the highest available record number in the file.  

Richard
Sent from my iPhone

On Feb 3, 2012, at 9:06 AM, "scooter6 at gmail.com" <scooter6 at gmail.com> wrote:

> I have a process that is adding a record to a file and I need to capture
> the record number that is being added
> i.e.
> 
> If = 6 gt @td
> Then = lookup new = file   r=free   -e
> 
> Then = ce(10,*)=new(@rn)
> 
> 
> I need 'ce' equal to the record number that is getting added to 'file' so I
> can do another free lookup that needs
> the newly created record number in 'file'
> 
> Is this possible?
> I have tried setting ce after I do a 'write' new but that didn't work either
> 
> Anyone?
> 
> Scott
> PDM
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120203/2a5a65de/attachment.html 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list


More information about the Filepro-list mailing list