Stored Procedure
Select the Stored Procedure part to add a part to the free-form surface that enables you to invoke a procedure stored at the location of a database. Stored procedures can be invoked using the following calling conventions:
• Database Application Remote Interface (DARI)
• SQL Call
Stored procedures reduce network traffic and increase data integrity. A stored procedure file can accept inputs from your application, can return outputs, and usually contains embedded SQL statements that are run as a unit. The stored procedure file must already exist; the VA Smalltalk Stored Procedure part is used only to run the stored procedure file.
Part:
Stored Procedure
Category:
Database Functions
Class Name:
AbtStoredProc
To display the
pop-up menu for the part, click with mouse button 2 on the part.
To further define the function of a nonvisual part, double-click on it to open the settings view window for the part. The
Stored Procedure - Settings window displays.
Last modified date: 06/01/2018