[Gambas-user] Enumerating values in sqllite3 database tables

[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 & "," & 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.