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.
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
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
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
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
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
Thanks Wol... I appreciate it.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Friday, August 27, 2010 5:28 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] ODBC @ID Alias
On 27/08/10
Jeff:
I like this separate idea.
What would an example pointer thing look like?
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Friday, August 27, 2010 6:04 PM
To: U2 Users List
Subject:
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
Hi all!
I ran into a situation with Wintegrate (version 5.1) today. I added a
Generic/Text printer to my system (WinXP) so I could capture the output
of some slave printing. The problem was that Wintegrate only seems to see
the printers that had been defined on the PC when I installed
Thanks Jeff
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Friday, August 27, 2010 6:51 PM
To: U2 Users List
Subject: Re: [U2] ODBC @ID Alias
Your basic VOC file pointer
Unix world:
001:F
Thanks Jerry...
I have not tried it yet to see how ODBC, JDBC, SQL handles VM. Advance info
would be appreciated.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry
Sent: Friday, August 27, 2010 5:54
On 27/08/10 23:51, Jeff Schasny wrote:
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
On 28/08/10 00:23, Bill Brutzman wrote:
Thanks Jerry...
I have not tried it yet to see how ODBC, JDBC, SQL handles VM. Advance info
would be appreciated.
One other point, I've forgotten what it's called ... what's the new
connection technology? It might be OleDB, but anyway, ODBC is now
14 matches
Mail list logo