8/3/2010 12:34:30 PM
v1.4658 - Subqueries are not allowed in this context. Only scalar expressions are allowed
Continue or restart VDM - This error was queued for analysis, we apologize.
create procedure dbo.AddExpiry( @ContactID int, @Expiry datetime, @User varchar( 100 ) )  as
begin

0001:002414EC       axView.txView.UpdBlob line 11032
0001:001E5008       axView.txTree.WhereClause line 3373 base: 00B51000
create procedure dbo.AddExpiry( @ContactID int, @Expiry datetime, @User varchar( 100 ) )  as
begin
  begin tran
  alter table OrderItems disable trigger all
  insert OrderItems (Order_ID,Date_Locked,Date_Required,Contact_ID,Contact_Name,Resource_ID,Resource_Code,
                     Resource_Name,Quantity,WorkStation,Date_Modified)
    values( 18, GetDate(), @Expiry, @ContactID, (select top 1 Name from Contacts where ID=@ContactID),
           (select top 1 ID from Resources where Code='MF'), 'MF', 'Membership Fee', 1, @User, Getdate() ) 
  alter table OrderItems enable trigger all
  commit tran
end

8/3/2010 12:25:05 PM
v1.4658 - Incorrect syntax near the keyword 'AND'
Continue or restart VDM - This error was queued for analysis, we apologize.
select [Photo2] from WebSites where [ID]=488
0001:0024CA68       axView.txView.DoOnMouseMove line 11811
0001:0025A7F8       axVDM.Finalization line 49 base: 00B51000
select [Photo2] from WebSites where [ID]=488

28/07/2010 3:28:56 PM
v1.4658 - 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:0002C83C       ComObj.CreateComObject line 1368
0001:0022B7F4       axView.txView.DoOnChange line 9005 base: 00C11000


7/28/2010 7:33:38 AM
v1.4628 - Access violation at address 00D66BAB in module 'axVDM30.ocx'. Read of address 00000000
Continue or restart VDM - This error was queued for analysis, we apologize.
select cast( ( select top 101 [ID],[WebSite_ID],[Contact_ID],[Resource_ID],[Order_ID],[Activity_ID],
0001:00214A88       axView.AddProp line 6361
0001:0022B7DC       axView.txView.BlobAsString line 8297 base: 00B51000
select cast( ( select top 101 [ID],[WebSite_ID],[Contact_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],[Type],Cast( [Note] as VarChar( 1000 ) ) as [Note],Photo1Name,Photo2Name,Photo3Name,Photo4Name,Photo5Name,Photo6Name,Photo7Name,Photo8Name,Photo9Name, cast( isNull( DataLength( [Audio] ), 0 ) as int ) as Audio_Length from Notes A  where (([Activity_ID]=45)) AND (isNull([Type],'')<>'Attachment') order by [Created_Modified], [ID] FOR XML RAW ) as varchar( max ) )

7/27/2010 1:07:54 PM
v1.4628 - Incorrect syntax near the keyword 'AND'
Continue or restart VDM - This error was queued for analysis, we apologize.
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company
0001:00221720       axView.txView.DoOnFileChange line 7520
0001:0022BD10       axView.txView.DoOnTimer line 8559 base: 00B51000
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company_Configuration ) values( 'Lamcel', 1 )

7/27/2010 1:07:46 PM
v1.4628 - Incorrect syntax near the keyword 'AND'
Continue or restart VDM - This error was queued for analysis, we apologize.
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company
0001:00221720       axView.txView.DoOnFileChange line 7520
0001:0022BD10       axView.txView.DoOnTimer line 8559 base: 00B51000
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company_Configuration ) values( 'Lamcel', 1 )

7/27/2010 1:07:37 PM
v1.4628 - Incorrect syntax near the keyword 'AND'
Continue or restart VDM - This error was queued for analysis, we apologize.
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company
0001:00221720       axView.txView.DoOnFileChange line 7520
0001:0022BD10       axView.txView.DoOnTimer line 8559 base: 00B51000
if NOT exists( select [ID] from Contacts where [Name] = 'Lamcel' ) insert Contacts ( [Name], Company_Configuration ) values( 'Lamcel', 1 )

26/07/2010 12:50:22 PM
v1.4653 - Column name 'User5' is repeated. The same attribute cannot be generated more than once on the same XML tag
Continue or restart VDM - This error was queued for analysis, we apologize.
select cast( ( select A.[ID],A.[OrderItem_ID],A.[Contact_ID],A.[Resource_ID],A.[Activity_ID],A.[Date
0001:00241BDC       axView.txView.ExecuteRS line 10409
0001:0018596C       axPopup.txPopup.DoOnClick line 1244 base: 00C31000
select cast( ( select A.[ID],A.[OrderItem_ID],A.[Contact_ID],A.[Resource_ID],A.[Activity_ID],A.[Date_Created],A.[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as [Created_Modified],A.[Date_Locked],A.[Sequence],A.[Name],A.[Contact_Name],A.[Resource_Name],A.[Minutes],A.[Hours],A.[Days],A.[Activities_Count],A.[Date_Start],A.[Date_Stop],A.[Note],A.[User1],A.[User2],A.[User3],A.[User4],A.[User11],A.[User12],A.[User13],A.[User14],A.[User16],A.[User19],Cast( [User5] as VarChar( 1000 ) ) as [User5],Cast( [User15] as VarChar( 1000 ) ) as [User15],A.[User6],A.[User7],A.[User17],A.[User8],A.[User9],A.[User18],A.[Change_Notification_List],A.[Notification_Condition],A.[Late_Notification_List],A.[Notify_when_Late_by_Days],A.[Late_Reminder_every_Hours],A.[Follow-Up_Notification_List],A.[Follow-Up_every_Days],A.[Late_Follow-Up_Reminder_every_Hours],A.[Date_Last_Follow-Up_Done],Photo1Name,Photo2Name,Photo3Name,Photo4Name,Photo5Name,User5,User15 from Activities A  where A.[ID]=44  FOR XML RAW ) as varchar( max ) )

7/21/2010 4:16:08 PM
v1.4653 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select cast( ( select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNul
0001:001F5A28       axView.txTree.RefreshValues line 4056
0001:0018596C       axPopup.txPopup.DoOnClick line 1244 base: 00B51000
select cast( ( select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as [ID_Number],[Phone],[Name],[Main_Contact_Name],[Reference],[Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as [Total_Amts],[Grand_Total],[Total],[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],[Discount_Amount],[Percent_Discount],[Change],[Balance],( select '$' + rTrim( Cast( C.Credit_Limit as Decimal(18,2) ) ) + ', $' + rTrim( Cast( C.Credit_Limit - C.Balance - A.Balance as Decimal(18,2) ) ) from Contacts C where C.ID=A.Contact_ID ) as [Credit_Limit],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[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] from Orders A where [ID]=386  FOR XML RAW ) as varchar( max ) )

7/21/2010 4:16:02 PM
v1.4653 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select cast( ( select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNul
0001:001F5A28       axView.txTree.RefreshValues line 4056
0001:0018596C       axPopup.txPopup.DoOnClick line 1244 base: 00B51000
select cast( ( select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as [ID_Number],[Phone],[Name],[Main_Contact_Name],[Reference],[Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as [Total_Amts],[Grand_Total],[Total],[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],[Discount_Amount],[Percent_Discount],[Change],[Balance],( select '$' + rTrim( Cast( C.Credit_Limit as Decimal(18,2) ) ) + ', $' + rTrim( Cast( C.Credit_Limit - C.Balance - A.Balance as Decimal(18,2) ) ) from Contacts C where C.ID=A.Contact_ID ) as [Credit_Limit],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[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] from Orders A where [ID]=386  FOR XML RAW ) as varchar( max ) )

25/06/2010 10:08:35 AM
v1.4653 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select cast( ( select top 501 [ID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Cre
0001:001EDE28       axView.txTree.LoadQuery line 3700
0001:0025A794       axVDM.Finalization line 49 base: 00C21000
select cast( ( select top 501 [ID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as [Created_Modified],[Date_Locked],[Sequence],[Name],[Contact_Name],[Resource_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[User1],[User2],[User3],[User4],[User11],[User12],[User13],[User14],[User16],[User19],Cast( [User5] as VarChar( 1000 ) ) as [User5],Cast( [User15] as VarChar( 1000 ) ) as [User15],[User6],[User7],[User17],[User8],[User9],[User18],[Change_Notification_List],[Notification_Condition],[Late