Subtotal: $17,583.00
Hello,
What SQL keywords are supported in SQL actions?
Can you use SQL Functions such as "SUBSTRING", "REVERSE", etc...when processing the data from tokens?
We have used "MAX" successfully but need to know what extent the built-in functions are available in the SQL Actions interface.
Thanks
Dave
Live Forms does not process script in any way other than token parsing. It will parse all tokens in Square Brackets "[" and "]" and replace them with actual values. Incorrect tokens in square brackets are replaced with empty string.
Live Forms also checks against SQL if the provided SQL is correct (from a syntax point of view).
Other than that, you're welcome to leverage any SQL Functions that are available in your version of SQL Server.
Thanks Mandeeps...The Case where I was receiving the invalid script, for refrence, was using REPLACE(REPLACE(SQLColumn,'[',''),']','') ...I don't know if reversing (putting replace of ] first) would make valid but thought I would let you know...
Thanks for replying...
Just following up (but would be nice to have someone from Team Mandeep chime in as well) it seems that SQL scripts can't be parsed/accepted if they contain either "[" or "]" characters as, I'm assuming, they are reserved for tokens? Are their any other reserved characters that can't be contained in SQL scripts?
Found this out when trying to replace '[' and ']' from text content...