View Single Post
  #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