Using a WHERE clause to query for a uniqueindentifier using ExecuteStmt RRS feed

  • Question

  • Hi,

    I am trying to execute a SELECT statement through the ExecuteStmt command of Microsoft.Dynamics.BusinessConnectorNet.Axapta object but it keeps failing with the following error:

    Unable to compile "static void ComExecuteStmt(ECL_AIFDATAJOIN axTbl_0) { SELECT * FROM axTbl_0 WHERE axTbl_0.MESSAGEID == "EB15199C-23E9-41CF-BAB2-BBDB507C8A33";} "

    Query: SELECT * FROM %1 WHERE %1.MESSAGEID == "EB15199C-23E9-41CF-BAB2-BBDB507C8A33"

    If I query for a non-GUID field on the same table it works ok.

    Any suggestions?

    Thanks in advance. 

    Monday, April 14, 2014 3:07 PM