zahzia
asked on
Working with CacheUpdate !!
Hi,
I am working in delphi 3.0 using 'Paradox' ..I have two tables which are order_master and order_detail and i have a form in which both have master detail relationship i mean its a master detail form using the above tables..and cahcheupdate property is true in both tables.
So in case of keyviolation in detail table I want to trap this keyviolation on order_detail but you know when cahcheupdate is true then it wont work coz changes are going in a temporary area...not physically...so is there any method of preventing duplicate values in detail when cacheupdate is true...
your help in this matter will higly appreciated...
thanks,
Zahid
I am working in delphi 3.0 using 'Paradox' ..I have two tables which are order_master and order_detail and i have a form in which both have master detail relationship i mean its a master detail form using the above tables..and cahcheupdate property is true in both tables.
So in case of keyviolation in detail table I want to trap this keyviolation on order_detail but you know when cahcheupdate is true then it wont work coz changes are going in a temporary area...not physically...so is there any method of preventing duplicate values in detail when cacheupdate is true...
your help in this matter will higly appreciated...
thanks,
Zahid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.