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

[Charlie Reinl]

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