>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?
You cannot update w/o keyfields. Check all if there is none.
But I didn't understand why would you ever need an updatable view if your only intent is to copy some data from it to a local table. You might think of SQLExec() too.
Cetin