Re: Access to Other ODBC database

>From: Hans Forbrich <forbrich@tibalt.supernet.ab.ca> >Date: Sat, 08 Mar 1997 21:45:51 -0700 >X-Informix-List-Id: <news.34995> > >Pete Cresswell wrote: > >>Do yourself a big favor. >>Byte the bullit and remove the spaces and special characters from your >>column names right now. > >And be advised that there are reliable utilities that you can use to >automate the task. Speed Ferret and Replace come to mind.. > >Although I totally agree with the above, you might try using escape >characters or quoting the names. Oracle does allow this, using double >quotes BUT they strongly advise against it & you will too since every >reference to the tables and columns will require the double quotes. In later versions of OnLine and SE, you can do it with Informix too. You set the environment variable DELIMIDENT, and then you can write preposterous statements, provided that you use double quotes consistently around identifiers (especially those with blanks etc in them, or column names which are case sensitive), and you use single quotes exclusively to enclose string literals. SELECT * FROM "SomeUser"."Widget Table" A, "OtherBod"."Some Other Table" B WHERE A."Primary Key Column" = B."Foreign Key Column" If you try doing this with I4GL, I guarantee that you'll either be grey or bald (depending on how hard your tear your hair) before you get it all working. I4GL has a constitutional preference for double quotes, and won't work under DELIMIDENT. It says so in the release notes, and it isn't joking. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>