Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Microsoft SQL Server CLOSE – PB Docs 2019 – PowerBuilder Library

Microsoft SQL Server CLOSE – PB Docs 2019

Microsoft
SQL Server CLOSE

If a database stored procedure returns a result set, it must be
closed when processing is complete.

Closing a procedure looks the same as closing a cursor:

As with cursors, if a procedure executes successfully and returns at
least one result set and is not closed, a result set is pending and no SQL
commands other than the FETCH can be executed. Procedures with result sets
should be closed as soon as possible.

You do not have to retrieve all the rows in a result set to close a
request or procedure.


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