----- Original Message -----
From: "monalisa" <monalisa@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, October 31, 2002 6:36 AM
Subject: [ib-support] IBX Applyupdated


> Hi All,
>
> I Just try migrate from using BDE to IBX. For use live query I already use
> TIBQuery conjunction with TIBUpdateSQL.
>
> The IBQuery is :
>
> 'SELECT
> RECID,NOREFF,AMOUNT
> FROM SALES'
>
> The IBIpdateSQL is :
>
> DeleteSQL :
> DELETE FROM SALES
> WHERE RECID =:OLD_RECID
>
> InsertSQL :
> INSERT INTO SALES
> (NOREFF,AMOUNT)
> VALUES
> (:NOREFF,:AMOUNT)
>
> ModifySQL :
> UPDATE SALES
> SET
> NOREFF=:NOREFF
> AMOUNT=:AMOUNT
> WHERE RECID=:OLD_RECID
>
> When I use : "Database1.ApplyUpdates([QrSALES]) ;" after inserted data, it's
> working good. The data is commited.
>
> But where I use the "Database1.ApplyUpdates([QrSALES]) ;" after edit or
> delete, there's error message :
>
> 'UPDATED FAIL. USER ABORT'
>
> and the query is rollback.
> What's wrong with my code ? There's I mis something ?
>
> Thx,
> Monalisa.
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>