On Fri, 21 Mar 2008 08:54:22 +0100, you wrote:
>I actually created all my views by means of "CREATE VIEW ... AS ...", and
>(as Mr. Hipp said) these views was accepted from SQLite as "valid" SQL
>statements.
>The problem (was) that right now I couldn't open the DB anymore, due to the
>malformed
On Fri, Mar 21, 2008 at 10:12 AM, Noah Hart <[EMAIL PROTECTED]> wrote:
> Suggestion to SQLite Developers ... Have PRAGMA integrity_check reparse
> the SQL in sqlite_master, looking for errors.
>
> Regards,
>
> Noah
I don't think that would actually help. It seems that this problem
was caused
of SQLite Database
Subject: Re: [sqlite] Malformed database schema with SQLite version >
3.5.x
I actually created all my views by means of "CREATE VIEW ... AS ...",
and
(as Mr. Hipp said) these views was accepted from SQLite as "valid" SQL
statements.
The problem (was) that ri
I actually created all my views by means of "CREATE VIEW ... AS ...", and
(as Mr. Hipp said) these views was accepted from SQLite as "valid" SQL
statements.
The problem (was) that right now I couldn't open the DB anymore, due to the
malformed schema error.
Thanks again
Marco
Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
> >I know I can't create an invalid view,
> >because SQLite refuses to create it,
> >but this seems a problem to me... could SQLite just open the database, and
> >complain only on the invalid views (i.e. for instance when I open the view
> >to query the data
On Thu, 20 Mar 2008 10:23:23 +0100, you wrote:
>...oopss.. I supposed it was a fault of mine.
>Thanks for the support and the help.
>
>Just two points:
>
>1. the "PRAGMA writable_schema=ON" is not described in
>the "official" documentation for the PRAGMA syntax
It's not a supported PRAGMA. In
...oopss.. I supposed it was a fault of mine. Thanks for the support and the
help.
Just two points:
1. the "PRAGMA writable_schema=ON" is not described in the "official"
documentation for the PRAGMA syntax
2. does this mean that if I create an invalid view in the database, the
entire database
MarcoN <[EMAIL PROTECTED]> wrote:
> Hello, everybody.
>
> I have the following problem: I have an old project that uses a database
> created with an older SQLite library version.
> Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
> because any query on the database tables
MarcoN <[EMAIL PROTECTED]> wrote:
> Yes, of course I can send you the DB: the file is under 1MB, about 100K if
> compressed via .zip
> Can I send it to you via e-mail?
> Thanks very much for the support
>
Please send the database directly to my email address shown below.
--
D. Richard Hipp
Yes, of course I can send you the DB: the file is under 1MB, about 100K if
compressed via .zip
Can I send it to you via e-mail?
Thanks very much for the support
On Tue, Mar 18, 2008 at 1:10 PM, <[EMAIL PROTECTED]> wrote:
> MarcoN <[EMAIL PROTECTED]> wrote:
> > I actually don't know how to export
Yes, of course I can send you the DB: the file is under 1MB, about 100K if
compressed via .zip
Can I send it to you via e-mail?
Thanks very much for the support
___
sqlite-users mailing list
sqlite-users@sqlite.org
MarcoN <[EMAIL PROTECTED]> wrote:
> I actually don't know how to export it, because "SQLite Database browser"
> (that is able to open the database and execute the query) has no way to
> export it; SQLiteSpy will not open the database because it is compiled with
> a new SQLIte library version
>
I actually don't know how to export it, because "SQLite Database browser"
(that is able to open the database and execute the query) has no way to
export it; SQLiteSpy will not open the database because it is compiled with
a new SQLIte library version
Maybe I can try to find an older version of
MarcoN <[EMAIL PROTECTED]> wrote:
> Hello, everybody.
>
> I have the following problem: I have an old project that uses a database
> created with an older SQLite library version.
> Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
> because any query on the database tables
14 matches
Mail list logo