SQL way of getting last recID

[Ruslan Zasukhin]

On 3/20/04 9:46 AM, "bartjan at mac.com" <bartjan at mac.com> wrote:

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

>>> You have ideas What syntax we can use for this?
>>> 
>> 
>> How about
>> db.SQLExecute("GET NEWEST recID For TableName") as Integer?

Charles, SqlExecute() right now returns integer -> number of affected
records.

> Or
> 
> db.SQLExecute("GetLatestInsertID FOR tablename")
> 
> Bart
> 

Yes, some dbs have function as last_id();

We have talk here abou this and was some reason not to make it.
It seems Ivan have told that only mySQL actually have it.
Big DBMS do not have such feature.
Hmm, do not remember reason.
We will talk again.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------