[Gambas-user] Gambas DB basic update record example

[Iwan Prasetyo]

-----Original Message-----
From: gambas-user-admin at lists.sourceforge.net
[mailto:gambas-user-admin at lists.sourceforge.net] On Behalf Of Rizky Tahara
Shita
Sent: Thursday, September 30, 2004 09:38
To: gambas-user at lists.sourceforge.net
Subject: Re: [Gambas-user] Gambas DB basic update record example

Iwan Prasetyo wrote:
> Dear Gambas user...
> 
> I need a little help for database basic function on Gambas.
> I'm using PostgreSQL as the database.
> 
> Here's I attach my screen shots of what I did.
> 
> I connected to PostgreSQL, and made it...I can view (or navigating) 
> using MoveFirst, MoveLast, MoveNext, and MovePrevious. Also with MoveTo...
> 
> I can add a new record also with this code shown on GambasDB2.JPG.
> (is it correct way? Pls advise if I'm wrong..but it can be done with 
> that way).
> 
> My question is how to edit (or Update) an existed record?
> It seems I can't do that smoothly as in VB like this:
> (on active record just simply like)
> rData!name=XXX
> rData!Sex="Male"
> rData.Update
> 
> Or perhaps anyone here know how to find, addnew record and update and 
> also delete a record smoothly?
> 
> That's all...
> 
> Thanks in advance for your help.
> Regards,
>  
> Iwan Prasetyo
> ----------------------

hmm... why don't you upgrade your code to SQL statement..
it's more easy to do that than using rData.Update or something like that...

learn from my example (DataReportExample) then... you'll find more simple to
do that with SQL...


Thx Rizki...
I did update per one record not global...
Update case only for 1 record which is selected...
For general update, I'd rather to use update from SQL:)

Regards,
 
Iwan Prasetyo
----------------------