Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-07-2013, 05:36 PM
raosistemas raosistemas is offline
Junior Member
 
Join Date: Apr 2013
Location: Sao Paulo - Brazil
Posts: 3
Default 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
Reply With Quote
 

Tags
cxgrid, query, zeos

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:58 PM.


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