Insert SQL Statement in VB 2

[FJAY]

strSQLUpdate = "INSERT INTO DEMAND_SUPPLY_LINK " _
"(ID, DEMAND_TYPE, DEMAND_BASE_ID, DEMAND_SEQ_NO, _
SUPPLY_TYPE, SUPPLY_BASE_ID, SUPPLY_SUB_ID, _
DEMAND_PART_ID, SUPPLY_PART_ID, ALLOCATED_QTY, _
RECEIVED_QTY, ISSUED_QTY, SUPPLY_MODE, _
CREATE_DATE, USER_ID)"

Values('','')

My problem is that I have numerous columns (32) and I will like it to continue on the next line. This applies also to the Values. I'm having some problems with the insert statement. thanks.

 

[zarkon4]

try this
strSQLUpdate="INSERT INTO DEMAND_SUPPLY_LINK " & _
"(ID, DEMAND_TYPE,DEMAND_BASE_ID,DEMAND_SEQ_NO, " & _
"SUPPLY.......get the idea"

you cannot just put a _ to continue a line (at least not in this case)

YOUR CODE---

strSQLUpdate = "INSERT INTO DEMAND_SUPPLY_LINK " _
"(ID, DEMAND_TYPE, DEMAND_BASE_ID, DEMAND_SEQ_NO, _
SUPPLY_TYPE, SUPPLY_BASE_ID, SUPPLY_SUB_ID, _
DEMAND_PART_ID, SUPPLY_PART_ID, ALLOCATED_QTY, _
RECEIVED_QTY, ISSUED_QTY, SUPPLY_MODE, _
CREATE_DATE, USER_ID)"

 

[FJAY]

I did exactly that but am having some problems with value part of the statement. Look below:

strSQLInsert = "INSERT INTO DEMAND_SUPPLY_LINK " & _
"(ID, DEMAND_TYPE, DEMAND_BASE_ID, DEMAND_SEQ_NO, SUPPLY_TYPE, SUPPLY_BASE_ID," & _
"SUPPLY_SUB_ID, DEMAND_PART_ID, SUPPLY_PART_ID, ALLOCATED_QTY, RECEIVED_QTY," & _
"ISSUED_QTY, SUPPLY_MODE, CREATE_DATE, USER_ID)" & _
"Values('" & frmCust.txtDemand(0).Text & "', 'CO' " & _
" '" & frmCust.txtDemand(1).Text & "', " & _
" '" & frmCust.txtDemand(2).Text & "', 'I' " & _
" '" & frmCust.txtDemand(3).Text & "', '0' " & _
" '" & frmCust.txtDemand(4).Text & "', " & _
" '" & frmCust.txtDemand(5).Text & "', " & _
" '" & frmCust.txtDemand(6).Text & "', " & _
" '" & frmCust.txtDemand(7).Text & "', '0', 'A', " & _
" '" & strDate & "', 'ALLOC')"

incorrect syntax near frmcust.txtdemand(1).text

 

[BrianLW]

"Values('" & frmCust.txtDemand(0).Text & "', 'CO', " & _

 

[zarkon4]

your forgetting a comma and a space

strSQLInsert = "INSERT INTO DEMAND_SUPPLY_LINK " & _
"(ID, DEMAND_TYPE, DEMAND_BASE_ID, DEMAND_SEQ_NO, SUPPLY_TYPE, SUPPLY_BASE_ID," & _
"SUPPLY_SUB_ID, DEMAND_PART_ID, SUPPLY_PART_ID, ALLOCATED_QTY, RECEIVED_QTY," & _
"ISSUED_QTY, SUPPLY_MODE, CREATE_DATE, USER_ID) " & _
"Values('" & frmCust.txtDemand(0).Text & "', 'CO', " & _
" '" & frmCust.txtDemand(1).Text & "', " & _
" '" & frmCust.txtDemand(2).Text & "', 'I' " & _
" '" & frmCust.txtDemand(3).Text & "', '0' " & _
" '" & frmCust.txtDemand(4).Text & "', " & _
" '" & frmCust.txtDemand(5).Text & "', " & _
" '" & frmCust.txtDemand(6).Text & "', " & _
" '" & frmCust.txtDemand(7).Text & "', '0', 'A', " & _
" '" & strDate & "', 'ALLOC')"

 

[FJAY]

Thank you very much...............)