Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need to alias SQL column - reserved word
Message
De
15/09/2008 15:47:36
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Need to alias SQL column - reserved word
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01347748
Message ID:
01347748
Vues:
55
An existing non changeable table has a column defined as DESC which is a reserved word. When I try to run the SQL UPDATE statement it fails.

I tried SET [desc] = "zzz"

Tried a macro no luck

CREATE CURSOR xx ( desc v(10))
INSERT INTO xx values('11111')
UPDATE xx SET desc = "zzz" --- this line does not work

How can I get around this?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform