[Gambas-user] sqlite3 test database

[nigel at ...38...]

Alan,

I cannot reproduce the problem that you have identified. I am using 1.9.22 with sqlite3 (3.1.2 ... I know the current is
3.2.7). I will try with a later version.

My sequence: enter location with host, database test, username. With option to create database clicked. ---> Connect

-->Create table
--> Fill table

Enter select * from test  --> Run

regards

Nigel

> Message Received: Dec 20 2005, 10:45 AM
> From: "Alan Bromley" <alan at ...1281...>
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: [Gambas-user] sqlite3 test database
> 
> 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
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
>