Search found 6 matches
- 18.02.2011, 15:32
- Forum: 6.6 - stable
- Topic: TZquery dont works with Multiple Statements
- Replies: 17
- Views: 6579
- 14.02.2011, 20:17
- Forum: 6.6 - stable
- Topic: TZquery dont works with Multiple Statements
- Replies: 17
- Views: 6579
- 14.02.2011, 15:44
- Forum: 6.6 - stable
- Topic: TZquery dont works with Multiple Statements
- Replies: 17
- Views: 6579
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...
- 14.02.2011, 14:55
- Forum: 6.6 - stable
- Topic: TZquery dont works with Multiple Statements
- Replies: 17
- Views: 6579
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...
- 11.02.2011, 23:26
- Forum: 6.6 - stable
- Topic: TZquery dont works with Multiple Statements
- Replies: 17
- Views: 6579
TZquery dont works with Multiple Statements
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...
- 13.08.2009, 22:39
- Forum: 6.6 - stable
- Topic: Problem when Post in 6.6.2-rc ... 6.6.5-stable
- Replies: 7
- Views: 911
Problem when Post in 6.6.2-rc ... 6.6.5-stable
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...