• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

SQL formatter

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL formatter

    the SQL formatter is changing values in my ACS Run SQL Script when I copy and paste into NAB data source, pictured here: SQL formatter.docx

  • #2
    Yes, it appears the NAB SQL Parser is dropping the quotes around "XXXX YYYY" (or "Account Number" in your case) when it follows any kind of formula. We will try to get that corrected in an upcoming build.

    If you remove the space in "Account Number" or change it to "Account_Number" then it will work.

    FYI, NAB squeezes out spaces in column names because they cause problems in the JavaScript bindings. The aliases in data source columns aren't meant to be column headers, but rather references to the columns themselves. Column header values should be specified in the grid widgets.

    Comment


    • #3
      Gotcha! Thanks!

      Comment

      Working...
      X