[Gambas-user] sqlite3 test database

[Alan Bromley]

Nigel

The code used is the database expmple in the 1.9.22 distribution.

The parameters used  in the startup screen are:

       TYPE:                 sqlite3      (this is not one of the option 
in the combo box .   
                                                             So select 
sqlite and add the 3)
       HOST:                 /data/sqlite3   (directory created before 
the first run)
       DATABASE        test
 
On the first run the create database option was on.
This created the database.
 
Then enter     " select * from  test "    into the  SQL request box  
and  run  the query.
 
If you get the correct result the first time close gambas2 and start 
again using the same parametors.

ALAN

Alan, Could you provide an example of your code. Many thanks Nigel

> > Message Received: Dec 19 2005, 01:42 PM
> > From: "Alan at ...1278..." 
> > To: gambas-user at lists.sourceforge.net
> > Cc: 
> > Subject: [Gambas-user] sqlite3 test database
> > 
> > Hi,
> > 
> > I have created a SQLite3 test database using the database example in the 
> > 1.9.22 distribution.
> > 
> > All 10000 entries in the test table seem to be present.
> > 
> > However if I load the database example into gambas3 and run the 
> > following SQL statement:
> > 
> > select * from test:
> > 
> > on the first run I only get one column in the result window which is 
> > the line number.
> > If I then run the query again all of the colunms are displayed.
> > 
> > Anyone know why this happens?
> > 
> > regards
> > 
> > Alan Bromley