Re: [Dbi-interbase-devel] Quoted Identifiers don't work?

[Daniel R. <dan...@gm...>]

hello

hmm.... it works for me! what version of interbase do you have?
older versions of interbase doesn't support quoted identifiers. the view metadata window in ibconsle
generate the code itself from metadata (it is not generated by interbase) and does quote all identifiers.

the following code works for me using interbase 6.0, dbd-interbase 0.28.x, perl 5.6.1 on win2k / linux.

regards
-daniel

the code:
-----------------------------------------
#!/usr/bin/perl
use strict;
use DBI;

my $dbh = DBI->connect("DBI:InterBase:db=c:\\temp\\test.gdb;ib_dialect=3",
                       'sysdba', 'masterkey');

$dbh->do(qq{
CREATE TABLE "ITEMS" (
 "ID"      INTEGER     NOT NULL,
 "TITLE"   VARCHAR(45) NOT NULL,
 "INTEGER" INTEGER     NOT NULL,
 "ITEM_ID" VARCHAR(15) NOT NULL,
 CONSTRAINT "PKEY_ITEMS_ID" PRIMARY KEY ("ID")
)});

$dbh->disconnect
----------------------------------------------

----- Original Message -----
From: "Peter Köller" <pko...@me...>
To: <dbi...@li...>
Sent: Sunday, July 29, 2001 12:26 PM
Subject: [Dbi-interbase-devel] Quoted Identifiers don't work?


> Hello,
>
> I quote my identifiers so that they don't conflict with InterBase key words
> or data types. The following doesn't work with InterBase, although it works
> if entered through the InterBase console. The Database/View Metadata command
> shows quoted identifiers, too.
>
>   $db->do(qq{
> CREATE TABLE "ITEMS" (
>  "ID"                       INTEGER     NOT NULL,
>  "TITLE"     VARCHAR(45) NOT NULL,
>  "ITEM_ID"             VARCHAR(15) NOT NULL,
>  CONSTRAINT "PKEY_ITEMS_ID" PRIMARY KEY ("ID")
> )})
>
> Is there any workaround?
>
>
> Thanks, in advance,
>
> Peter
>
>
> _______________________________________________
> Dbi-interbase-devel mailing list
> Dbi...@li...
> http://lists.sourceforge.net/lists/listinfo/dbi-interbase-devel
>