Does  your table have a primary key or any unique index? If not, try to set
one and do the update.

Abdullah
----- Original Message -----
From: "Peter Crane" <bluemight2000@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Monday, April 29, 2002 5:21 PM
Subject: [activex_data_objects] "insufficient base table information" ADO
error


> Gday all
>
> Please yell if you can help.
>
> When I fill a adodb.recordset with data from Sybase DB, I found that its
> BaseColumnName and BaseTableName information were null (I am using a
> client side cursor type)  When I update the recordset, I get something
> like : "insufficient base table information".  I have no idea why!
>
> Thanks for reading...Peter Crane

Thanks Abdullah, yes, I have all the keys but turn out that wasnt the 
problem.  Its a bug in ADO, I have a forgotten declared recordset hanging 
around and not being used, when I do updatebatch, for some reason, ado 
doesnt like to have more than 1 recordset declared in the same class.  
Once I killed the forgotten recordset, everything went fine.

Thanks again...Peter


> Does  your table have a primary key or any unique index? If not, try to 
set
one and do the update.

Abdullah
----- Original Message -----
From: "Peter Crane" <bluemight2000@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Monday, April 29, 2002 5:21 PM
Subject: [activex_data_objects] "insufficient base table information" ADO
error


> Gday all
>
> Please yell if you can help.
>
> When I fill a adodb.recordset with data from Sybase DB, I found that its
> BaseColumnName and BaseTableName information were null (I am using a
> client side cursor type)  When I update the recordset, I get something
> like : "insufficient base table information".  I have no idea why!
>
> Thanks for reading...Peter Crane