Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

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.