10/6/2007 6:30:08 PM v1.3445 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' 0001:001F48A4 axView.txTree.RefreshValues line 3223 0001:0023EA4C axView.txTabsEx.DoOnClick line 9648 base: 00A61000 select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Card_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Orders where [ID]=3755 10/6/2007 6:30:06 PM v1.3445 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' 0001:001F48A4 axView.txTree.RefreshValues line 3223 0001:0022A6D8 axView.txView.DoOnEnter line 7570 base: 00A61000 select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Card_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Orders where [ID]=3755 10/6/2007 6:30:05 PM v1.3445 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' 0001:001F48A4 axView.txTree.RefreshValues line 3223 0001:0023EA4C axView.txTabsEx.DoOnClick line 9648 base: 00A61000 select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Card_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Orders where [ID]=3755 10/6/2007 5:58:19 PM v1.3445 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' 0001:001F48A4 axView.txTree.RefreshValues line 3223 0001:0021FF54 axView.txView.DoOnTimer line 6668 base: 00A61000 select [Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Card_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Orders where [ID]=3755 10/6/2007 5:21:35 PM v1.3445 - Incorrect syntax near 'GO' Continue or restart VDM - This error was queued for analysis, we apologize. -- WebSites,WebPages,Accounts,TaxProfiles,Contacts,Ledger,Catalog,Resources,Warehouses,Components,Re 0001:0021AFB8 axView.txView.RunSQL line 6167 0001:0018F4B0 axPopup.txPopup.DoOnClick line 1028 base: 00B51000 -- WebSites,WebPages,Accounts,TaxProfiles,Contacts,Ledger,Catalog,Resources,Warehouses,Components,Relationships,Numbers,Orders,OrderItems,Specs,Serials,Activities,Variations,Notes,DataLog,Notifications -- above line is read by VDM to know the VDM Tables order for Import and Exports for now ------------- -- Fixes -- ------------- -- if exists ( select * from sysobjects where [Name] = 'Notifications' AND [Type] = 'U' ) drop table Notifications -- if exists ( select * from sysobjects where [Name] = 'DataLog' AND [Type] = 'U' ) drop table DataLog -- if exists ( select * from sysobjects where [Name] = 'Notes' AND [Type] = 'U' ) drop table Notes -- if exists ( select * from sysobjects where [Name] = 'Variations' AND [Type] = 'U' ) drop table Variations -- if exists ( select * from sysobjects where [Name] = 'Activities' AND [Type] = 'U' ) drop table Activities -- if exists ( select * from sysobjects where [Name] = 'Serials' AND [Type] = 'U' ) drop table Serials -- if exists ( select * from sysobjects where [Name] = 'Specs' AND [Type] = 'U' ) drop table Specs -- if exists ( select * from sysobjects where [Name] = 'OrderItems' AND [Type] = 'U' ) drop table OrderItems -- if exists ( select * from sysobjects where [Name] = 'Orders' AND [Type] = 'U' ) drop table Orders -- if exists ( select * from sysobjects where [Name] = 'Numbers' AND [Type] = 'U' ) drop table Numbers -- if exists ( select * from sysobjects where [Name] = 'Relationships' AND [Type] = 'U' ) drop table Relationships -- if exists ( select * from sysobjects where [Name] = 'Components' AND [Type] = 'U' ) drop table Components -- if exists ( select * from sysobjects where [Name] = 'Warehouses' AND [Type] = 'U' ) drop table Warehouses -- if exists ( select * from sysobjects where [Name] = 'Resources' AND [Type] = 'U' ) drop table Resources -- if exists ( select * from sysobjects where [Name] = 'Catalog' AND [Type] = 'U' ) drop table [Catalog] -- if exists ( select * from sysobjects where [Name] = 'Ledger' AND [Type] = 'U' ) drop table Ledger -- if exists ( select * from sysobjects where [Name] = 'Contacts' AND [Type] = 'U' ) drop table Contacts -- if exists ( select * from sysobjects where [Name] = 'TaxProfiles' AND [Type] = 'U' ) drop table TaxProfiles -- if exists ( select * from sysobjects where [Name] = 'Accounts' AND [Type] = 'U' ) drop table Accounts -- if exists ( select * from sysobjects where [Name] = 'WebPages' AND [Type] =