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 & ","
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
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
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
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 & "
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
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
'
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