Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field's Caption on SQL Server?
Message
 
 
To
21/05/2001 23:46:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509762
Message ID:
00509827
Views:
17
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform