H-SC
asked on
Insert Statement
I have the following insert statement that will not seem to work. It worked fine until I added the "type" and the area of "this is a test".
How can I add text into a table field along with other values in a select?
Dim command7222 As New SqlClient.SqlCommand("INSE RT INTO my_table(type, id5, change_id,send_date) values('" & "this is a test" & "','" & ("select ctl_num, id5_t, getdate() from my_table where ctl_num = '" & textbox1.Text & "')", myconn7222)
How can I add text into a table field along with other values in a select?
Dim command7222 As New SqlClient.SqlCommand("INSE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect!
many thanks for the quick reply