Database component dynamic SQL

Discussion in 'CRM / Helpdesk / App Integration' started by SWSDEV, Jan 14, 2011.

Thread Status:
Not open for further replies.
  1. SWSDEV

    SWSDEV Member

    Joined:
    Feb 23, 2008
    Messages:
    256
    Likes Received:
    0
    It would be great if the database component could take a variable in the SQL field. Then SQL could be dynamically built.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    Well, you can use a parameter for that. Parameters values are put into the SQL statement, so you could have your SQL statement like this:
    {0}

    And then enter a single parameter pointing to a variable containing the string that you need.

    Regards,
     
  3. SWSDEV

    SWSDEV Member

    Joined:
    Feb 23, 2008
    Messages:
    256
    Likes Received:
    0
    Oh right, that makes sense. Didn't think of that.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.