2008/9/17 MaxVK <[EMAIL PROTECTED]>:
>
> 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
> --
dim hresult as result
hresult = db.find("Table1", "Field1")
For each hresult
ListBox.add(hResult!Field1)
next
Simply like that !!
regards,
Fabien Bodard
-------------------------------------------------------------------------
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
