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 & "," & res!s_datedue)
> Next
> '----------------------
>
> rgds
>
ah! Very many thanks charlesg - That sorted it out.
Am I correct in thinking that "select * from supp order by s_code" is
standard SQL? If so would it be appropriate to use other SQL statements to
return information in the same way, or is sqlite3 limited to specific SQL
commands?
All the best
Max
--
View this message in context:
http://www.nabble.com/Enumerating-values-in-sqllite3-database-tables-tp19529262p19529663.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
