Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View and Basic Foxpro commands.
Message
From
10/09/1999 14:54:00
 
 
To
10/09/1999 14:01:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00263449
Message ID:
00263489
Views:
18
>Remote views are driving me to drink!
>
>I have established a couple of remote views in a new application. They connect OK and fill up with the appropriate data when procedures run. Occasionally, I get update errors related to 'attempted to insert a primary key field' at silly times like at a GATHER MEMVAR or LOCATE command (this being before a TABLEUPDATE() is issued).

If your view is Row buffered (as opposed to table buffered) the contents are written to the source when the record pointer is moved. If you have specified your primary key field as updatable in the view definition, then moving the record pointer (as with a LOCATE) would cause this error.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform