Search found 2 matches
- 19.11.2013, 09:57
- Forum: 6.6 - stable
- Topic: TZConnection is always in transaction state
- Replies: 15
- Views: 12281
Re: TZConnection is always in transaction state
Hi. To get explicit transactions control im using another way: ZDBConnection1.Autocommit:false I call server to start transaction before any edits starting {before opening some editor form} ZDBConnection1.ExecuteDirect('START TRANSACTION;'); after this you should execute query to lock required objec...
- 13.11.2013, 09:10
- Forum: ZeosLib 7.1 stable Forum
- Topic: Problems using ZQuery
- Replies: 1
- Views: 777
Problems using ZQuery
Hi all/ I have Lazarus 1.2RC1 and ZeosDBO 7.1.2 stable RequestHardwares.Close; if not MainWND.TB_Apply_Filter.Down then RequestHardwares.SQL.Strings[RequestHardwares.SQL.Count-1]:='where hardwares."HW_Location"=' +{CabinetsTable}RO_Cabinets.Fields[0].AsString+';' else begin // MainWND.DoFi...