Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field's Caption on SQL Server?
Message
 
 
À
21/05/2001 23:46:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00509762
Message ID:
00509827
Vues:
18
>Hi Everybody!
>
>In VFP's DBC we can assign a caption to every field, and use it programmaticaly. Is there such thing on SQL Server? If so, how could I use it?

Because SQL Server supports long, descriptive field names, there really is no need for this, IMO. You just need to access the fields using []. Ex.
lcsqlexec = 'select [tablename].[long field name here with spaces] from tablename'
=sqlexec(nconnection,lcsqlexec,'mycursor')
JMO.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform