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 <[email protected]>: > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user >
Sample_Sqlite-0.0.1.tar.gz
Description: GNU Zip compressed data
------------------------------------------------------------------------------
_______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
