Working with CacheUpdate !!
Posted on 1998-05-31
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...