Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Thread Tools Display Modes
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

if rg1.itemindex=0 then begin
if form1.creDTPAGTO.IsNull then
else begin

but when I close and open the CRE query again all the updates are cancelled.
Reply With Quote
Old 02-25-2015, 12:38 PM
Denisy Denisy is offline
Junior Member
Join Date: Feb 2015
Posts: 4

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
Old 02-26-2015, 03:42 AM
lexd lexd is offline
Senior Member
Join Date: Feb 2015
Posts: 268
Default Zeos forum

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
as most C++ use this approach

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

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 04:06 AM.

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