[Gambas-user] sqlite3 test database

[nigel at ...38...]

I have tried with sqlite 3.2.7 and still cannot reproduce the behaviour you are experiencing.

Without being able to, I will not be able to fix.
Can other users test and feedback the rests?
Many thanks
Nigel
> Message Received: Dec 21 2005, 11:38 AM
> From: "Alan Bromley" 
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: [Gambas-user] sqlite3 test database
> 
> 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" 
> > > 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
> >>> 
> > The vesion of sqlite3 that I am using is 3.2.2
> ALAN
> 
> 
> 
> -------------------------------------------------------
> 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
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051221/11d07f7b/attachment.html>