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

[<pko...@me...>]

Hello Daniel,

yes, that works fine. It seems that ib_dialect=3D3 makes the difference. =
Sorry
for my stupid problem. Next time I have a closer look at the POD of
DBD::InterBase.

Thank you,

Peter

> -----Urspr=FCngliche Nachricht-----
> Von: dbi...@li...
> [mailto:dbi...@li...]Im Auftrag von
> Daniel Ritz
> Gesendet am: Sonntag, 29. Juli 2001 16:11
> An: dbi...@li...
> Betreff: Re: [Dbi-interbase-devel] Quoted Identifiers don't work?
>
> 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 =3D DBI->connect("DBI:InterBase:db=3Dc:\\temp\\test.gdb;ib_dial=
ect=3D3",
>                        '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=F6ller" <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
> >
>
>
> _______________________________________________
> Dbi-interbase-devel mailing list
> Dbi...@li...
> http://lists.sourceforge.net/lists/listinfo/dbi-interbase-devel
>