Search found 2 matches
- 25.03.2009, 16:23
- Forum: 6.6 - stable
- Topic: MSSQL transaction methods
- Replies: 1
- Views: 3139
Just in case, this is the code that I'm using: // cut here procedure TForm1.ImportaNoBanco(nomeArquivo: String); var IdArquivo, I : Integer; ZQuery : TZQuery; StrSQL : AnsiString; ListaOutput : TStringList; begin ZQuery := TZQuery.Create(nil); ListaOutput := TStringList.Create; try ZQuery.Connection...
- 25.03.2009, 16:13
- Forum: 6.6 - stable
- Topic: MSSQL transaction methods
- Replies: 1
- Views: 3139
MSSQL transaction methods
Hello all. I'm in trouble using StartTransaction, Commit and Rollback on ZeosDBO on a SQL2000 (MSSQL driver) and AutoCommit True. The transaction is incorrectly commited automatically using MSSQL. I don't have this problem when using mysql driver. I worked around this problem adding explicit 'BEGIN ...