[Gambas-user] Database! More Questions!

[Hamilton Geminiano Andrioli Junior]

Steven Lobbezoo escreveu:
> Hi,
>
> Use db.Begin for start transaction 
> and db.Commit to end it.
>
> I personally do allmost everything with db.exec, so I can use ALL features of 
> MySQL
>
> Steven
>
>
> Le jeudi 19 avril 2007 19:33, Hamilton Geminiano Andrioli Junior a écrit :
>   
>> Hi there again!
>>
>> I need help (again!!!) So, when i was working with VB6, i used a Oracle
>> Transational Server, then, when i nedded to make a lot of SQL
>> requirement, i started a function:
>>
>> DataOracle.BeginTrans
>>
>> xxxx
>> xxxx
>> xxxx
>> xxx
>>
>> DataOracle.CommitTrans
>>
>> Is There a Generic BeginTrans and CommitTrans in gambas?
>> How to use then?
>>
>> I have to execute 3 SQL, inserting and updating data at same time, but
>> if there was a error, ir have to procced a Rollback automaticaly.
>>
>> Anyone may help me?
>>
>> Regards
>> Hamilton From Brazil!
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>     
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>   
Steven,

please, I really don't know how to use the db function.
What i do is write a SQL like "Update xxx". then call the db.exec(sQL)
and its done.

Can you send me an example of how to update, insert, delete, and select 
with db. function?

Please.
Regards
Hamilton From Brazil