I need call requery for get the new Id from sql server. IN Sql, the identity and custom-generated codes is generated. Resync not work in this case. I try using static,dynamic,etc... cusrsor and the only way for get is is call requery.


Obvious, this is done in the server. The recordset is passed to the server and i use requey for get the new data.

However, if exist other way... i'm looking a lot but nothing work.

NOTE: I use this for edit student related information...