Re: SQL::Statement::Embed example failing

Jens,

Actually, the documentation says:

"SQL::Statement is the basis for at least eight existing DBDs (DBI database
drivers). If you have a new data source, you too can create a DBD without
having to reinvent the SQL wheel. It is fun and easy so become a DBD author
today!"

This particular bug report relates to SQL::Statement module only. My
apologies for mentioning AnyData out of context.

Regards,

Soren

On Thursday, November 7, 2013, Jens Rehsack wrote:

>
> Am 07.11.2013 um 14:04 schrieb Søren Døssing <[email protected]<javascript:;>
> >:
>
> > Hej Jens,
>
> Hi Søren,
>
> > Can I disturb you again. Since AnyData doesn't seem to be going anywhere,
>
> Well, joint with Sven and Theo and go on hacking.
> Of course you can count on me answering questions and guide you as good as
> I can.
>
> > I'm looking at writing own DBD drivers.
>
> Documentation say’s: don’t! - from my point of view, if AnyData and
> DBD::AnyData
> will do for you once fixed, don’t end like DBD::PO or DBD::SNMP - do the
> right
> thing and work on AnyData and DBD::AnyData.
>
> > I tried out the examples on
> http://search.cpan.org/~rehsack/SQL-Statement-1.405/lib/SQL/Statement/Embed.podbut they don't work. The DBD::Foo example gives the following error message:
> >
> > --- snip ---
> > wit:bin sauber$ perl -I../lib dbdfoo.pl
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 434.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 435.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 449.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 479.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 479.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 479.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBD/File.pm
> line 196.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 612.
> > Use of uninitialized value $drv_prefix in concatenation (.) or string at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 612.
> > DBD::Foo::st execute failed:
> > Execution ERROR: Table 'group_id' already exists..
> >
> >  at
> /opt/local/lib/perl5/site_perl/5.12.4/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 1239.
> >  [for Statement "    CREATE TABLE group_id (username CHAR,uid INT, gid
> INT)"] at dbdfoo.pl line 17.
> > wit:bin sauber$
> > --- snap ---
> >
> > I tried a variety of operating systems and perl versions and always get
> same error message.
> >
> > Any chance you can lead me along the way?
>
> I recommend you check the
> http://search.cpan.org/dist/DBI/lib/DBI/DBD/SqlEngine/Developers.pod & Co
> documents.
> SQL::Statement has only a rough example which should demonstrate howto use
> S::S when you already know how to develop a DBD.
>
> Cheers
> --
> Jens Rehsack
> [email protected] <javascript:;>
>
>
>
>
>
>