Re: Using Quoted Identifiers

On Tue, 16 Jun 1998 dant@wynalda.com wrote: > Is there a way to get Informix to allow statement using quoted > identifiers? Yes, but you really don't want to use it. Since you use DejaNews, hunt up DELIMIDENT and my name (not login ID) in comp.databases.informix somewhere in the last couple of months to see an extended description of what it takes and why you shouldn't try to use it. > I am using Powersite 1.0 connecting to Informix 5 via Openlink 3.0. > Powersite insists on building code such as the following: > > insert into dt_phone ("dt_phone"."name", "dt_phone"."email", "dt_phone"."org") > VALUES ("Fred","fred@company","company") There is no way that code will work even if you had delimited identifiers in use. Specific problems: 1. You can only specify the column names in the parenthesized list: INSERT INTO dt_phone("name", "email", "org") ... 2. If you use delimited identifiers, you can't use double quotes for strings. The double quotes mark delimited identifiers, and you cannot use identifiers in the VALUES clause of an INSERT statement. ... VALUES ('Fred', 'fred@company', 'company'); And, for curiosity's sake: 3. If you specify 'INSERT INTO dt_phone', why do you need to use the quoted form "dt_phone" in the column list? > I am getting an ODBC (-201 syntax) error being returned, but I have tried > the above statement in ISQL and it does not work there either. It looks to me as though you need something more recent than the 1.0 version of Powersite. Either that, or your transcription of the problem code is not as careful as it needs to be. Is there a URL for the product? Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN