[Gambas-user] SQLite test database

[Alan Bromley]

NIGEL, I have now tried to reproduce the fault on another computer with 
different results: 1: The problem seems not to be quite as i first 
describe. Infact the "missing" columns are there but the column width 
has increased to the point where it is very difficult to find the data. 
2; On the first computer the fault appeared only one first attempt to 
display the table. On the second one the first display was correct 
second and subsequent displays where of the wide column type 3: I have 
now tried loading SQlite3.2.8 with the same result 4; Sqlite as apposed 
sqlite3 diplays the table correctly at all times on both computers. Thak 
for your help Alan 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
> > 
> > 
> > 
> > -------------------------------------------------------