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],[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]=3

11/20/2007 5:26:01 PM
v1.3525 - Invalid column name 'Title'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 501 [ID],[Title], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from WebSites order 
0001:0022FC88       axView.txView.ExecuteRS line 8176
0001:001E5F8C       axView.txTree.DoOnExpanding line 2329 base: 00B51000
select top 501 [ID],[Title], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from WebSites order by [Title], [ID]

11/7/2007 8:53:39 AM
v1.3525 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select [Name] from Resources where Can_be_Sold=1 and Active=1 AND [Name] like '%ed%' order by 1
0001:002025C0       axView.txGrid.LoadLookup line 4346
0001:002423AC       axVDM.Finalization line 54 base: 00AB1000
select [Name] from Resources where Can_be_Sold=1 and Active=1 AND [Name] like '%ed%' order by 1

11/6/2007 8:16:05 AM
v1.3525 - The requested resource is in use
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:0018337C       SHDocVw.TWebBrowser.Navigate line 2492
0001:001E761C       axView.txTree.DoOnChange line 2595 base: 00AB1000
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_Do