Zeoslib Portal

I've encountered the same problem, and everytime I work with temporary mysql tables, I have to use TZUpdateSQL to update them. OK, now I am also using a TZUpdateSQL for UPDATE-Statements in order to get rid of the "cannot update this query type"-problem. But the paramater-substitution in ...

Hi there, ok, my code is as follows, a little bit simplified: ZQuery2.Close; ZQuery2.SQL.Clear; ZQuery2.SQL.Add( 'SELECT * FROM ' + ActualTable ); ZQuery2.SQL.Add( 'WHERE ' + trim(Memo3.Text) ); ZQuery2.SQL.Add('LIMIT ' + intToStr(mainform.UpDownLimitStart.Position) + ', ' + intToStr(mainform.UpDown...

I just wanted to say that I still got the same problem and I wonder why so few others seem to have this problem with the "Cannot update this query type". So please, if someone knows something more on that, please help us!

Anse

Seems like a more general problem, could have something to do with the old mysql-version. Have you considered updating MySQL ?

Greetings,
Ansgar

Stefan,

"RequestLive" was renamed to "ReadOnly" in 6.5.1 . And if I set ReadOnly:=true, I cannot edit data at all, as one would expect when setting the query to "readonly" ...

Ansgar

Strange: sometimes i can update with LIMIT-queries and sometimes not. I have a slight idea that only tables with a primary key can be updated, because one table I cannot update has no PK and another with a PK can be updated... By the way: the "ZQuery.WhereMode" is set to "wmWhereAll&q...

- DBMS: MySQL - ZQuery.SQL is "select * from mytable limit 0,10" When I do a ZQuery.Post through a TDBGrid and a TDatasource I get the error "cannot update this query type". I thought this error only raises when doing queries with joins or some aggregate-functions in it?? Regards...

got it! The ZConnection.Database MUST be set BEFORE .connect is called. I wonder if this is a bug in zeos?

Greetings,
Ansgar

Hi again, I have a ZConnection connected to a MySQL-Server and a ZQuery. To switch to another Database I execute a simple "use dbname". So far, so easy. When I query a table with "select * from table1 limit 0,10", the application throws an exception with "SQL Error: You have...

Ok, thanks a lot. That was too easy
I always thought, setting the database-property would automatically do a "USE dbname" ...

Greetings,
Anse

Hello, I have a ZConnection1 and a ZQuery1 but I can only define the Database once. ZConnection1.Database := 'test1'; ZQuery1.SQL.Add('SELECT * FROM table1'); ZQuery1.Open(); // This runs as expected! ZQuery1.Close(); ZConnection1.Database := 'test2'; ZQuery1.SQL.Clear; ZQuery1.SQL.Add('SELECT * FRO...