[Gambas-user] Enumerating values in sqllite3 database tables

[Fabien Bodard]

2008/9/17 MaxVK <maximvonk at ...626...>:
>
>
> 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?

no all supported sql by sqlite... it's dependent to sqlite... same
thing for specific sql of mysql or else


> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>