Page 1 of 1

Can not update this query type

Posted: 04.03.2006, 21:55
by zippo
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
---------------------------

Posted: 05.03.2006, 22:23
by mdaems
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

Posted: 05.03.2006, 23:23
by zippo
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! :(

Posted: 05.03.2006, 23:27
by zippo
Just one more thing. It's a temporary table - does this affect the posting of data here?