Dynamic SQL syntax

Answered

Tim Wong

• June 02, 2020 06:19

It would be good to make the SQL dynamic syntax to be consistent across all the B1Up setup as some of them using syntax SQL(‘SELECT …’) and other using SQL:SELECT…

 

Vote

0

• 

  SSP Automation

  • June 02, 2020 06:20

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 22085]
  
• 

  Rasmus Jensen

  • June 02, 2020 14:42

  Hi Tim

  SQL(‘SELECT …’) syntax is used where the SQL should be able to use it among/in the middle of other text. The SQL: syntax is for fields that only bring back the value of the SQL directly.

  So there is logic to the system...

  Should it be unified it would need to be the SQL(‘SELECT …’) syntax and have the old one as backward compatibility.

Please sign in to leave a comment.