Database component dynamic SQL

Dedicated forum for the visual 'drag and drop' voice application designer that allows easy creation of advanced voice applications without programming knowledge

Moderators: kevin, 3CX staff

Database component dynamic SQL

Postby SWSDEV » Fri Jan 14, 2011 9:22 am

It would be great if the database component could take a variable in the SQL field. Then SQL could be dynamically built.
Shahzad Qureshi
SWS Development - 3CX Certified Partner
Custom 3CX integration
Salt Lake City, UT USA
801-938-7712
swsdev.com
SWSDEV
Expert
Expert
 
Posts: 246
Joined: Sat Feb 23, 2008 6:51 am
Location: Salt Lake City, Utah - USA

Re: Database component dynamic SQL

Postby VAD_Support » Fri Jan 14, 2011 3:51 pm

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,
VAD_Support
3CX Valued Professional
3CX Valued Professional
 
Posts: 439
Joined: Thu Aug 06, 2009 5:29 pm

Re: Database component dynamic SQL

Postby SWSDEV » Fri Jan 14, 2011 8:10 pm

Oh right, that makes sense. Didn't think of that.
Shahzad Qureshi
SWS Development - 3CX Certified Partner
Custom 3CX integration
Salt Lake City, UT USA
801-938-7712
swsdev.com
SWSDEV
Expert
Expert
 
Posts: 246
Joined: Sat Feb 23, 2008 6:51 am
Location: Salt Lake City, Utah - USA


Return to 3CX Voice Application Designer (VAD)


Who is online

Users browsing this forum: No registered users and 0 guests

Announcements: