Thanks for helping out.
Alas, the problem is more complex than that; I want to be able to see all of the changes to the recordset, ie any trigger activity, default values etc.
I have been working with Oracle for quite a while now, using their OLEDB driver and this has never come up as an issue; that's why I found this quite perplexing.
So, to summarise, I need to be able to see all server-side generated chnages to the record that I am adding.
Once again, thanks for helping out. Regards, Nick Damoulakis
From: Daniel Dittmar <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: ADO 2.8, VB6, SAPDB table with PK = SERIAL(1): cannot see PK value in recordset
Date: Mon, 20 Oct 2003 00:44:51 +0200
Nick Damoulakis wrote: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]
_________________________________________________________________
Chat via SMS. Simply send 'CHAT' to 1889918. 33c per message sent. Free to receive. More info at http://ninemsn.com.au/mobilemania/MoChat.asp?blipid=6800
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
