1/19/2007 4:15:15 PM v1.3285 - 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:0001E658 ComObj.DispCallError line 1795 0001:00236E14 axVDM.Finalization line 54 base: 00B51000 insert into Contacts ([Group],[Name],Phone,Address,City,State_or_Province,Postal_Code,Country,Price_Level) values('Sales','','','','','','','',) 1/18/2007 3:58:34 PM v1.3285 - Access violation at address 00CD3C98 in module 'axVDM.ocx'. Read of address 00000000 Continue or restart VDM - This error was queued for analysis, we apologize. select top 501 [ID],[Phone],[Name], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Orders w 0001:00182978 axPopup.txPopup.MenuSort line 753 0001:00183F94 axPopup.txPopup.DoOnClick line 1004 base: 00B51000 select top 501 [ID],[Phone],[Name], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Orders where [Type]='Sale' AND Date_Locked is Null AND Deposit_ID is Null order by [Phone], [ID] 1/16/2007 2:24:53 PM v1.3285 - Conversion failed when converting from a character string to uniqueidentifier Continue or restart VDM - This error was queued for analysis, we apologize. insert into DataLog (Table_Name,Form_Name,CmdText,SQL_Command,Identity_Key,Unique_Key,Unique_Column, 0001:0001E658 ComObj.DispCallError line 1795 0001:00236E14 axVDM.Finalization line 54 base: 00B51000 insert into DataLog (Table_Name,Form_Name,CmdText,SQL_Command,Identity_Key,Unique_Key,Unique_Column,Table_Column,Old_Value,New_Value,Parent_Table,GUID_Key,Mirrored_Servers_List) values ('Resources','VDM_Resources','insert into Resources ([Name]) values (''Additional set of PP'')','insert','','','[Name]','Name','','Additional set of PP','','','STORE,') 7/13/2007 6:45:21 PM v1.3270 - No VDM Tables found in SQL\VDM_Files...sql Continue or restart VDM - This error was queued for analysis, we apologize. select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou 0001:0018C334 axPopup.txPopup.MenuExport line 1590 0001:001847D8 axPopup.txPopup.DoOnClick line 1009 base: 00B51000 select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Quantity],[Hours],[Price],[Unit],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from OrderItems where (([Order_ID]=2164)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID] 7/13/2007 6:45:01 PM v1.3270 - No VDM Tables found in SQL\VDM_Files...sql Continue or restart VDM - This error was queued for analysis, we apologize. 0001:0018C334 axPopup.txPopup.MenuExport line 1590 0001:001847D8 axPopup.txPopup.DoOnClick line 1009 base: 00B51000 6/18/2007 10:35:48 AM v1.3184 - No VDM Tables found in SQL\VDM_Files...sql Continue or restart VDM - This error was queued for analysis, we apologize. if NOT exists ( select * from sysobjects where [Name] = 'Variations' AND [Type] = 'U' ) CREATE 0001:0018C0B0 axPopup.txPopup.MenuExport line 1590 0001:00184554 axPopup.txPopup.DoOnClick line 1008 base: 00B51000 if NOT exists ( select * from sysobjects where [Name] = 'Variations' AND [Type] = 'U' ) CREATE TABLE dbo.Variations ( [ID] int IDENTITY (1, 1) NOT NULL , GUID uniqueidentifier Null default( NewID() ) rowguidcol, [Resource_ID] int NULL , Warehouse_ID int NULL , [OrderItem_ID] int NULL , [Relationship_ID] int NULL , [Component_ID] int NULL , [Spec_ID] int NULL , [Date_Created] datetime default GetDate() , [Date_Modified] datetime NULL , [Date_Locked] datetime NULL , ServerName varchar( 100 ) Null default( @@ServerName ), WorkStation varchar( 100 ) Null default( App_Name() ), UserName varchar( 100 ) Null default( System_User ), [Name] char(50) NULL , [Variations_List] [varchar] (500) NULL , [Sub-Variations_List] [varchar] (500) NULL , Base_Value char(50) NULL , [Name_00] char(50) NULL , [Name_01] char(50) NULL , [Name_02] char(50) NULL , [Name_03] char(50) NULL , [Name_04] char(50) NULL , [Name_05] char(50) NULL , [Name_06] char(50) NULL , [Name_07] char(50) NULL , [Name_08] char(50) NULL , [Name_09] char(50) NULL , [Name_10] char(50) NULL , [Name_11] char(50) NULL , [Name_12] char(50) NULL , [Name_13] char(50) NULL , [Name_14] char(50) NULL , [Name_15] char(50) NULL , [Name_16] char(50) NULL , [Name_17] char(50) NULL , [Name_18] char(50) NULL , [Name_19] char(50) NULL , [Name_20] char(50) NULL , [Name_21] char(50) NULL , [Name_22] char(50) NULL , [Name_23] char(50) NULL , [Name_24] char(50) NULL , [Name_25] char(50) NULL , [Name_26] char(50) NULL , [Name_27] char(50) NULL , [Name_28] char(50) NULL , [Name_29] char(50) NULL , [Value_00] char(50) NULL , [Value_01] char(50) NULL , [Value_02] char(50) NULL , [Value_03] char(50) NULL , [Value_04] char(50) NULL , [Value_05] char(50) NULL , [Value_06] char(50) NULL , [Value_07] char(50) NULL , [Value_08] char(50) NULL , [Value_09] char(50) NULL , [Value_10] char(50) NULL , [Value_11] char(50) NULL , [Value_12] char(50) NULL , [Value_13] char(50) NULL , [Value_14] char(50) NULL , [Value_15] char(50) NULL , [Value_16] char(50) NULL , [Value_17] char(50) NULL , [Value_18] char(50) NULL , [Value_19] char(50) NULL , [Value_20] char(50) NULL , [Value_21] char(50) NULL , [Value_22] char(50) NULL , [Value_23] char(50) NULL , [Value_24] char(50) NULL , [Value_25] char(50) NULL , [Value_26] char(50) NULL , [Value_27] char(50) NULL , [Value_28] char(50) NULL , [Value_29] char(50) NULL , [Quantity_00] decimal(18, 4) default (0), [Quantity_01] decimal(18, 4) default (0), [Quantity_02] decimal(18, 4) default (0), [Quantity_03] decimal(18, 4) default (0), [Quantity_04] decimal(18, 4) default (0), [Quantity_05] decimal(18, 4) default (0), [Quantity_06] decimal(18, 4) default (0), [Quantity_07] decimal(18, 4) default (0), [Quantity_08] decimal(18, 4) default (0), [Quantity_09] decimal(18, 4) default (0), [Quantity_10] decimal(18, 4) default (0), [Quantity_11] decimal(18, 4) default (0), [Quantity_12] decimal(18, 4) default (0), [Quantity_13] decimal(18, 4) default (0), [Quantity_14] decimal(18, 4) default (0), [Quantity_15] decimal(18, 4) default (0), [Quantity_16] decimal(18, 4) default (0), [Quantity_17] decimal(18, 4) default (0), [Quantity_18] decimal(18, 4) default (0), [Quantity_19] decimal(18, 4) default (0), [Quantity_20] decimal(18, 4) default (0), [Quantity_21] decimal(18, 4) default (0), [Quantity_22] decimal(18, 4) default (0), [Quantity_23] decimal(18, 4) default (0), [Quantity_24] decimal(18, 4) default (0), [Quantity_25] decimal(18, 4) default (0), [Quantity_26] decimal(18, 4) default (0), [Quantity_27] decimal(18, 4) default (0), [Quantity_28] decimal(18, 4) default (0), [Quantity_29] decimal(18, 4) default (0), [Price_00] decimal(18, 4) default (0), [Price_01] decimal(18, 4) default (0), [Price_02] decimal(18, 4) default (0), [Price_03] decimal(18, 4) default (0), [Price_04] decimal(18, 4) default (0), [Price_05] decimal(18, 4) default (0), [Price_06] decimal(18, 4) default (0), [Price_07] decimal(18, 4) default (0), [Price_08] decimal(18, 4) default (0), [Price_09] decimal(18, 4) default (0), [Price_10] decimal(18, 4) default (0), [Price_11] decimal(18, 4) default (0), [Price_12] decimal(18, 4) default (0), [Price_13] decimal(18, 4) default (0), [Price_14] decimal(18, 4) default (0), [Price_15] decimal(18, 4) default (0), [Price_16] decimal(18, 4) default (0), [Price_17] decimal(18, 4) default (0), [Price_18] decimal(18, 4) default (0), [Price_19] decimal(18, 4) default (0), [Price_20] decimal(18, 4) default (0), [Price_21] decimal(18, 4) default (0), [Price_22] decimal(18, 4) default (0), [Price_23] decimal(18, 4) default (0), [Price_24] decimal(18, 4) default (0), [Price_25] decimal(18, 4) default (0), [Price_26] decimal(18, 4) default (0), [Price_27] decimal(18, 4) default (0), [Price_28] decimal(18, 4) default (0), [Price_29] decimal(18, 4) default (0), [Audio] image NULL, [Video] image NULL, CONSTRAINT [PK_Variations] PRIMARY KEY CLUSTERED ( [ID] ), constraint IX_Variations_GUID unique nonclustered ( GUID ), CONSTRAINT [FK_Variations_Resources] FOREIGN KEY ( [Resource_ID] ) REFERENCES [Resources] ( [ID] ) ON DELETE CASCADE, CONSTRAINT [FK_Variations_Warehouses] FOREIGN KEY ( [Warehouse_ID] ) REFERENCES [Warehouses] ( [ID] ) ON DELETE CASCADE, CONSTRAINT [FK_Variations_Relationships] FOREIGN KEY ( [Relationship_ID] ) REFERENCES [Relationships] ( [ID] ) ON DELETE CASCADE, CONSTRAINT [FK_Variations_OrderItems] FOREIGN KEY ( [OrderItem_ID] ) REFERENCES [OrderItems] ( [ID] ) ON DELETE CASCADE ) 6/18/2007 10:35:03 AM v1.3184 - Introducing FOREIGN KEY constraint 'FK_Variations_Warehouses' on table 'Variations' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints Continue or restart VDM - This error was queued for analysis, we apologize. if NOT exists ( select * from sysobjects where [Name] = 'Variations' AND [Type] = 'U' ) CREATE 0001:002266DC axView.txView.ExecuteSql line 8222 0001:00213318 axView.txView.DoOnTimer line 6450 base: 00B51000 if NOT exists ( select * from sysobjects where [Name] = 'Variations' AND [Type] = 'U' ) CREATE TABLE dbo.Variations ( [ID] int IDENTITY (1, 1) NOT NULL , GUID uniqueidentifier Null default( NewID() ) rowguidcol, [Resource_ID] int NULL , Warehouse_ID int NULL , [OrderItem_ID] int NULL , [Relationship_ID] int NULL , [Component_ID] int NULL , [Spec_ID] int NULL , [Date_Created] datetime default GetDate() , [Date_Modified] datetime NULL , [Date_Locked] datetime NULL , ServerName varchar( 100 ) Null default( @@ServerName ), WorkStation varchar( 100 ) Null default( App_Name() ), UserName varchar( 100 ) Null default( System_User ), [Name] char(50) NULL , [Vari