Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote Views
Message
 
 
À
27/09/2004 12:27:26
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00946321
Message ID:
00946475
Vues:
13
The workaround is to use the AS clause
select mytable.desc as mydesc, mytable.otherfield

DESC is a reserved word.

regards
>All,
>
> I have an application that will be accessing a remote database. One of the fields has the name "desc". When I create a remote view in VFP 7 and browse the data I recieve the following error message: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'desc'. What work arounds are there for this bug?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform