Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating multiple records from a local view
Message
From
28/06/1998 23:12:55
 
 
To
28/06/1998 18:46:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00112351
Message ID:
00112369
Views:
14
>I want to update multiple records in local views by reusing deleted records when possible. I have tried deleting all records in my local view based on its requery of the base table, recalling a record as it is needed for updating the base table, and updating with a replace. When I attempt this I get an error message stating that I have a attempted to add a duplicate primary key. During debug it appears the view record is not updating the same record in the base table, but this doesn't make sense to me, since the primary key in the view should identify the proper record to recall and update.
>
>If you are confused by my description of the problem, your techniques for updating multiple records from a local view with the reuse of deleted records would be very helpful I'm sure.
>
>I certainly appreciate your help.
>
>Thanks in advance.

Add a filter to you primary key index "NOT DELETED()".
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform