Cannot copy view cursor data to a table

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Cannot copy view cursor data to a table

Message

22/02/2006 16:52:51

Douglas Symes
Qualbe Marketing Group
Fort Worth, Texas, États-Unis

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Cannot copy view cursor data to a table

Versions des environnements

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

01098273

Message ID:

01098273

Vues:

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?

Répondre

Fil

Voir

Click here to load this message in the networking platform