Stonefield Query normally sends a SQL statement to retrieve records from a database. If you wish to call a stored procedure to retrieve records for a particular table, you must create a virtual table that contains the fields returned by the stored procedure and a virtual table plugin with a Select method that calls the stored procedure when a report containing fields from the virtual table is run. See the Virtual Table plugin for more information and the Select method for an example.

© Stonefield Software Inc., 2019 • Updated: 02/19/16
Comment or report problem with topic