Chached Updates

[Mando]

Hi all.

I've a grid attached to a zQuery in cahchedUpdates mode.
The table has a Key field. I can insert and modify recors without problems, using a button with this code in Click event:

Code: Select all

 with zqP do
  if UpdatesPending then
  begin
    ApplyUpdates; CommitUpdates;
    Refresh;
 end;
 

but, if I delete every records in the grid, and insert new records with values for key field previously used and push the save button, I get a "Duplicate Key error message". I guess that will be because the inserts are made before the deletes when applyUpdates is executed.

How I solve this issue?

zeos 7.1.3-stable
firebird 2.5.3

Thanks

[miab3]

@Mando,

Zeos 7.1.3-stable is strongly outdated, try Zeos 7.2 svn 3636.

Michal

[Mando]

Hi:

Thanks for your answer, Michal.

Zeos 7.2 svn 3636. is in beta phase.
Is it safe for production application ??
Is it the same than Zeos 7.2 svn 3637 ??


regards.

[miab3]

@Mando,

Zeos 7.2 svn 3636. is in beta phase.
Is it safe for production application ??

In my opinion Zeos 7.2 svn 3636(3637) is safer and better than versions ZEOSDBO-7.1.4-stable.

Is it the same than Zeos 7.2 svn 3637 ??

Yes, it can be svn 3637 (marginal change).

Michal

[Mando]

Hi again.

Thanks Michal.
I'll try it as soon as possible.


Regards,
Mando.