Microsoft SQL Server Using database stored procedures in DataWindow objects

You can use database stored procedures as a data source for DataWindow objects. The following rules apply:

  • Result set definition

    You must define what the result set looks like. The DataWindow object cannot determine this information from the stored procedure definition in the database.

  • DataWindow updates

    You cannot perform DataWindow updates through stored procedures (that is, you cannot update the database with changes made in the DataWindow object); only retrieval is allowed. (However, the DataWindow can have update characteristics set manually through the DataWindow painter.)

  • Result set processing

    You can specify only one result set to be processed when you define the stored procedure result set in the DataWindow painter.

  • Computed rows

    Computed rows cannot be processed in a DataWindow.