Jeff: I like this separate idea.
What would an example pointer thing look like? --Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Schasny Sent: Friday, August 27, 2010 6:04 PM To: U2 Users List Subject: Re: [U2] ODBC @ID Alias I'll second the recommendation for ODBC only dictionaries. I would even suggest you create a separate account with pointers to the data and keep all your ODBC dictionaries there. Wols Lists wrote: > 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 > > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ------------------------------------------------------------------------ _______________________________________________ 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
