Your basic VOC file pointer
Unix world:
001:F
002:/someplace/other/than/here/FILENAME
003:D_FILENAME
or Windows:
001:F
002:C:\someplace\else\FILENAME
003:D_FILENAME
I like the separate directory thing because then all of your ODBCized
stuff is in the same place and you are not cluttering up your production
dictionaries. I'm pretty sure I have an "A" type to "D" type conversion
program which which cleans up ODBC unfriendly stuff and writes to a
second dictionary, somewhere. I'll look for it Monday and send you a copy.
Bill Brutzman wrote:
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
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
