[Gambas-user] Gambas DB basic update record example

[Iwan Prasetyo]

Do you mean this:

rData=hConn.Edit ("dataku","where id=" & textbox1.text)

Where dataku is the name of the table and id is the primary key (integer)
and the textbox1.text is the value of the primary key...


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

-----Original Message-----
From: gambas-user-admin at lists.sourceforge.net
[mailto:gambas-user-admin at lists.sourceforge.net] On Behalf Of Benoit
Minisini
Sent: Tuesday, September 28, 2004 16:19
To: gambas-user at lists.sourceforge.net
Subject: Re: [Gambas-user] Gambas DB basic update record example

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...


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user