Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread Fabien Bodard
2008/9/17 MaxVK <[EMAIL PROTECTED]>: > > > charlesg wrote: >> >> Hi, >> >> something like: >> '-- >> Private res As Result >> >> lstSupplier.Clear >> res = $hConn.Exec("select * from supp order by s_code") >> For Each res >>lstSupplier.Add(res!s_code & "," & res!s_name & ","

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
charlesg wrote: > > Hi, > > I don't know how 'standard' any sql gets:confused: > You can certainly use sql update and delete commands the same way. > > rgds > > :-D Yeah, thats pretty much what I meant. I don't know much SQL (yet), so I was only wondering if sqlite3 used the same commands o

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread charlesg
Hi, I don't know how 'standard' any sql gets:confused: You can certainly use sql update and delete commands the same way. rgds -- View this message in context: http://www.nabble.com/Enumerating-values-in-sqllite3-database-tables-tp19529262p19532988.html Sent from the gambas-user mailing list

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
Fabien Bodard-4 wrote: > > 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 crea

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
charlesg wrote: > > Hi, > > something like: > '-- > Private res As Result > > lstSupplier.Clear > res = $hConn.Exec("select * from supp order by s_code") > For Each res >lstSupplier.Add(res!s_code & "," & res!s_name & "," & res!s_closedate & > "," & res!s_dayscredit & "

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread Fabien Bodard
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

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread charlesg
Hi, something like: '-- Private res As Result lstSupplier.Clear res = $hConn.Exec("select * from supp order by s_code") For Each res lstSupplier.Add(res!s_code & "," & res!s_name & "," & res!s_closedate & "," & res!s_dayscredit & "," & res!s_datedue) Next '

[Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
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