RecID of newly inserted record?

[Ruslan Zasukhin]

on 4/16/03 10:20 PM, Steve Kellogg at stevekellogg at mezzotechnologies.com
wrote:

Hi Steve,

> When I add a Record to a table via "INSERT INTO", is there any way to get the
> RECID of the record that was just added DIRECTLY from the SQLExecute statement
> without creating ANOTHER QUERY to send via SQLSelect?
> 
> This second query seems SUCH a waste of processor time, when the SQLExecute
> OBVIOUSLY knows which RECID was just created.
> 
> Thanks in advance for any input.

You have found one of the biggest whole in the current Valentina version.

There is no way yet to define this RecID.

In other DBs,  exists some kind of LastID.
I think I need close this whole soon.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------