Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 02-25-2015, 12:38 PM
Denisy Denisy is offline
Junior Member
 
Join Date: Feb 2015
Posts: 4
Default

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.
Reply With Quote
  #3  
Old 02-26-2015, 03:42 AM
lexd lexd is offline
Senior Member
 
Join Date: Feb 2015
Posts: 268
Default 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

Last edited by lexd; 02-26-2015 at 04:15 AM.
Reply With Quote
Reply

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:20 PM.


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