Re: Class::DBI::Sqlite

[prev] [thread] [next] [Date index for 2005/03/17]

Hi,

I uploaded a new version of Class::DBI 0.08, which is available at:
http://bulknews.net/lib/archives/Class-DBI-SQLite-0.08.tar.gz

It now uses regexp rather than SQL::Parser, which I guess allows you to
use the following SQL syntax.

try that and give me your feedback.

On Tue, 01 Feb 2005 10:01:55 +0100
Daniel Wijnands <daniel@xxxx.xx> wrote:

> Hello, 
> 
> I'm having trouble setting up a table use class::dbi::sqlite
> Table create with te following syntax : 
> 
>     272 CREATE TABLE modulemode (
>     273   momId INT PRIMARY KEY,
>     274   modId int DEFAULT 0,
>     275   momName varchar ,
>     276   momDescription text
>     277 );
> 
> if is try to include my DBI class i get the following error : 
> 
> SQL ERROR: Unknown column constraint: 'DEFAULT'!
> 
> SQL ERROR: Unknown column constraint: 'DEFAULT'!
> 
> 
> When is use the following create statement :
> 
>     272 CREATE TABLE modulemode (
>     273   momId INT PRIMARY KEY,
>     274   modId int ,
>     275   momName varchar ,
>     276   momDescription text
>     277 );
> 
> It all goes well, my question is, what schema is supported using
> Class::DBI::Sqlite 
> 
> Kind regards daniel 

        -- 
        Tatsuhiko Miyagawa <miyagawa@xxxxxxxx.xxx>