SAP Knowledge Base Article - Preview

3077163 - When two or more "INSERT" are executed, the previous "Results" tab remains - SAP ASE

Symptom

DBISQL does not clear the results of the previous query.

  1. When you execute a query (SELECT) with a result set, the result data is output to the "Results" tab.
  2. When two or more queries without a result set are executed at the same time, the previous "Results" tab is displayed.

There is no way to clear this previous "Results" tab.
This problem can be reproduced by displaying the result in text and scrollable table.

ex: Contains the result of the last SELECT executed

insert test1 values(1)
insert test1 values(2)

"Results" tab
----------------------
1 row(s) inserted
1 row(s) inserted

-------------
123
(1 rows)

Execution time: 0.036 seconds


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Interactive SQL (DBISQL) 11.0.1
  • Interactive SQL (DBISQL) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

DBISQL, interactive sql, ase, 15.7, 16.0, insert, select into, update, delete, select, results, text , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.