After an upgrade to 3.70a and win 2003 server from 3.01b and win 2000 server respectively, the push into Navision that usually takes approx 5min now runs for ever and eventually crashes. Are there any changes required to the code below to eliminate this problem? Thanks for your assistance ########################################### !!CB!! 184 Menu Item: &Send Data to Finance System Resource Id: 9251 Keyboard Accelerator: (none) Status Text: Menu Settings Enabled when: NOT SalIsNull( dfAudId ) AND NOT cbSent AND SalSendMsg( hWndForm , PAM_GetScreenMode , 0 , 0 ) = MODE_View AND NOT cbPretend Checked when: Menu Actions ! Call SalWaitCursor( TRUE ) ! Connecting to Navision database … to send data to Monthly_Feed_From_ROB (AR 18-3-2002) ! If NOT LoginToNavision( ‘Navision’ , ghSqlNavi , ‘Navision Test’ ) Call SalMessageBox( ‘Unable to connect to Navision database’, ‘Error Connecting’,MB_Ok ) ! Query on the view v_Monthly_Feed_From_Rob to populate Navision table (AR 14-03-02) ! ! Added contract_no also as part Monthly Feed From ROB (AR 18-07-2002) Call SqlPrepareAndExecute(ghSql, ’ select Invoice_Id, Item, OEF, Address_Id, convert(varchar(25),Invoice_Date,103), PO_No, Contract_No, Item_Type, Cost_Centre, Expense_Head, Quantity, Item_Charge, Total_Charge, Vat_rate, Name, Description, convert(varchar(25),From_Date,103), convert(varchar(25),To_Date,103), Processed, Customer_Agreement_Id, Vat_Code, Audit_Id, Real_Expense_Head From v_Monthly_Feed_From_Rob into :Invoice_id, :Item, :OEF, :Address_id, :Invoice_date, :PO_no, :Contract_No, :Item_type, :Cost_centre, :Exp_head, :Qty, :Item_charge, :Total_charge, :Vat_rate, :Name, :Desc, :From_date, :To_date, :Processed, :Cust_ag_id, :Vat_code, :Audit_id, :Real_Exp_head’) ! ! Added contract_no also as part Monthly Feed From ROB (AR 18-07-2002) While SqlFetchNext(ghSql,nFetchErr) Set sSql = ‘insert into Monthly_Feed_From_ROB (Invoice_Id, Item, OEF, Address_Id, Invoice_Date, PO_No, Contract_No, Item_Type, Cost_Centre, Expense_Head, Quantity, Item_Charge, Total_Charge, Vat_Rate, Name, Description, From_Date, To_Date, Processed, Customer_Agreement_Id, Vat_Code, Audit_Id, Real_Expense_Head) values ( :Invoice_id, :Item, :OEF, :Address_id, :Invoice_date, :PO_no, :Contract_No, :Item_type, :Cost_centre, :Exp_head, :Qty, :Item_charge, :Total_charge, :Vat_rate, :Name, :Desc, :From_date, :To_date, :Processed, :Cust_ag_id, :Vat_code, :Audit_id, :Real_Exp_head)’ Call SqlPrepareAndExecute( ghSqlNav, sSql ) Call SqlPrepareAndExecute( ghSql , ‘update audit_log set sent_to_ss = “Y” where audit_id = :dfAudId’ ) Set cbSent = TRUE Call SalWaitCursor( FALSE ) ! Menu Item Name: