7/9/2008 11:37:12 AM
v1.4182 - Invalid column name 'WebPage_ID'
Continue or restart VDM - This error was queued for analysis, we apologize.
select [WebPage_ID] from WebSites where [ID]=489
select [WebPage_ID] from WebSites where [ID]=489

7/3/2008 5:35:43 PM
v1.4169 - A column has been specified more than once in the order by list. Columns in the order by list must be unique
Continue or restart VDM - This error was queued for analysis, we apologize.

select isNull( Ledger_ID, ID ) as ID, [Date], Account_Name, Account_Type as [Type], Reference, Num
0001:00228EE4       axView.txView.RunSQL line 7261
0001:00191128       axPopup.txPopup.DoOnClick line 1176 base: 00B61000

select isNull( Ledger_ID, ID ) as ID, [Date], Account_Name, Account_Type as [Type], Reference, Number, 
          Amount * ( 1 + Sign( Amount ) ) / 2 *    ( ASCII( Account_Type ) - ASCII( 'C' ) ) + 
          Amount * ( 1 - Sign( Amount ) ) / 2 * Abs( ASCII( Account_Type ) - ASCII( 'D' ) ) * Sign( Amount ) as Debit,
          Amount * ( 1 + Sign( Amount ) ) / 2 * Abs( ASCII( Account_Type ) - ASCII( 'D' ) ) + 
          Amount * ( 1 - Sign( Amount ) ) / 2 *    ( ASCII( Account_Type ) - ASCII( 'C' ) ) * Sign( Amount ) as Credit 
  from Ledger  
  where Amount <> 0 AND 
           [Date] >= '7/3/2008' AND [Date] < DateAdd( day, 1, '7/3/2008' )
  order by isNull( Ledger_ID, ID ), [Date], ID
  compute Count( [Date] ), Sum( Amount * ( 1 + Sign( Amount ) ) / 2 * ( ASCII( Account_Type ) - ASCII( 'C' ) ) + Amount * ( 1 - Sign( Amount ) ) / 2 * Abs( ASCII( Account_Type ) - ASCII( 'D' ) ) * Sign( Amount ) ),
                        Sum( Amount * ( 1 + Sign( Amount ) ) / 2 * Abs( ASCII( Account_Type ) - ASCII( 'D' ) ) + Amount * ( 1 - Sign( Amount ) ) / 2 * ( ASCII( Account_Type ) - ASCII( 'C' ) ) * Sign( Amount ) )


7/3/2008 5:10:30 PM
v1.4169 - List index out of bounds (0)
Continue or restart VDM - This error was queued for analysis, we apologize.

select L.Contact_Name, L.Date, L.Number, L.Reference, 
       case when DateDiff( day, L.Date, Ge
0001:0016C620       ComCtrls.TreeViewError line 7025
0001:00191128       axPopup.txPopup.DoOnClick line 1176 base: 00B61000

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


7/3/2008 3:22:19 PM
v1.4167 - Column 'Ledger.Date' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
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:00228D78       axView.txView.RunSQL line 7259
0001:00191128       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, L.Date, GetDate() ) <  60 then L.Amount else Null end as [>30-60], 
       case when DateDiff( day, L.Date, GetDate() ) >= 60 AND 
                 DateDiff( day, L.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 
  where L.Date_Locked is Null AND L.Contact_ID is NOT Null AND L.Account_is_AR = 1 AND L.Amount <> 0 AND 
        ( select Sum( B.Amount ) from Ledger B where B.Date_Locked is Null AND 
                 B.Contact_ID = L.Contact_ID AND B.Account_is_AR = 1 AND B.Amount <> 0 ) <> 0
  group by L.Contact_Name
  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
  
-- Add Totals


7/3/2008 3:20:03 PM
v1.4167 - An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference
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:00228D78       axView.txView.RunSQL line 7259
0001:00191128       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, L.Date, GetDate() ) <  60 then L.Amount else Null end as [>30-60], 
       case when DateDiff( day, L.Date, GetDate() ) >= 60 AND 
                 DateDiff( day, L.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 
  where L.Date_Locked is Null AND L.Contact_ID is NOT Null AND L.Account_is_AR = 1 AND L.Amount <> 0 AND 
        ( select Sum( L.Amount ) from Ledger B where B.Date_Locked is Null AND 
                 B.Contact_ID = L.Contact_ID AND B.Account_is_AR = 1 AND B.Amount <> 0 ) <> 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
  
-- Add Totals


7/3/2008 3:19:09 PM
v1.4167 - An expression of non-boolean type specified in a context where a condition is expected, near 'order'
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:00228D78       axView.txView.RunSQL line 7259
0001:00191128       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, L.Date, GetDate() ) <  60 then L.Amount else Null end as [>30-60], 
       case when DateDiff( day, L.Date, GetDate() ) >= 60 AND 
                 DateDiff( day, L.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 
  where L.Date_Locked is Null AND L.Contact_ID is NOT Null AND L.Account_is_AR = 1 AND L.Amount <> 0 AND 
        ( select Sum( L.Amount ) from Ledger B where B.Date_Locked is Null AND B.Contact_ID = L.Contact_ID AND B.Account_is_AR = 1 AND B.Amount <> 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
  
-- Add Totals


7/3/2008 2:42:52 PM
v1.4166 - COMPUTE clause #1, aggregate expression #2 is not in the select list
Continue or restart VDM - This error was que