7/3/2008 1:58:38 PM
v1.4166 - Conversion failed when converting datetime from character string
Continue or restart VDM - This error was queued for analysis, we apologize.
update WebPages set [Date_Verified]='s' where [ID]=13548
0001:0001E6AC       ComObj.DispCallError line 1795
0001:00259FB0       axVDM.Finalization line 49 base: 00B51000
update WebPages set [Date_Verified]='s' where [ID]=13548

7/3/2008 7:43:18 AM
v1.4164 - Invalid column name 'Balance_Due'
Continue or restart VDM - This error was queued for analysis, we apologize.

select L.Date, L.Number, L.Contact_Name, L.Reference, 
       case when DateDiff( day, L.Date, Ge
0001:00228BA4       axView.txView.RunSQL line 7266
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B61000

select L.Date, L.Number, L.Contact_Name, L.Reference, 
       case when DateDiff( day, L.Date, GetDate() ) <  30  
         then L.Amount else Null end as [Current], 
       case when DateDiff( day, L.Date, GetDate() ) >= 30  AND DateDiff( day, Date, GetDate() ) <  60 
         then L.Amount else Null end as [30-60], 
       case when DateDiff( day, L.Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then L.Amount else Null end as [60-90],
       case when DateDiff( day, L.Date, GetDate() ) >= 90  
         then L.Amount else Null end as [over 90]  
  from Ledger L join Contacts C on C.ID = L.Contact_ID 
  where L.Date_Locked is Null AND L.Contact_ID is NOT Null AND L.Account_is_AR = 1 AND L.Amount <> 0 AND C.Balance_Due <> 0  
  order by L.Contact_Name, L.Date, L.ID
  compute Count( L.Date ),
          Sum( case when DateDiff( day, L.Date, GetDate() ) <  30  then L.Amount else Null end ), 
          Sum( case when DateDiff( day, L.Date, GetDate() ) >= 30  AND 
                         DateDiff( day, L.Date, GetDate() ) <  60 then L.Amount else Null end ), 
          Sum( case when DateDiff( day, L.Date, GetDate() ) >= 60 AND 
                         DateDiff( day, L.Date, GetDate() ) <  90  then L.Amount else Null end ),
          Sum( case when DateDiff( day, L.Date, GetDate() ) >= 90  then L.Amount else Null end ) by L.Contact_Name
  


7/3/2008 7:39:51 AM
v1.4164 - COMPUTE clause #1, aggregate expression #2 is not in the select list
Continue or restart VDM - This error was queued for analysis, we apologize.

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) 
0001:00228BA4       axView.txView.RunSQL line 7266
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B61000

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) <  30  
         then Amount else Null end as [Current], 
       case when DateDiff( day, Date, GetDate() ) >= 30  AND DateDiff( day, Date, GetDate() ) <  60 
         then Amount else Null end as [30-60], 
       case when DateDiff( day, Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then Amount else Null end as [60-90],
       case when DateDiff( day, Date, GetDate() ) >= 90  
         then Amount else Null end as [over 90]  
  from Ledger 
  where Date_Locked is Null AND Contact_ID is NOT Null AND Account_is_AR = 1 AND Amount <> 0  
  order by Contact_Name, Date, ID
  compute Count( Date ),
          Sum( case when DateDiff( day, Date, GetDate() ) <  30  then Amount else 0 end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= 30  AND 
                         DateDiff( day, Date, GetDate() ) <  60 then Amount else Null end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= 60 AND 
                         DateDiff( day, Date, GetDate() ) <  90  then Amount else Null end ),
          Sum( case when DateDiff( day, Date, GetDate() ) >= 90  then Amount else Null end ) by Contact_Name
  


7/3/2008 7:37:01 AM
v1.4163 - List index out of bounds (0)
Continue or restart VDM - This error was queued for analysis, we apologize.

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) 
0001:000C3540       XMLDoc.CheckEncoding line 844
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B51000

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) <  30  
         then Amount else Null end as [Current], 
       case when DateDiff( day, Date, GetDate() ) >= 60  AND DateDiff( day, Date, GetDate() ) <  30 
         then Amount else Null end as [60-90], 
       case when DateDiff( day, Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then Amount else Null end as [90-90],
       case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  
         then Amount else Null end as [over @@(Last_Overdue=90)]  
  from Ledger 
  where Date_Locked is Null AND Contact_ID is NOT Null AND Account_is_AR = 1 AND Amount <> 0  
  order by Contact_Name, Date, ID
  compute Count( Date ),
          Sum( case when DateDiff( day, Date, GetDate() ) <  @@(Current_Days=30)  then Amount else 0 end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Current_Days=30)  AND 
                         DateDiff( day, Date, GetDate() ) <  @@(First_Overdue=60) then Amount else Null end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(First_Overdue=60) AND 
                         DateDiff( day, Date, GetDate() ) <  @@(Last_Overdue=90)  then Amount else Null end ),
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  then Amount else Null end ) by Contact_Name
  


7/3/2008 7:36:55 AM
v1.4163 - List index out of bounds (0)
Continue or restart VDM - This error was queued for analysis, we apologize.

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) 
0001:000C3540       XMLDoc.CheckEncoding line 844
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B51000

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) <  30  
         then Amount else Null end as [Current], 
       case when DateDiff( day, Date, GetDate() ) >= 60  AND DateDiff( day, Date, GetDate() ) <  30 
         then Amount else Null end as [60-90], 
       case when DateDiff( day, Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then Amount else Null end as [90-90],
       case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  
         then Amount else Null end as [over @@(Last_Overdue=90)]  
  from Ledger 
  where Date_Locked is Null AND Contact_ID is NOT Null AND Account_is_AR = 1 AND Amount <> 0  
  order by Contact_Name, Date, ID
  compute Count( Date ),
          Sum( case when DateDiff( day, Date, GetDate() ) <  @@(Current_Days=30)  then Amount else 0 end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Current_Days=30)  AND 
                         DateDiff( day, Date, GetDate() ) <  @@(First_Overdue=60) then Amount else Null end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(First_Overdue=60) AND 
                         DateDiff( day, Date, GetDate() ) <  @@(Last_Overdue=90)  then Amount else Null end ),
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  then Amount else Null end ) by Contact_Name
  


7/3/2008 7:36:51 AM
v1.4163 - List index out of bounds (0)
Continue or restart VDM - This error was queued for analysis, we apologize.

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) 
0001:000C3540       XMLDoc.CheckEncoding line 844
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B51000

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) <  30  
         then Amount else Null end as [Current], 
       case when DateDiff( day, Date, GetDate() ) >= 60  AND DateDiff( day, Date, GetDate() ) <  30 
         then Amount else Null end as [60-90], 
       case when DateDiff( day, Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then Amount else Null end as [90-90],
       case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  
         then Amount else Null end as [over @@(Last_Overdue=90)]  
  from Ledger 
  where Date_Locked is Null AND Contact_ID is NOT Null AND Account_is_AR = 1 AND Amount <> 0  
  order by Contact_Name, Date, ID
  compute Count( Date ),
          Sum( case when DateDiff( day, Date, GetDate() ) <  @@(Current_Days=30)  then Amount else 0 end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Current_Days=30)  AND 
                         DateDiff( day, Date, GetDate() ) <  @@(First_Overdue=60) then Amount else Null end ), 
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(First_Overdue=60) AND 
                         DateDiff( day, Date, GetDate() ) <  @@(Last_Overdue=90)  then Amount else Null end ),
          Sum( case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  then Amount else Null end ) by Contact_Name
  


7/3/2008 7:36:40 AM
v1.4163 - List index out of bounds (0)
Continue or restart VDM - This error was queued for analysis, we apologize.

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) 
0001:000C3540       XMLDoc.CheckEncoding line 844
0001:00190F2C       axPopup.txPopup.DoOnClick line 1176 base: 00B51000

select Date, Number, Contact_Name, Reference, 
       case when DateDiff( day, Date, GetDate() ) <  30  
         then Amount else Null end as [Current], 
       case when DateDiff( day, Date, GetDate() ) >= 60  AND DateDiff( day, Date, GetDate() ) <  30 
         then Amount else Null end as [60-90], 
       case when DateDiff( day, Date, GetDate() ) >= 60 AND DateDiff( day, Date, GetDate() ) <  90  
         then Amount else Null end as [90-90],
       case when DateDiff( day, Date, GetDate() ) >= @@(Last_Overdue=90)  
         then Amount else Null end as [over @@(Last_Overdue=90)]  
  from Ledger 
  where Date_Locked is Null AND Contact_ID is NOT Null AND Account_is_AR = 1 AND Amount <> 0  
  order by Contact_Name, Date, ID
  compute Count( Date ),
          Sum( case when