To use the dictionary in any of the SQL environments you should use a
clean dictionary that doesn't have any characters that would break SQL.
This can be done by creating a separate field just used for SQL with no
characters that will break SQL or if you currently don't use the
dictionary much, to change all of your items to conform. That includes
using "D" and "I" types instead of "A" and "S" types. Another way is to
have a separate dictionary and use the "USING" option when using a
select or sort.
Jerry
On 8/27/2010 3:55 PM, Bill Brutzman wrote:
1. Thanks Wol... That worked.
2. Now a new related problem. The data dictionaries have tons of items with dots...
like... HK.PART.NBR. The ColdFusion source code seems to want to use the dots for
object notation. Do I have to go into field<8> of all of the dictionary items
and replace the dot there with say an underscore?
--Bill
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wols Lists
Sent: Friday, August 27, 2010 2:23 PM
To: [email protected]
Subject: Re: [U2] ODBC @ID Alias
On 27/08/10 18:35, Bill Brutzman wrote:
Is there a way to create an ODBC synonym for "@ID" ( like just "ID")... dropping the "@" character
? Thus, an external an ODBC SELECT statement would show the column heading as "ID" instead of "@ID".
The wizard .cfc code generator with the new ColdFusion Builder for ORM gags on the
"@" character.
Suggestions would be appreciated.
ED DICT FILE @ID
SAVE ID
(then add it to the relevant @list)
Cheers,
Wol
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
