Data type mismatch in criteria expression.

[DMG2000]

Everytime I try to call, or add to a primary key with a database, I get this error &quot; Data type mismatch in criteria expression.&quot;, I know it has to be possible to get or update the primary key autonumber, but why isn't this working?<br>Code as follows:<br>sql= &quot;insert into orderitems (<b>orderid</b>,productid, qty,priceperunit) values ('&quot; & <b>orderid</b> & &quot;','&quot; & acart(i,0) & &quot;','&quot; & acart(i,1) & &quot;','&quot; & rsprice(&quot;saleprice&quot & &quot;')&quot;<br><br>Note: Bold is the primary key<br><br>Appreciate any thoughts!

 

[palbano]

Dear DMG2000,

When you have database level errors, take your SQL Statement into your database query execution environment and run it there. The database query tool should provide you with detailed information regarding the problem with the SQL Statement.

In this case if you are dealing with Access Autonumber or SQL Server IDENTITY columns. You are not allowed to set those column values during a row insert operation. The engine is supposed to provide that value for you, that is the whole point of those column types.

Hope this helps
-pete

 

[DMG2000]

Thanks Pete. I figured out what the error was. I was using adOpenDynamic when I should have been using adOpenKeyset...took long enough but after looking at the code for hours, it came to me.

 

[ssssssss]

sss