Needing to reference a string into insert statement
I havent programmed with vb.net for quite some time and needing some assitance probably easy just cant figure it out
cmd.CommandText = sqlqry2
Dim dr2 As OracleDataReader = cmd.ExecuteReader()
dr2.Read()
Dim parent As String = (dr2.Item("parent_user_id"))
MsgBox(parent)
Dim sqlinsert As String = "INSERT INTO user_tracker (sequence_id,transaction_id,backend_id,user_id,customer_id,domain_name,service_id,action,backend_status,sales_channel,status_time,PASSWORD) VALUES (user_tracker_seq.NEXTVAL,'PRVMNT','PSI'," + "'" + TextBox13.Text + "'," + " &parent&)
i need to reference the parent string value into my insert should be easily done.