[Gambas-user] Sqlite3 Driver changed?

[Jorge Carrión]

Tobi:
You're right. Excuse me.
I'm using the 3.5.4 version of the stable repository of nemh (now
deprecated, I think...).
Attached a little proyect showing what I mean.
I've testing the database with SqliteMan application and respond ok to the
copy-paste pragma instruction.

Thanks


2014-08-15 12:15 GMT+02:00 Tobias Boege <taboege at ...626...>:

> On Fri, 15 Aug 2014, Jorge Carri??n wrote:
> > Since a lot of time I've been using this code with Sqlite3 databases in
> > order to identify the keys and other information about Sqlite3 tables.
> >
> > dim rs as result
> >
> > rs = rsDatos.Connection.exec("PRAGMA table_info(`" & tabla & "`)")
> >
> >
> > It have been working right from several years.
> > Now It returns a not Available Result with 0 fields
> >
> > Someone knows if something has changed on sqlite3 driver?
> >
>
> The answer depends. Quite some things changed in the driver since 2006
> apparently -- not so many recently. If you have a look at the commit logs,
> the last 2 things done in gb.db.sqlite3 were:
>
> --8<-----------------------------------------------------------------------
> r6230 | gambas | 2014-04-05 23:22:43 +0200 (Sat, 05 Apr 2014) | 5 lines
>
> [CONFIGURATION]
> * NEW: Do not use deprecated autoconf macros anymore.
> * NEW: The version information is now located in the 'version.m4' file in
>   the source root directory.
>
> ------------------------------------------------------------------------
> r5977 | gambas | 2013-12-03 15:36:19 +0100 (Tue, 03 Dec 2013) | 3 lines
>
> [GB.DB.SQLITE3]
> * BUG: Fix crash due to last commit.
>
> --8<------------------------------------------------------------------------
>
> So except for a configuration file change, the last work was in late 2013.
> But only you know what your last working Gambas version was, so only you
> can
> find out what exactly changed...
>
> Also, if you didn't do it yet, check the database with the sqlite3 program
> so that we can rule out a corrupted database as the cause. If your database
> is OK, it could be a bug. And as always it would help to send a project
> which shows the behaviour.
>
> Regards,
> Tobi
>
> --
> "There's an old saying: Don't change anything... ever!" -- Mr. Monk
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Sample_Sqlite-0.0.1.tar.gz
Type: application/x-gzip
Size: 32307 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20140815/76605d96/attachment.bin>