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 & "," & 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user