By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

HELP ME ~~ I found error "6:Overflow" in my logs file :(

P: 1
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
Sep 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.