Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    How to transfer a null variable to Oracle via a null field?

    JS Code
    isc.DataSource.get('T_projectApplyDS').fetchData({subID:null},function(){},{operationId:'findSHlist'})
    DS Code
    <operationBinding operationType="fetch" operationId="findSHlist">
    <customSQL><![CDATA[
    select * From Table where itemID=$criteria.subID
    ]]></customSQL>
    </operationBinding>

    As the code

    Expection result is' Select * From Table where itemID=null'(In Sql Server )

    But actual result is 'Select * From Table Where itemID=$criteria.subID '(In Oracle )

    #2
    Please see the FAQ for the information you need to post when asking a question. You are missing basics such as your product and version, as well as the server logs for the request that is not doing what you want.

    Comment

    Working...
    X