All dba ..
I have table (myurut) :
Field. : LOK. ORD
Record: 00 301
01. 100
02. 100
03. 501

And I have code :

IBclientdts.close;
IBclientdts.commandtext:="Select * from myururt where lok='01'
IBclientdts..open;
IBclientdts..edit;
IBclientdts.["Ord"]:=Bclientdts.["Ord"]+1;
Bclientdts.post;
Bclientdts.applyupdate(-1);
** status error -more then affected-

But with this code :
Ibquery.close;
Ibquery.sql.clear;
Ibquery.sql.add("update myurut set ord=ord+1 where lok="01"
Ibquery.execsql;

** status OK

This case, after I add manually ( record 2-4 ) with ibmanager

So... Why I found some error (.. Morethan affected)
Tq..
Regard
Allies xposs
Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!