How to retreive the ID of added record (using SQL and ODBC)

[DGS/DST/DTAD]

Hi.

I's easy to create a record with Object Script or ActiveX and then
use the ID of the record.

But how to do it in SQL (using ODBC) ???
I want to insert a record using the sql INSERT INTO command.


Thanks

Thierry