>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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao