Solved

Cached updates

Posted on 2001-08-03
4
233 Views
Last Modified: 2010-05-18
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 ?
0
Comment
Question by:sorentop
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
FrodoBeggins earned 100 total points
ID: 6351090
What is your database? Try commiting the transaction (Database.Commit;)
Also try wit the BDE alias parameters (if you use BDE). Try changing the values of SQLQRYMODE and SQLPASSTHRU MODE. And the CACHE-related parameters also.

Rgds,
Frodo
0
 

Author Comment

by:sorentop
ID: 6351174
it is interbase
0
 

Author Comment

by:sorentop
ID: 6357321
It turns out to be something else, but I guess you don't mind that I accept the question anyway
0
 
LVL 2

Expert Comment

by:FrodoBeggins
ID: 6358351
No problem :)
I'm sory, but I'm unfamiliar with interbase. My answer was about Oracle, SQL, etc. Thanks, anyway :)

Rgds,
Frodo
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now