Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot copy view cursor data to a table
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot copy view cursor data to a table
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01098273
Message ID:
01098273
Views:
63
We have data in a SQL table and I created a quick view to pull out a subset of data and then tried to do a COPY TO "tempfile.dbf" and I get an error: "No key columns are specified for the update table 'dbo.sqltablename'. Use the KeyFieldList property of the cursor."
There is no Key on the SQL table and so I can't check a field to make it a key field in MODIFY VIEW.

Any thoughts?
Next
Reply
Map
View

Click here to load this message in the networking platform