when I use an ADO recordset to .AddNew (using a server-side cursor), I cannot see the value that SAPDB inserts in the USERID column. This is a problem as I need to use that value (the PK) in the remainder of my source.
If I try a .ReSync on the recordset I get the following error:
<Current provider does not support refreshing underlying values.>
You can accesss of the recently generated value with TBL_USERS.CURRVAL. You can either execute "SELECT TBL_USERS.CURRVAL FROM dual" to get the value into a VB valiable or you can use the expression directly in an INSERT : "INSERT INTO othertable (keycol, foreignkey) values (?, TBL_USERS.CURRVAL)".
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
