Getting RecID of record just added

[Ken Ray]

I didn't realize this... there was a discussion about this several
months back, with Ruslan saying that getting the ID of a record that was
just added wasn't available yet, but that he'd try to add it in a later
build. Perhaps that had to do with INSERT instead of using cursors...
hmm...

Anyway, thanks a lot!

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Robert Brenstein
> Sent: Friday, December 05, 2003 7:08 AM
> To: Valentina Developers
> Subject: Re: Getting RecID of record just added
> 
> 
> >Ruslan,
> >
> >The fact that you can't get the exact ID of a record that was just 
> >added without writing a very convoluted query is really starting to 
> >wear thin on me. :-)
> >
> 
> Ken, may be I don't understand your problem fully, but you just need 
> to fetch the recId of the current record (Cursor_GetField). When you 
> add a new record, it's becoming the current record. The only extra 
> thing you need to do ahead of that is to include RecId in the sql 
> select that you use to create your cursor (Select *,RecId From ...). 
> It is just an extra field in the list, nothing convoluted :)
> 
> Robert Brenstein _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net 
> http://lists.macserve.net/mailman/listinfo/val> entina
>