[Gambas-user] Insert into multiple database columns from numerous textboxes

[john hedge]

Thanks Charlie,
I thought it would be something like that.
If I might stretch a friendship a little further; is there a 'howto' on the
Gambas DB Functions that a programmer newbie like me can follow? I've
Googled and looked on the Gambas site but I couldn't find anything.

Thanks again.

John

On Thu, 8 Dec 2005 11:07:32 00100, Charlie Reinl <na2492 at ...9...> wrote:
>
> >Hi,
> >
> >DIM res AS Result
> >DIM sql AS String
> >
> >IF textbox1.Text <> "" THEN
> >sql = "insert into table (column1) values ('" & textbox1.Text & "')"
> >res = conn.Exec(sql)
> >END IF
> >
> >will move the data from one textbox into one column.
> >
> >How do you move data from a number of textboxes (all named tbXxxxx) into
> >adjacent columns of the same table, please?
> >
> >TIA
> >
> >John
> >
> Salut,
>
> "insert into table (column1,column2,..) values ('" & textbox1.Text & "','"
> & textbox1.Text & "','" &..& "')"
>
> But you can use also the Gambas DB Functions, which are provided for that.
>
> Amicalment
> Charlie
> * Gesendet mit / Sent by: FEN-Webmail * http://www.fen-net.de *
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051209/9198eede/attachment.html>