Good afternoon,

I am querying the case object and I receive the following error from Flex.  In addition, even though there is an error the query still executes successfully (still returns the correct data).

SQLError: 'Error #3115: SQL Error.', details:'near "Case": syntax error', operation:'execute'
    at flash.data::SQLStatement/internalExecute()
    at flash.data::SQLStatement/execute()
    at <anonymous>()[/home/jamesw/projects/mavericks/sdkair/src/com/salesforce/AIRConnection.as:1197]
    at com.salesforce::AsyncResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/AsyncResponder.as:90]
    at <anonymous>()[/home/jamesw/projects/mavericks/sdkair/src/com/salesforce/AIRConnection.as:459]
    at com.salesforce::AsyncResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/AsyncResponder.as:90]
    at SalesForceResponder/result()[/home/jamesw/projects/mavericks/sdk/src/com/salesforce/Connection.as:1303]
    at mx.rpc::AsyncToken/http://www.adobe.com/2006/flex/mx/internal::applyResult()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncToken.as:197]
    at mx.rpc.events::ResultEvent/http://www.adobe.com/2006/flex/mx/internal::callTokenResponders()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\events\ResultEvent.as:159]
    at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::dispatchRpcEvent()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AbstractInvoker.as:165]
    at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::resultHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AbstractInvoker.as:191]
    at mx.rpc::Responder/result()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\Responder.as:41]
    at mx.rpc::AsyncRequest/acknowledge()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:74]
    at DirectHTTPMessageResponder/completeHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\channels\DirectHTTPChannel.as:381]
    at flash.events::EventDispatcher/dispatchEventFunction()
    at flash.events::EventDispatcher/dispatchEvent()
    at flash.net::URLLoader/onComplete()


Here's the code that is causing the error:

            var queryString:String = "Select Id, Subject, CaseNumber, LastModifiedDate, CreatedDate From Case where Case.isClosed = false and ContactId='" + p_contactId + "'";
                               
            Global.sforceConnection.query(queryString, new AsyncResponder( function (queryResult:QueryResult):void {
                    var caseData:ArrayCollection = new ArrayCollection;
           
                })
            );


Have any ideas?

Thank you,
Michael