sorentop
asked on
Cached updates
Hi
I have a query on a database on another computer.
I first call query.delete to delete a record (with conflicting index values) and then use batchmove to copy a record to the database.
This gives me a unique index error, when both databases are on the same computer there is no error.
Can this be caused by cached updates?
CachedUpdates for the query is false.
Will it help if I use query.refresh applyupdates commitupdates after calling query.delete ?
I have a query on a database on another computer.
I first call query.delete to delete a record (with conflicting index values) and then use batchmove to copy a record to the database.
This gives me a unique index error, when both databases are on the same computer there is no error.
Can this be caused by cached updates?
CachedUpdates for the query is false.
Will it help if I use query.refresh applyupdates commitupdates after calling query.delete ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It turns out to be something else, but I guess you don't mind that I accept the question anyway
No problem :)
I'm sory, but I'm unfamiliar with interbase. My answer was about Oracle, SQL, etc. Thanks, anyway :)
Rgds,
Frodo
I'm sory, but I'm unfamiliar with interbase. My answer was about Oracle, SQL, etc. Thanks, anyway :)
Rgds,
Frodo
ASKER