7. OpenSQL Features : Status Information : The Inquire_sql Statement—Retrieve Runtime Information
 
Share this page                  
The Inquire_sql Statement—Retrieve Runtime Information
The INQUIRE_SQL statement returns information about the results of the last OpenSQL database statement issued by a session. Using INQUIRE_SQL you can obtain a variety of information, including:
Error number and text (if the last statement resulted in an error)
Type of error being returned (described in detail in Local and Generic Errors (see page Local and Generic Errors))
Whether a transaction is open
Session identifier (in multiple‑session applications)
Note:  The INQUIRE_SQL statement does not return status information about forms statements. Use the INQUIRE_FRS statement, described in the Forms-based Application Development Tools User Guide, to obtain information about forms statements.