[Gambas-user] Gambas DB basic update record example

[Benoit Minisini]

On Tuesday 28 September 2004 07:25, 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
> ----------------------

Use the Edit() method to open a Result object for updating records. The only 
constraint is that you need a primary key on the table.

Regards,

-- 
Benoit Minisini
mailto:gambas at ...1...