Microsoft SQL Server Using database stored procedures in DataWindow objects – PB Docs 126

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.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x