12/7/2007 6:26:24 AM
v1.3560 - Cannot open database "VDM_ACI" requested by the login. The login failed
Continue or restart VDM - This error was queued for analysis, we apologize.

0001:001EADF8       axView.txView.CreateRS line 2772
0001:001E68D8       axView.txTree.DoOnExpanding line 2328 base: 00B51000


11/29/2007 7:05:13 AM
v1.3560 - 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 (3769, 'Fine Portrait Canvas')
0001:0001E74C       ComObj.DispCallError line 1795
0001:002433D8       axVDM.Finalization line 49 base: 00B51000
insert into OrderItems ([Order_ID], [Resource_Name]) values (3769, 'Fine Portrait Canvas')

11/29/2007 6:59:42 AM
v1.3560 - 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:0001E74C       ComObj.DispCallError line 1795
0001:002433D8       axVDM.Finalization line 49 base: 00B51000
insert into Contacts ([Group],[Name],Phone,Address,City,State_or_Province,Postal_Code,Country,Price_Level) values('Sales','','','','','','','',)

11/29/2007 6:47:46 AM
v1.3554 - The object 'DF__OrderItem__Resou__68F2894D' is dependent on column 'Resource_Code'
Continue or restart VDM - This error was queued for analysis, we apologize.


----------------
-- OrderItems --
----------------

if ( select [Value] from ::fn_listextend
0001:002317A4       axView.txView.ExecuteSql line 8256
0001:001E68D8       axView.txTree.DoOnExpanding line 2353 base: 00B51000


----------------
-- OrderItems --
----------------

if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.2' begin
  if  exists ( select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'OrderItems' AND Column_Name = 'Order_Name' ) begin
	  alter table OrderItems alter column [Order_Name] varchar( 50 ) NULL 
	  alter table OrderItems alter column [Resource_Name]      varchar(50) NULL 
	  alter table OrderItems alter column [Resource_Code]      varchar(20) NULL 
	  alter table OrderItems alter column [Resource_UPC]       varchar(20) NULL 
	  alter table OrderItems alter column [Reference_Code]     varchar(20) NULL 
	  alter table OrderItems alter column Serial_or_Lot_Number varchar(50) NULL 
	  alter table OrderItems alter column [Template_Name]      varchar(50) NULL 
	  alter table OrderItems alter column [Contact_Name]       varchar(50) NULL 
    alter table OrderItems alter column Sales_Account   varchar( 50 ) Null
    alter table OrderItems alter column Asset_Account   varchar( 50 ) Null
    alter table OrderItems alter column COGS_Account    varchar( 50 ) Null
    alter table OrderItems alter column Expense_Account varchar( 50 ) Null
	  alter table Numbers alter column Last_Number varchar( 20 ) NULL
    execute dbo.DropDefault    'OrderItems', 'Type'
    execute dbo.DropConstraint 'OrderItems', 'Type'
    drop index IX_OrderItems on OrderItems
    alter table OrderItems alter column [Type] varchar( 20 ) Null
    alter table OrderItems add default 'Sale' for [Type] 
    alter table OrderItems add constraint CK_OrderItems_Type check ( [Type] IN ( 'Sale', 'Purchase', 'Adjustment', 'Production', 'Manufacturing', 'Estimate', 'Service' ) )
    execute dbo.DropDefault    'OrderItems', 'Unit'
    alter table OrderItems alter column Unit varchar( 20 ) Null
    alter table OrderItems add default 'Each' for Unit 
  end
end

11/28/2007 6:40:44 AM
v1.3554 - Access violation at address 00CBD7D7 in module 'axVDM4.ocx'. Read of address 00000085
Continue or restart VDM - This error was queued for analysis, we apologize.
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided
0001:0016C7C8       ComCtrls.TTreeNode.GetTreeView line 7080
0001:0023F6D0       axView.txTabsEx.DoOnClick line 9725 base: 00B51000
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],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],[Auto_Generated],[Repeat_Frequency],[Employee],[Phone],[Name],[Main_Contact_Name],[Reference],[Group],[Currency],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],[Taxes],[Taxes1],[Taxes2],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AP_Account],[Asset_Account],[Expense_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]=406

11/28/2007 6:40:39 AM
v1.3554 - Access violation at address 00CBD7D7 in module 'axVDM4.ocx'. Read of address 00000085
Continue or restart VDM - This error was queued for analysis, we apologize.
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided
0001:0016C7C8       ComCtrls.TTreeNode.GetTreeView line 7080
0001:0023F6D0       axView.txTabsEx.DoOnClick line 9725 base: 00B51000
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],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],[Auto_Generated],[Repeat_Frequency],[Employee],[Phone],[Name],[Main_Contact_Name],[Reference],[Group],[Currency],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],[Taxes],[Taxes1],[Taxes2],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AP_Account],[Asset_Account],[Expense_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]=2260

11/28/2007 6:40:35 AM
v1.3554 - Access violation at address 00CBD7D7 in module 'axVDM4.ocx'. Read of address 00000085
Continue or restart VDM - This error was queued for analysis, we apologize.
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided
0001:0016C7C8       ComCtrls.TTreeNode.GetTreeView line 7080
0001:0023F6D0       axView.txTabsEx.DoOnClick line 9725 base: 00B51000
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],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],[Auto_Generated],[Repeat_Frequency],[Employee],[Phone],[Name],[Main_Contact_Name],[Reference],[Group],[Currency],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],[Taxes],[Taxes1],[Taxes2],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AP_Account],[Asset_Account],[Expense_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]=2260

11/28/2007 6:40:32 AM
v1.3554 - Access violation at address 00CBD7D7 in module 'axVDM4.ocx'. Read of address 00000085
Continue or restart VDM - This error was queued for analysis, we apologize.
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided
0001:0016C7C8       ComCtrls.TTreeNode.GetTreeView line 7080
0001:0023F6D0       axView.txTabsEx.DoOnClick line 9725 base: 00B51000
select [ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],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],[Auto_Generated],[Repeat_Frequency],[Employee],[Phone],[Name],[Main_Contact_Name],[Reference],[Group],[Currency],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],[Taxes],[Taxes1],[Taxes2],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Ship_Name],[Ship_Address],[Ship_City],[Sh