I am using VB6 SP5, ADO2.8 and SAPDB 7.4.3.27.
I have a table
CREATE TABLE "DBA"."TBL_USERS"
(
"USERID" Integer NOT NULL DEFAULT SERIAL (1),
"LOGONID" Varchar (20) ASCII,
"USERNAME" Varchar (30) ASCII,
"USERSURNAME" Varchar (30) ASCII,
"LASTLOGGEDIN" Timestamp,
"LASTCHANGED" Timestamp,
"ISACTIVE" Smallint DEFAULT 1,
"XPASSWORD" Integer,
"CANEDIT" Smallint DEFAULT 0,
"CANSYSADMIN" Smallint DEFAULT 0,
"LOGGEDIN" Smallint DEFAULT 0,
PRIMARY KEY ("USERID")
)
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.>
btw, with the exception of the .ReSync, the code works in that it actually does insert the record. It's just that I can't get to the generated value.
Any ideas on this would be appreciated. Regards, Nick Damoulakis
_________________________________________________________________
Chat via SMS. Simply send 'CHAT' to 1889918. 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]
