Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql fields with spaces in column name
Message
De
29/12/2008 15:58:07
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01369972
Message ID:
01369994
Vues:
8
>If that is using standard SQL Server syntax, then you should be using something like..
>
>cSQL = "select * from VRP_CONTACT where [CONTACT CONTACTID] = '" + crsrs.contact_opportunity_contactid + """
>
>Brackets around identifiers are SQL Server's way of handling illegal names.


Thanks, got it.

I suppose the fact that I haven't been coding in a while, and SQL Server was never actually in my skill set leads to all sorts of new problems for me!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform