Thanks Wol... I appreciate it. --Bill
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wols Lists Sent: Friday, August 27, 2010 5:28 PM To: [email protected] Subject: Re: [U2] ODBC @ID Alias On 27/08/10 21:55, 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? What sort of dict items have you got? To me field 8 is sql data type (PI-style D or I). But standard advice when using ODBC is to create separate dictionaries specifically for ODBC, where you can use IDs without dots. The other thing you can do (which is also a big pain, but should be easy to automate...) is ED DICT FILE HK.PART.NBR FILE HK_PART_NBR boring, but if the dots break ColdFusion, necessary. ime UV can cope, but as you say, other stuff isn't expecting it ... it just clutters your dictionary :-( Cheers, Wol > --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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
