1/21/2008 4:06:51 PM
v1.3626 - Access violation at address 00AE481F in module 'axVDM.ocx'. Read of address 6C727673
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 2001 [ID],[GUID],[WebSite_ID],[Contact_ID],[Catalog_ID],[Resource_ID],[Order_ID],[Activit
0001:000C379C       XMLDoc.AddNodeClassInfo line 885
0001:00191058       axPopup.txPopup.DoOnClick line 1154 base: 00A21000
select top 2001 [ID],[GUID],[WebSite_ID],[Contact_ID],[Catalog_ID],[Resource_ID],[Order_ID],[Activity_ID],[Date_Created],[Date_Modified],[Workstation],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Sequence],Cast( Note as VarChar( 1000 ) ) as [Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Notes where (([Activity_ID]=1239)) AND ([Type]<>'Attachment') order by [ID]

1/7/2008 12:46:22 PM
v1.3560 - 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: 00A61000


12/18/2007 11:38:50 AM
v1.3564 - The operation was canceled by the user
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:001833E0       SHDocVw.TWebBrowser.Navigate line 2492
0001:0019018C       axPopup.txPopup.DoOnClick line 1110 base: 00B51000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[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]=3772)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Sequence] DESC, [ID] DESC

12/18/2007 11:38:36 AM
v1.3564 - The operation was canceled by the user
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:001833E0       SHDocVw.TWebBrowser.Navigate line 2492
0001:0019018C       axPopup.txPopup.DoOnClick line 1110 base: 00B51000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,[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],'$' + rTrim( Cast( Change as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Locked_Deposits as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Balance as Decimal(18,2) ) ) as Bal_Amts,[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( 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]=3772

12/18/2007 11:30:09 AM
v1.3564 - File not found: V:\VDM_Cashin_Master.udl
Continue or restart VDM - This error was queued for analysis, we apologize.

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


12/11/2007 7:01:41 PM
v1.3548 - 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:001E4E10       axView.txTree.LoadDir line 2135 base: 00A61000


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],[Da