Standard inquire_sql Method
For ease of comparison between the iiseterr() method described in this chapter and the inquire_sql method, inquire_sql is described here. The syntax for inquire_sql is:
inquire_sql (error = errorno,
rows = rowcount,
text = errortext) ;
inquire_sql tells your 4GL program whether an error occurred during the last query or forms statement, the number of database rows affected by the statement, and the text of the error if it occurred in a query.
However, inquire_sql cannot prevent the display of error messages on the user's screen. By the time inquire_sql detects an error, the FRS has already displayed the error message.
Last modified date: 08/28/2024