Dear all, I hit an error OVERFLOW but when I insert the sql statement below manually in the SQLEditor, it goes well, no errors at all.
My coding:
SQLInsertTempMf = "INSERT INTO tempmf " & _
"(scn, bl_num,master_ind,cin_num,master_bl,container_no, consignee_code, consignee_name,consignee_addr1, " & _
"consignee_addr2,consignee_addr3,consignee_addr4,s hipper_code,shipper_name, shipper_addr1, shipper_addr2,shipper_addr3, " & _
"shipper_addr4,nparty_code,nparty_name,nparty_addr 1,nparty_addr2, nparty_addr3, nparty_addr4,mark1, " & _
"mark2,mark3,mark4,tot_mf_qty,tot_mf_vol, tot_mf_wgt, tot_cg_val,tot_mf_item, week_ind, " & _
"tranship_ind,transfer_ind,transfer_date,transfer_ scn,transfer_so_num, remeasure_req, remeasure_ind,remeasure_date, overland_ind, " & _
"port_load,port_orig,custom_form,overland_bl,inv_i nd,inv_date,inv_num,first_inv_date, inv_ton, " & _
"wharfage_ton,gp_ind,gp_date,first_gp_num,last_gp_ num, photo_path,bulk_ind,disc_date, new_mark1, " & _
"new_mark2,new_mark3,new_mark4,mf_close,gd_stk_cnt _ind, upd_gd_stk_user_id,upd_gd_stk_date, upd_gd_stk_time, " & _
"delv_date,add_user,add_date,add_time,upd_user , upd_date,upd_time, document_id, bl_flag, print_ind, final_destination) " & _
"VALUES('" & strScn2 & "', '" & strBlNumber & "', '" & strBlType & "', '', " & _
"'" & strMasterBlNumber & "', '" & strMasterContainerNumber & "', '', " & _
"'" & Apostrophe(CStr(strConsigneeName)) & "', '" & Apostrophe(CStr(strConsigneeAddressLine1)) & "', '" & Apostrophe(CStr(strConsigneeAddressLine2)) & "', " & _
"'" & Apostrophe(CStr(strConsigneeAddressLine3)) & "', '" & Apostrophe(CStr(strConsigneeAddressLine4)) & "', '', " & _
"'" & Apostrophe(CStr(strShipperName)) & "', '" & Apostrophe(CStr(strShipperAddressLine1)) & "', '" & Apostrophe(CStr(strShipperAddressLine2)) & "', " & _
"'" & Apostrophe(CStr(strShipperAddressLine3)) & "', '" & Apostrophe(CStr(strShipperAddressLine4)) & "', '', '" & Apostrophe(CStr(strNotifyPartyName)) & "', " & _
"'" & Apostrophe(CStr(strNotifyPartyAddressLine1)) & "', '" & Apostrophe(CStr(strNotifyPartyAddressLine2)) & "', '" & Apostrophe(CStr(strNotifyPartyAddressLine3)) & "', " & _
"'" & Apostrophe(CStr(strNotifyPartyAddressLine4)) & "', '" & Apostrophe(CStr(strCargoMarking1)) & "', '" & Apostrophe(CStr(strCargoMarking2)) & "', '" & Apostrophe(CStr(strCargoMarking3)) & "', '" & Apostrophe(CStr(strCargoMarking4)) & "', 0, 0.00,0.00,0.00, 0, 'N', " & _
"'" & strTranshipmentFlag & "', 'N', Null, '', '', '', 'N', Null, 'N', '" & strPortOfLoading & "', '" & strPortOfOrigin & "', " & _
"'', '', 'N', Null, '', Null, 0.00, 0.00, 'N', Null, '', '', '', '" & strBulkFlag & "', Null, '', '', '', '', 'N', 'N', 'N', Null, '', Null, 'wsw', Null, '', '', Null, '', '" & DocId & "', 'N', 0, '" & Apostrophe(CStr(strFinalDestination)) & "') "
Call LogIt(LOGDEBUG, "after SQLInsertTempMf" & SQLInsertTempMf)
queryInsertTempMf.SQL = SQLInsertTempMf
queryInsertTempMf.Prepared = True
Set queryInsertTempMf.ActiveConnection = conRDO
queryInsertTempMf.Execute
If (queryInsertTempMf.RowsAffected <= 0) Then
conRDO.RollbackTrans
End If
================================================== =======
Error in my logs file:
2007-09-19 11:41:14:DEBUG: after SQLInsertTempMfINSERT INTO tempmf (scn, bl_num,master_ind,cin_num,master_bl,container_no, consignee_code, consignee_name,consignee_addr1, consignee_addr2,consignee_addr3,consignee_addr4,sh ipper_code,shipper_name, shipper_addr1, shipper_addr2,shipper_addr3, shipper_addr4,nparty_code,nparty_name,nparty_addr1 ,nparty_addr2, nparty_addr3, nparty_addr4,mark1, mark2,mark3,mark4,tot_mf_qty,tot_mf_vol, tot_mf_wgt, tot_cg_val,tot_mf_item, week_ind, tranship_ind,transfer_ind,transfer_date,transfer_s cn,transfer_so_num, remeasure_req, remeasure_ind,remeasure_date, overland_ind, port_load,port_orig,custom_form,overland_bl,inv_in d,inv_date,inv_num,first_inv_date, inv_ton, wharfage_ton,gp_ind,gp_date,first_gp_num,last_gp_n um, photo_path,bulk_ind,disc_date, new_mark1, new_mark2,new_mark3,new_mark4,mf_close,gd_stk_cnt_ ind, upd_gd_stk_user_id,upd_gd_stk_date, upd_gd_stk_time, delv_date,add_user,add_date,add_time,upd_user, upd_date,upd_time, document_id, bl_flag, print_ind, final_destination) VALUES('07092012', 'PGK302', 'N', '', '', '', '', 'CONTINENTAL ACTION SDN BHD', '248,LRG 3,JLN SIOL KANDIS,KP.SIOL', 'KANDIS,', '', '', '', 'PSJ LOGISTICS SDN BHD', 'PENANG', '', '', '', '', 'CONTINENTAL ACTION SDN BHD', '248,LRG 3,JLN SIOL KANDIS,', 'KG.SIOL KANDIS', '', '', '- ', '', '', '', 0, 0.00,0.00,0.00, 0, 'N', 'N', 'N', Null, '', '', '', 'N', Null, 'N', 'MYPEN', 'MYPEN', '', '', 'N', Null, '', Null, 0.00, 0.00, 'N', Null, '', '', '', 'N', Null, '', '', '', '', 'N', 'N', 'N', Null, '', Null, 'wsw', Null, '', '', Null, '', 'MF20070919-0001', 'N', 0, '')
2007-09-19 11:41:15:ERROR: insertTempTableError:6:Overflow