This tab of the ADO action configures the SQL statement to be executed and how to process the results.

 

SQL statement: The SQL statement to execute.

 

Statement returns results: If checked, the results of the query will be stored in an ADO_RS temporary macro.  See the Server.bld sample for how to process the results within a build.

 

 

Note: Bracket characters [ ] and percent sign % characters within this field must be doubled up (just as in any other field), since these are normally interpreted by  Visual Build as referencing script code and macros within a field.