 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » SQL/PSM Statements » REFRESH |
REFRESHRefreshes a result set cursor.
Syntax
Usage
Use this statement to refresh an open result set cursor. Calling the REFRESH statement will cause any row changes made by other sessions to appear. This statement is the only way to refresh an insensitive result set cursor, since such a cursor does not automatically reflect changes made by other sessions. See the Result Set Cursor Sensitivity topic for more information on cursor sensitivity.
This statement will only refresh the cursor itself. You must use the FETCH statement to re-fetch the updated data into whatever variables you have declared to hold the fetched column values.
SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
Syntax
REFRESH <CursorName>
Usage
Use this statement to refresh an open result set cursor. Calling the REFRESH statement will cause any row changes made by other sessions to appear. This statement is the only way to refresh an insensitive result set cursor, since such a cursor does not automatically reflect changes made by other sessions. See the Result Set Cursor Sensitivity topic for more information on cursor sensitivity.
This statement will only refresh the cursor itself. You must use the FETCH statement to re-fetch the updated data into whatever variables you have declared to hold the fetched column values.SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
| Deviation | Details |
| Extension | This SQL statement is an ElevateDB extension. |
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
