Did you try "select evaluate('Mail Label') as mlabel from dbstaff " ??
Have not tried it since I NEVER use long field names, but maybe using
the evaluate function will work
Rafael Copquin
El 15/04/2015 a las 11:31, Joe Yoder escribió:
The help so far has given me the tools to figure out how to create a
translation table but I still don't know what syntax to use when I want to
write an SQL Select specifying the fields I want using the long name form.
Examples: "Select Mail Label from DBSTAFF " complains that Mail cant be
found, "Select 'Mail Label' from DBSTAFF " gives me "Mail Label" rather
than the field contents, and "Select ('Mail Label') from DBSTAFF " also
gives me "Mail Label."
I expect it is just a case of learning a syntax I haven't tried but perhaps
one must use the 10 character form of the filed name. If some one can
enlighten me it will be greatly appreciated!
Thank you
Joe
On Wed, Apr 15, 2015 at 7:19 AM, Richard Kaye <[email protected]> wrote:
ADBOBJECTS() can also be useful.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Jean
MAURICE
Sent: Wednesday, April 15, 2015 6:03 AM
To: [email protected]
Subject: Re: Data Dictionary questions
Joe,
have a look at AFIELDS() and COPY STRUCTURE EXTENDED ...
HTH
The Foxil
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
