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.