Hi there. I am making a personal program to catalog a large collection of
photographs and rather than install MySQL just for this purpose I would like
to use sqlite3.
Using the example program I am able to create the database and the tables
within it, and I am (apparently) able to add data to the tables. However I
have been unable to work out how to list the items that have been added to
the tables.
For example I have created Table1 with a field called Field1. I have then
added several items of data (The path and file names of images) to Field1
using code from the example:
$hConn.Begin
rTest = $hConn.Create("Table1")
rTest!Field1 = tFilename
rTest.Update
So far, so good, but how can I get a list of the items in Field1 so that
they can be displayed in a listbox?
Any pointers would be much appreciated.
regards
Max
--
View this message in context:
http://www.nabble.com/Enumerating-values-in-sqllite3-database-tables-tp19529262p19529262.html
Sent from the gambas-user mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
