Zeoslib Portal

Posted: **29.07.2015, 12:25**

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

Posted: **31.07.2015, 12:32**

@Mando,

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

Michal

Posted: **03.08.2015, 10:18**

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.

Posted: **03.08.2015, 10:46**

@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

Posted: **03.08.2015, 11:32**

Hi again.

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

Regards,
Mando.

Zeoslib Portal

Chached Updates

Chached Updates

Re: Chached Updates

Re: Chached Updates

Re: Chached Updates

Re: Chached Updates