record number in free record lookup
scooter6 at gmail.com
scooter6 at gmail.com
Fri Feb 3 06:40:13 PST 2012
So I have to use 'rn' as the variable and it will work?
Basically same thing I'm doing I just have to replace my 'ce' variable
with 'rn'?
On Fri, Feb 3, 2012 at 9:27 AM, Richard Kreiss <rkreiss at verizon.net> wrote:
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120203/9e1394fe/attachment.html
More information about the Filepro-list
mailing list