Using Mircosoft SQL Stored Procedures with LANSA

We are often asked whether, with Visual LANSA you are able to use Microsoft SQL Stored Procedures via the free format SQL command?

The answer is yes, this can be done either using a direct call to the stored procedure or by building the query into a string and passing it into the Select SQL statement.
A section has been added to the LANSA documentation with examples of how you can implement this. Refer to 7.108.2 SELECT_SQL Free Format Examples in the Technical Reference guide.