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