Zeoslib Portal

Hi, I use the zeos 6.6.2-RC, Delphi 7 and Mysql 5.0.45. I'm trying to run multiple commands at once, example: z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codigo = "200";'); z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codig...

Hi, I use the zeos 6.6.2-RC, Delphi 7 and Mysql 5.0.45. I'm trying to run multiple commands at once, example: z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codigo = "200";'); z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codig...

My code is: procedure StartTransacao; begin dtm_banco.z_transacao.SQL.Clear; dtm_banco.z_transacao.SQL.Text := 'START TRANSACTION'; dtm_banco.z_transacao.ExecSQL; end; procedure CommitTransacao; begin dtm_banco.z_transacao.SQL.Clear; dtm_banco.z_transacao.SQL.Text := 'COMMIT'; dtm_banco.z_transacao....

Check your TransactionLevelIsolation <> TiNone I use ZConnection with de autocommit = true I Have this code: try DmMain.ZConnection.StartTransaction; ................ DmOperacionesVehiculos.QryInsertarVehiculo.ExecSQL; ................ ................ DmOperacionesVehiculos.QryGuardarOperacion.Exec...

Hello to all ... I use Zeos with MYSQL in my Delphi applications with MYSQL 5.0.45. After much searching, I finally found out why RollBack in my ZeosConnection never undoes the changes when i explicitly start the transaction with StartTransaction. This occurs when the ZConnection is TransactionIsola...

I'm from Brazil, I'm sorry for bad English. What I understood is that CommitUpdates only clears the buffer, without applying the changes. Already ApplyUpdates writes the changes to the base and clears the buffer cachedupdates. That?? doidopb , COMMITUPDATES clears the CachedUpdates buffer without ap...

Hi... I use version 6.6.2-RC Zeos with MYSQL 5.0.45. I have a TZQuery with the property Cached Updates = True. It is recommended to use the command COMMITUPDATES after the command APPLYUPDATES, as shown below: ZQuery1.ApplyUpdates; ZQuery1.CommitUpdates; If using only the command APPLYUPDATES the ch...

Hi I'm from Brazil, so sorry for bad english, I'm using google translator :-) Currently use Zeos 6.2rc with mysql 5.0.45 32bit and have a base with 600,000 records. I have two questions ... Would it be worth upgrading to 64-bit mysql?? Had a considerable increase in performance?? The version 6.2rc o...

hello

I'm from Brazil, so sorry for bad english, I'm using google translator:-). It has the Zeos delphi 7 with 6.2 rc installed.

Can I upgrade to version 6.6??

As my projects are already using 6.2rc, I have to put all the components again??

Thanks