>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...

Requery is not the only way to get at the data. What Requery does is a simple Close and Open of the RS. If Requery is failing for you just replace with Close and Open method calls.

Have you tried making the changes to the code in your initial post? I didn't see a Requery in that piece.