When dbsqlexec or dbsqlok returns SUCCEED, it indicates that Microsoft® SQL Server™ 2000 has successfully executed a command batch. At that point, the application must process any results. The SELECT statement and EXECUTE statements that contain SELECT statements both return result rows. INSERT statements and most other Transact-SQL statements also return data needed by DB-Library.
The following list describes the two types of result rows:
- Regular rows are generated from columns in a SELECT statement's select list.
- Compute rows are generated from columns in a SELECT statement's COMPUTE clause.
Because these two types of rows contain different data, the application must process them separately.
The result for each statement in a batch is returned to the application separately. Within each statement's set of results, the result rows are processed one at a time.
The results for each statement in the batch must be set up separately with dbresults.