insufficient key column information

[kcovert]

I'm trying to update data using the ado dataenvironement with joined tables, and primary keys.

example:
mysql = "Select * FROM Inventory INNER JOIN ON "

.....more code ......
de.command(scommand1) = mysql
then I select the cursor types etc.

with rscommand1
if len(text1(part)<> 0 then !Partnumber = text1(part)
.... more code .....
.update 'this is where I get the error...(insufficient key column
information.....)

end with
'the Partnumber is the primary key.
can anyone help? Thanks

[peet]

Hi kconvert,
found this article in the MSDN, maybe you find your problem after reading it:

BUG: Problem Updating ADO Hierarchical Recordset When Join Tables Share Same Column Name
ID: Q246905


--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft Data Access Components versions 2.1, 2.1 (GA), 2.1 SP1, 2.1 SP2, 2.5, 2.6

--------------------------------------------------------------------------------


SYMPTOMS
When updating an ActiveX Data Objects (ADO) recordset, an error occurs if the recordset, based on a SHAPE command, joins two tables where the primary key of one table has the same name as a column name of the other table. The following error appears:

Run-time error '-2147467259 (80004005)':

Insufficient key column information for updating or refreshing.
The preceding error also occurs when connecting to Oracle through Microsoft ODBC for Oracle.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

[reyghie]

Check your SQL statement or better still you can post the complete query, so we can take a closer look on what's causing the problem.
Your SQL post:
mysql = "Select * FROM Inventory INNER JOIN ON "
Suggestion:
mysql = "Select * FROM Inventory INNER JOIN OtherTableName ON Inventory.whatever = OtherTableName.whatever"