Delphi Pages Forums

Delphi Pages Forums (http://www.delphipages.com/forum/index.php)
-   DB Tools (http://www.delphipages.com/forum/forumdisplay.php?f=7)
-   -   Using ZEOS, update problem, mysql (http://www.delphipages.com/forum/showthread.php?t=215507)

raosistemas 05-07-2013 05:36 PM

Using ZEOS, update problem, mysql
 
I have this sql in cre Tzquery component.

SELECT m.processado, m.AUTOMATICO,m.DOCNF,m.CODCF,m.DTEMIS,m.DTVCTO,m.V ALOR,m.DTPAGTO,m.obs, m.numeros,
m.VLRPAGO,m.PARC,m.TPARC,m.CONTA, m.loja,m.ch_banco,m.ch_agencia,m.ch_conta,
m.ch_numerocheque, m.nomedigitado,
(select cl.fantasia from clientes cl where m.codcf=cl.codigo limit 0,1) as fantasia
FROM movto m
where m.TIPO = 'C' and processado=1
order by DTVCTO desc


in my code i use... this procedure to save the information... payment information

form1.cre.edit;
if rg1.itemindex=0 then begin
form1.creVLRPAGO.value:=form1.creVALOR.value;
if form1.creDTPAGTO.IsNull then
form1.creDTPAGTO.value:=date;
end
else begin
form1.creVLRPAGO.clear;
form1.creDTPAGTO.clear;
end;
form1.cre.post;
form1.cre.CommitUpdates;
cred_editar.close;
end;


but when I close and open the CRE query again all the updates are cancelled.
Thanks

Denisy 02-25-2015 12:38 PM

In that case, when you are out of options it is useful to have a dedicated support from development team of component you use. That's why I choose MyDAC with a very quick response for help.

lexd 02-26-2015 03:42 AM

Zeos forum
 
http://zeoslib.sourceforge.net/viewforum.php?f=40

Is a better qualified forum, you got further than me.
I understand Zeos uses the ODBE that was common on Delphi 4 years ago
and not accurate with string data, moderately slow.

ODBE does work but if you want a better result use something else is my advice.
The ADO is common to Delphi and fast.
I see most C++ projects use 'localhost' as linking is not file dependant
Zeos is file dependant that's no good for a final product.

We get what we pay for. It's like Indy 10 that's nearly ten yeas old and its not fully working yet.;)

Read this thread too http://www.delphipages.com/forum/sho...d.php?t=216412
as most C++ use this approach


All times are GMT. The time now is 07:39 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.