If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blank value in a field BOMBS my INSERT INTO statement
I've noticed when I double click a line in my listbox, that if one of the
fields has a blank value, my INSERT INTO statement bombs out when I double-click that line. Why is that??? What do I do so that my INSERT INTO works when one field on the line is blank/empty? Here is my code the INSERT INTO that takes 12 fields from the list box and puts them in a tbl db.Execute "INSERT INTO [tblMissingChargesinCP] " & "([OrderTextFileUniqueID],[Oracle#],[DOS],[KCIItem#],[ExpandedQty],[OrderType],[OracleID],[PatientFirstName],[PatientLastName],[ROE],[Account#],[ShippedQty])" & "VALUES(" & ctl.ItemData(varItem) & ",'" & ctl.Column(1, varItem) & "','" & ctl.Column(2, varItem) & "','" & ctl.Column(3, varItem) & "'," & ctl.Column(4, varItem) & ",'" & ctl.Column(5, varItem) & "'," & ctl.Column(6, varItem) & ",'" & ctl.Column(7, varItem) & "','" & ctl.Column(8, varItem) & "'," & ctl.Column(9, varItem) & "," & ctl.Column(10, varItem) & "," & ctl.Column(11, varItem) & ")" |
#2
|
|||
|
|||
Blank value in a field BOMBS my INSERT INTO statement
I figured it out. I put a IIF(....="","Null",...)
"worksfire1" wrote: I've noticed when I double click a line in my listbox, that if one of the fields has a blank value, my INSERT INTO statement bombs out when I double-click that line. Why is that??? What do I do so that my INSERT INTO works when one field on the line is blank/empty? Here is my code the INSERT INTO that takes 12 fields from the list box and puts them in a tbl db.Execute "INSERT INTO [tblMissingChargesinCP] " & "([OrderTextFileUniqueID],[Oracle#],[DOS],[KCIItem#],[ExpandedQty],[OrderType],[OracleID],[PatientFirstName],[PatientLastName],[ROE],[Account#],[ShippedQty])" & "VALUES(" & ctl.ItemData(varItem) & ",'" & ctl.Column(1, varItem) & "','" & ctl.Column(2, varItem) & "','" & ctl.Column(3, varItem) & "'," & ctl.Column(4, varItem) & ",'" & ctl.Column(5, varItem) & "'," & ctl.Column(6, varItem) & ",'" & ctl.Column(7, varItem) & "','" & ctl.Column(8, varItem) & "'," & ctl.Column(9, varItem) & "," & ctl.Column(10, varItem) & "," & ctl.Column(11, varItem) & ")" |
Thread Tools | |
Display Modes | |
|
|