TSQL function "IDENT_Current"

I find this TSQL function to be terribly useful, especially in server calls where I need to insert a record and then need its Origrec.

To use it, do an insert into a table


bSuccess := SqlExecute("INSERT INTO TABLENAME...");

then, to find out the Origrec of the row you just entered, use:

 iOrigRec := SqlExecute("SELECT IDENT_Current('TABLENAME')");