Just wondering if anyone having the following problem using obdc with Db2 in the XP environment:

I am having problem deleting record in a db2 table. The problem only exist if the there were no match for the where clause and only happen on XP environment.

The code as follow:

sqlexec(1,'delete from my.table where product=1')

In XP DB2 will return an error since there is no records for deletion. In win2k this statement will work fine.

Does anyone have any ideas what's wrong ?

Any suggestion is appreciated.

Thanks.