Zeoslib Portal

Really I can have a problem trying to use a "temporary" table in Mysql 3.23.55 because it dont have "temporary table", so I use a normal table. This program is for one user only, so its a workaround. But I dont know why dont work execute 3 SQLs together? Its a bug? To manage my D...

I cant use transaction because my tables are myisam but I think it is not the problem. Really if I execute the SQLs separately it works but dont exact as I need. Because "table1" dont exists in the Database (its temporary) and I need to fill the Fields Editor of the ClientDataSet at design...

Thanks Wild_Pointer. In my TZconnection I set AutoCommit to false and TransactionIsolation to tiNone. I modifiy my Sql: with ZQuery1 do begin Close; Sql.Clear; Sql.Add('START TRANSACTION ISOLATION LEVEL READ COMMITTED; '); Sql.Add('DROP TABLE IF EXISTS table1 ; '); Sql.Add('CREATE TABLE table1 SELEC...

No. In your case you can use TZSqlProcessor and put the sql statements in Script property; the delimiter is the Delimiter property. In my case I cant use TZSqlProcessor because I have to do a select in the end: with ZQuery1 do begin Close; Sql.Clear; Sql.Add('DROP TABLE IF EXISTS table1 ; '); Sql.Ad...

I use Delphi7 + ZeosLib 6.6.6-stable + MySql 3.23.55 + TZconnection.protocol = mysql-4.1 I need to use multiple statements in TZquery or TZReadOnlyQuery but it dont works. This is the code: with ZQuery1 do begin Close; Sql.Clear; Sql.Add('DROP TABLE IF EXISTS table1 ; '); Sql.Add('CREATE TABLE table...

I use TZQuery + TDataSetProvider + TClientDataSet + TZUpdateSql in Delphi 7. I test in MySql 3.23, 4.1 and 5.1 using protocol mysql-4.1 in TZConnection. The 'real' table structure is: ' IdTab integer, SubIdTab integer, Field1 varchar(50), Field2 varchar(50)'. The ZQuery.SQL = 'select IdTab, SubIdTab...