Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ZAPing a remote view
Message
From
06/06/2002 15:13:19
Patrick O'Neil
American Specialty Information Services
Roanoke, Indiana, United States
 
 
To
03/06/2002 17:44:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00663591
Message ID:
00665644
Views:
23
>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.


hi elmer -

read your message, but i haven't had a chance to experiment more
with it in order to answer your question accurately. have been
trying to get the oracle forms part up and runing quickly for a
demo by the end of the week.

want to investigate your question, because i want to understand
exactly how this all works.

more later,
patrick
Previous
Reply
Map
View

Click here to load this message in the networking platform