Mr. Cariotoglou,
I had two tables with unusual schemas. These schemas were acceptable to
SQLite but I perhaps I should not have expected Sqlite3Explorer to allow
them. The schemas look like the following example:
CREATE TABLE dataset_version
(
version_id smallint not null ,
name varchar(32) not null ,
version_date datetime year to the second not null ,
ship varchar(9),
lcm varchar(5),
creator varchar(32)
);
The data type for version date was intended as a comment. I changed it
to read:
version_date datetime not null ,
and my problem went away.
BTW, I really like Sqlite3Explorer. Thank you for a very good product.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-----Original Message-----
From: Cariotoglou Mike [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 4:56 PM
To: [email protected]
Subject: RE: [sqlite] Sqlite3explorer can't open my DB
Could you please let me know what the problem was ? I am the author of
sqlite3Explorer, and perhaps I could fix it.
> -----Original Message-----
> From: Downey, Shawn [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 17, 2005 11:45 PM
> To: [email protected]
> Subject: RE: [sqlite] Sqlite3explorer can't open my DB
>
> Thanks anyway. I solved this myself.
>
> Sqlite3Explorer is more particular about the table schema
> syntax than Sqlite.
>
> Shawn M. Downey
> MPR Associates
> 632 Plank Road, Suite 110
> Clifton Park, NY 12065
> 518-371-3983 x3 (work)
> 860-508-5015 (cell)
>
>
> -----Original Message-----
> From: Downey, Shawn
> Sent: Tuesday, May 17, 2005 12:28 PM
> To: [email protected]
> Subject: [sqlite] Sqlite3explorer can't open my DB
>
> Version 1.4 of Sqlite3explorer could not open my database.
> The error message is:
>
>
>
> 4:malformed database schema - near "to": syntax error
>
>
>
> An older version of Sqlite3explorer worked fine on this
> database. I am using sqlite.dll version 3.2.1. Does anyone
> else have problems with Sqlite3explorer?
>
>
>
> Shawn M. Downey
>
> MPR Associates
>
> 632 Plank Road, Suite 110
>
> Clifton Park, NY 12065
>
> 518-371-3983 x3 (work)
>
> 860-508-5015 (cell)
>
>
>
>
>
>
