HXTT ACCESS
Getting Autonumber value
James Billings
2007-08-28 11:27:05.0
Hello,

Do you know how to, with HXTT Access, get the autonumber value of a newly inserted record? With ODBC/JDBC Bridge, one can use "select @@identity" object to achieve this result.

Thanks,

Jim Billings
Re:Getting Autonumber value
HXTT Support
2007-08-28 17:18:04.0
You an use the standard JDBC API:
Statement.executeUpdate(String sql, int autoGeneratedKeys) and Statement.getGeneratedKeys()



Google