11/26/2007 4:43:58 PM v1.3554 - Access violation at address 00AEE429 in module 'axVDM4.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. 0001:001ECD68 axView.txTree.WhereClause line 2957 0001:001E68D8 axView.txTree.DoOnExpanding line 2329 base: 00901000 11/26/2007 4:43:49 PM v1.3554 - Access violation at address 00AEE429 in module 'axVDM4.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. 0001:001ECD68 axView.txTree.WhereClause line 2957 0001:001E68D8 axView.txTree.DoOnExpanding line 2329 base: 00901000 11/26/2007 4:37:41 PM v1.3554 - The specified procedure could not be found, ClassID: {00000514-0000-0010-8000-00AA006D2EA4} Continue or restart VDM - This error was queued for analysis, we apologize. 0001:0001D9A0 ComObj.CreateComObject line 1369 0001:001E68D8 axView.txTree.DoOnExpanding line 2328 base: 00901000 11/26/2007 4:37:35 PM v1.3554 - Access violation at address 00AEE429 in module 'axVDM4.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. 0001:001ECD68 axView.txTree.WhereClause line 2957 0001:001E68D8 axView.txTree.DoOnExpanding line 2329 base: 00901000 11/26/2007 4:37:26 PM v1.3554 - The specified procedure could not be found, ClassID: {00000514-0000-0010-8000-00AA006D2EA4} Continue or restart VDM - This error was queued for analysis, we apologize. 0001:0001D9A0 ComObj.CreateComObject line 1369 0001:001E68D8 axView.txTree.DoOnExpanding line 2328 base: 00901000 11/23/2007 6:18:55 PM v1.3548 - Access violation at address 00D3CA21 in module 'axVDM.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. 0001:001EB360 axView.txTree.WhereClause line 2957 0001:001E4ED0 axView.txTree.DoOnExpanding line 2329 base: 00B51000 11/23/2007 6:18:19 PM v1.3548 - Access violation at address 00D3CA21 in module 'axVDM.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. 0001:001EB360 axView.txTree.WhereClause line 2957 0001:001E4ED0 axView.txTree.DoOnExpanding line 2329 base: 00B51000 11/23/2007 7:16:57 AM v1.3548 - Invalid column name 'Resource_Name' Continue or restart VDM - This error was queued for analysis, we apologize. update Orders set [Resource_Name]='Fine Portrait Prints' where [ID]=3767 0001:0001E74C ComObj.DispCallError line 1795 0001:00243368 axVDM.Finalization line 54 base: 00B51000 update Orders set [Resource_Name]='Fine Portrait Prints' where [ID]=3767 11/23/2007 7:15:52 AM v1.3548 - Invalid column name 'Resource_Name' Continue or restart VDM - This error was queued for analysis, we apologize. update Orders set [Resource_Name]='Fine Portrait Prints' where [ID]=3767 0001:0001E74C ComObj.DispCallError line 1795 0001:00243368 axVDM.Finalization line 54 base: 00B51000 update Orders set [Resource_Name]='Fine Portrait Prints' where [ID]=3767 11/23/2007 5:43:05 AM v1.3548 - String or binary data would be truncated Continue or restart VDM - This error was queued for analysis, we apologize. update Components set [Resource_Name]='Basic File Retouching, Test print, Colour Balance & Level' wh 0001:0001E74C ComObj.DispCallError line 1795 0001:00243368 axVDM.Finalization line 54 base: 00B51000 update Components set [Resource_Name]='Basic File Retouching, Test print, Colour Balance & Level' where [ID]=39 11/21/2007 4:00:50 PM v1.3548 - Access violation at address 00D1028E in module 'axVDM3.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. select [Name], Code, UPC, Price, Avg_Cost, Units_on_Hand, Units_Ordered, Units_Required, Avg_Usage 0001:001BF204 axPopup.txPopup.PrintForm line 4617 0001:0019018C axPopup.txPopup.DoOnClick line 1110 base: 00B51000 select [Name], Code, UPC, Price, Avg_Cost, Units_on_Hand, Units_Ordered, Units_Required, Avg_Usage_per_Month from Resources where Active = 1 AND [Type] = 'Product' order by 1 compute Count( [Name] ) 11/21/2007 4:00:35 PM v1.3548 - Access violation at address 00D1028E in module 'axVDM3.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. select Code, [Name], UPC, Price, Avg_Cost, Std_Cost, Units_on_Hand, Units_Ordered, Units_Required, 0001:001BF204 axPopup.txPopup.PrintForm line 4617 0001:0019018C axPopup.txPopup.DoOnClick line 1110 base: 00B51000 select Code, [Name], UPC, Price, Avg_Cost, Std_Cost, Units_on_Hand, Units_Ordered, Units_Required, Avg_Usage_per_Month,Units_on_Hand*isNull(NullIf(Avg_Cost,0),Std_Cost) as Value from Resources where Active = 1 AND [Type] = 'Product' order by 1 compute Count( [Name] ), Sum( Units_on_Hand ), Sum( Units_on_Hand*isNull(NullIf(Avg_Cost,0),Std_Cost) ) 11/21/2007 2:26:30 PM v1.3546 - Incorrect syntax near ')' Continue or restart VDM - This error was queued for analysis, we apologize. insert into Contacts ([Group],[Name],Phone,Address,City,State_or_Province,Postal_Code,Country,Price_ 0001:0001E6E8 ComObj.DispCallError line 1795 0001:00242D2C axVDM.Finalization line 54 base: 00B51000 insert into Contacts ([Group],[Name],Phone,Address,City,State_or_Province,Postal_Code,Country,Price_Level) values('Sales','','','','','','','',) 11/21/2007 9:08:34 AM v1.3546 - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OrderItems_Resources". The conflict occurred in database "VDM_Cashin", table "dbo.Resources", column 'ID' Continue or restart VDM - This error was queued for analysis, we apologize. insert into OrderItems ([Order_ID], [Resource_Name]) values (3761, 'Canvas FP') 0001:0001E6E8 ComObj.DispCallError line 1795 0001:00242D2C axVDM.Finalization line 54 base: 00B51000 insert into OrderItems ([Order_ID], [Resource_Name]) values (3761, 'Canvas FP') 11/21/2007 9:06:19 AM v1.3525 - The object 'IX_Numbers_Type' is dependent on column 'Type' Continue or restart VDM - This error was queued for analysis, we apologize. ------------- -- Numbers -- ------------- if exists ( select * from INFORMATION_SCHEMA.COL 0001:002308FC axView.txView.ExecuteSql line 8241 0001:001E5F8C axView.txTree.DoOnExpanding line 2353 base: 00B51000 ------------- -- Numbers -- ------------- if exists ( select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'Numbers' AND Column_Name = 'Last_Number' ) begin alter table Numbers alter column Last_Number varchar( 20 ) NULL execute dbo.DropDefault 'Numbers', 'Type' execute dbo.DropConstraint 'Numbers', 'Type' alter table Numbers alter column [Type] varchar( 20 ) Null alter table Numbers add default 'Sale' for [Type] alter table Numbers add constraint CK_Numbers_Type check ( [Type] IN ( 'Sale', 'Purchase', 'Adjustment', 'Production', 'Estimate', 'Service' ) ) end 11/21/2007 9:05:26 AM v1.3525 - Invalid column name 'Never_Use_Last_Price' Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTri 0001:0022FC88 axView.txView.ExecuteRS line 8176 0001:0021FE38 axView.txView.DoOnTimer line 6796 base: 00B51000 select [ID],[GUID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Type],[Code],[Name],[Template_Name],[UPC],[Price],[Taxable],[Group],[Department],[Division],[Date_Start],[Date_Stop],[Variations_List],[Sub-Variations_List],Cast( Note as VarChar( 1000 ) ) as [Note],[Price1],[Price2],[Price3],[Price4],[Price5],[Price6],[Price7],[Price8],[Price9],[Unit],[Units_on_Hand],[Units_Required],(Units_on_Hand-Units_Required) as Units_Available,[Units_Ordered],(Units_on_Hand-Units_Required+Units_Ordered) as Units_to_be_Available,[Std_Cost],[Mfg_Cost],[Avg_Cost],[Avg_Usage_per_Month],[Avg_Days_to_Replenish],[Order_Point],[Order_Quantity],[Manual_Order_Point],[Last_Supplier],[Date_Locked_for_Count],[Snapshot_Quantity],[Date_Released_from_Count],[Quantity_Counted],[Date_Quantity_Adjusted],[Storage_Areas_List],[Active],[Hold_All_Activity],[Publish_this_Resource],[Update_eCommerce],[Track_Qty_on_Hand],[Never_Use_Last_Price],[Can_be_Sold],[Can_be_Purchased],[Can_be_Manufactured],[Can_be_a_Component],[Asset_Account],[COGS_Account],[Sales_Account],[Expense_Account],[Regular_Days_List],[Regular_Day_Hours_List],[Sunday_Hours_List],[Monday_Hours_List],[Tuesday_Hours_List],[Wednesday_Hours_List],[Thursday_Hours_List],[Friday_Hours_List],[Saturday_Hours_List],[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 Resources where [ID]=9 11/21/2007 9:05:17 AM v1.3525 - Invalid column name 'Never_Use_Last_Price' Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTri 0001:0022FC88 axView.txView.ExecuteRS line 8176 0001:0021FE38 axView.txView.DoOnTimer line 6796 base: 00B51000 select [ID],[GUID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Type],[Code],[Name],[Template_Name],[UPC],[Price],[Taxable],[Group],[Department],[Division],[Date_Start],[Date_Stop],[Variations_List],[Sub-Variations_List],Cast( Note as VarChar( 1000 ) ) as [Note],[Price1],[Price2],[Price3],[Price4],[Price5],[Price6],[Price7],[Price8],[Price9],[Unit],[Units_on_Hand],[Units_Required],(Units_on_Hand-Units_Required) as Units_Available,[Units_Ordered],(Units_on_Hand-Units_Required+Units_Ordered) as Units_to_be_Available,[Std_Cost],[Mfg_Cost],[Avg_Cost],