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

[john hedge]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051208/319277df/attachment.html>