Can not update this query type

zippo · Post by **zippo** » 04.03.2006, 21:55

Hi!

I have a problem while posting a row into a temporary table (on MySQL 3.23). When posting, I got this error. The table has no lookups, no calculateds, just "Select * From POS_TMP"... Any suggestions?

---------------------------
Debugger Exception Notification
---------------------------
Project Prodaja.exe raised exception class EZSQLException with message 'Can not update this query type'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------

Post by **mdaems** » 05.03.2006, 22:23

Hi Zippo.
I remember somebody was asking some days ago a similar question. Is it possible that this table has no primary key? That seemed to be the problem in his case. (I did not see a confirmation in his thread that it actually solved the problem)

Mark

zippo · Post by **zippo** » 05.03.2006, 23:23

Hmmm... don't think so - I checked (to be sure before posting, he he) and the keys seems OK. However I will do some additional checking on the property UpdateMode and WhereMode. I'll also post the results here. In the meanwhile can any developer post in what case the exception raises?

Please help, because I'm stuck in the middle of a project!

zippo · Post by **zippo** » 05.03.2006, 23:27

Just one more thing. It's a temporary table - does this affect the posting of data here?