Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ZAPing a remote view
Message
From
03/06/2002 17:44:56
 
 
To
03/06/2002 14:54:36
Patrick O'Neil
American Specialty Information Services
Roanoke, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00663591
Message ID:
00664271
Views:
30
I'm curious. When you get the primary key validation error, is it on delete or tableupdate()? Does it occur only when you have added records that have not been updated to the underlying table when you try to delete them? If so, you might need to issue tablerevert(.t.) to revert any added records not yet updated to the underlying table, then do delete all and tableupdate. It sounds like you may have a newly added record that is missing a primary key value (or has a duplicate PK value) that is attempting to be added to the underlying table before being deleted when you issue tableupdate.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform