Using Mircosoft SQL Stored Procedures with LANSA

Date:3 August 2016
Product/Release:Visual LANSA - All versions
Abstract:Using Mircosoft SQL Stored Procedures with LANSA
Submitted By:LANSA Technical Support

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.