SQL way of getting last recID

[bartjan at mac.com]

Or

db.SQLExecute("GetLatestInsertID FOR tablename")

Bart

On 20 Mar 2004, at 02:24, Charles Yeomans wrote:

>
> On Mar 19, 2004, at 4:31 PM, Ruslan Zasukhin wrote:
>
>> On 3/19/04 1:29 AM, "James Kleinschmidt" <jkleins at shentel.net> wrote:
>>
>>> Is there a way to get the recID of the last added record for a table 
>>> if
>>> it was added with the insert sql command?
>>
>> Hi James,
>>
>> It seems know.
>>
>> We need invent something.
>>
>> You have ideas What syntax we can use for this?
>>
>
> How about
> db.SQLExecute("GET NEWEST recID For TableName") as Integer?
>
> Charles Yeomans
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina