On Wed, 07 Aug 2013, Beno?t Minisini wrote: > Le 05/08/2013 16:22, Tobias Boege a ?crit : > > Hi, > > > > we have a case at http://gambas-club.de where one uses an SQLite3 database > > with some fields being of type VARYING CHARACTER(255). These are all shown > > to be Booleans by Gambas code. Note that the TEXT type apparently is handled > > correctly. > > > > I have absolutely no idea of the Gambas DBMS drivers, therefore seek an > > explanation (or fix). > > > > Minimal project and the database attached. > > > > Regards, > > Tobi > > > > The Gambas <-> Database datatype mapping is detailed there: > > http://gambasdoc.org/help/doc/db-type-mapping?v3 > > But SQLite is special as the field datatype has no real meaning for it > (every field can store anything), it is just a string description. > (Actually it is not 100% true, look in the SQLite documentation). > > I will look at the Gambas sqlite drivers to see how they interpret > "VARYING CHARACTER(255)"... >
I fixed this in #5813. Regards, Tobi ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user