Search results for query: *

Agreed, using Fetch produces that error, but FetchLock does not. That atleast saves me from having to put a trigger into the database to fix this. Is there any way to ensure that the first user to get the data has exclusive access to that data? User 1: Starts transaction User 1: Gains...

The problem with using fetch to update a single record is that it leaves a race condition in the code in a multi-user environment. For example: User 1: Fetches data to update - 1 User 2: Fetches data to update - 1 User 1: Updates data - (Adds 1) - 2 User 2: Updates data - (Adds 4) - 5 Data is...

I have tried both setting the index for the view and using the default. (The Index to use is index 0, which is the default anyway). FetchLock's reflex did not change in either case. As for the return code, Fetchlock is defined to return a bool (0 for false, !0 for true). Most of the api...

I’m new to AccPac programming but have had smooth sailing up to this point. I’m currently calling the AccPac COMAPI (v5.3.a) from a C++ program. I can access the database and manipulate the data there. My snag is when I call FetchLock. After calling FetchLock the row is *not* locked until I...