Mysql Table Post

[mbranco]

Hi.

I have a small application to process invoices.

I create the invoice, but when a change the values the invoice table still have the last value.

I have tried to commit data, but the table still have the firts values.

What are the problem???

I use D7, Mysql 5, ZeosLib 6.5.1.

Code:


zroqCalc.Close;
zroqCalc.Sql.Clear;
zroqCalc.Sql.Add(SQL STATEMENT );
zroqCalc.Open;
ztDocumentos.edit;
ztDocumentosdesconto.Value := zroqCalcsumvdesconto.Value;
ztDocumentosTotalIva.Value := zroqCalcsumviva.Value;
ztDocumentosTotaliLiquido.Value := zroqCalcsumPIliquido.Value;
ztDocumentosTotalDoc.Value := zroqCalcsumPIliquido.Value - zroqCalcsumvdesconto.Value + zroqCalcsumviva.Value;
ztDocumentos.Post;

Thank's in advance

MB

[mbranco]

ztDocumentos is a ZTable componen
and zroqCalcs is a zreadonlyquery component

[pol]

Hi!

After ztDocumentos.Post you have to add
ztDocumentos.ApplyUpdates
Only this will bring the posted data finally into the database. It took me some time too to get to that (thanks to the old forum).

HTH
Rüdiger

[btrewern]

That should only be true if you have CachedUpdates = True on your dataset. Otherwise there's a problem there.

Ben

[pol]

Hi Ben!

What kind of problem? I never use CachedUpdates = True, but without ApplyUpdates... nothing in the database, as mbranco has experienced.

[btrewern]

If you see the documentation for TBDEDataSet you'll see:

"Call ApplyUpdates to write a dataset’s pending cached updates to a database."

I assume zeoslib uses ApplyUpdates in the same way. Also I've been using Zeos now for some years against PostgreSQL and never had to call ApplyUpdates.

Regards,

Ben

[zippo]

Can you write the SQL used for data acquiring into the Query component?