Skip to main content
Nintex Community Menu Bar

Does SOCommand benefit from parameter binding?

  • January 24, 2017
  • 1 reply
  • 2 views
P
Forum|alt.badge.img+13

Does SmartObject generate parameter binding for direct SQL execution to SQL Server?

If 100 different IDs are used is 1 query plan created or 100?

 

cmd.CommandText = "Select xmlname, xmlvalue FROM Process_XML.List WHERE  ProcessInstanceID = ?"

 

    1 reply

    A
    • Az-R
    • August 10, 2017

    Good day 


     


    I reviewed you post and the problem seems to be caused by a syntax error in your "where" clause. See link below -  the article attached should resolve your issue if not atleast clarify what's wrong with your SQL query -


    https://en.wikipedia.org/wiki/Prepared_statement#frb-inline


    regards


    Az-R

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement