help VB and SQL

help VB and SQL

Post by Giusepp » Sat, 17 Nov 2001 01:16:15



Hello,

I have a little problem with VB and sql.

I must register into a table data from  a form that contains text box, using
a string SQL.

I do it with a string that I write,
         (es. insert into table (field) values ("ciao")
but with a variable??

thanks

 
 
 

help VB and SQL

Post by David Wimbu » Sat, 17 Nov 2001 20:41:33


Dim strSQL As String

strSQL = "insert into table (field) values ('" & Text1.Text & "')"