Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Implicity Updating Base Table?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Remote View Implicity Updating Base Table?
Miscellaneous
Thread ID:
00454924
Message ID:
00454924
Views:
53
I am having problems with a parameterized remote view of a SQL Server table. I have parameterized the view to return only one record, based on it's primary key. There is a PK restraint on the SQL Server table. If I issue:

USE rv_IndexRun NODATA
APPEND BLANK
BROWSE

I get an error message from VFP:

Cannot insert an empty row from a view into its base table(s)

Why is the BROWSE triggering an update?
Chris McCandless
Red Sky Software
Next
Reply
Map
View

Click here to load this message in the networking platform