結果ビュー

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  DatabaseSpy 設定 > SQL エディター オプション >

結果ビュー

オプションダイアログの結果ビューセクションにより lets you configure aspects of the appearance of the 結果ウィンドウ in the SQL エディター.

dlg_options-SQL-result

 

Colors

You can have rows in Result tabs displayed as simple grid or with alternating white and colored rows. The color can be changed using the color chooser below the チェックボックス.

 

Display Options

デフォルトでは、 horizontal and vertical grid lines as well as line numbers and the Result ツールバー are displayed. You can switch any of these options off by deactivating the 個々の チェックボックス.

 

DatabaseSpy allows you to sort data contained in the result grid either ascending or descending by repeatedly clicking the column headers. To enable this option, activate the Show sorting arrows チェックボックス.

 

Data Editing

When the default setting is applied, DatabaseSpy uses transactions to save changes in the result grid and rolls back these changes if a failure occurs during committing the changes to the database. Any editing is then written into a transaction which is executed as a whole. If the Rollback transactions on failure チェックボックス is activated, all changes contained are undone upon failure of a single update statement in the transaction.

 

メモ:Transactions are not supported by MS Access databases.

 

If デフォルトの値 are defined for the individual database fields, DatabaseSpy can automatically insert these values when creating a new line in the result grid. Deactivate the Initialize cells with デフォルトの値 チェックボックス if you want to create empty lines.

 

When data editing is not possible to the full extent, DatabaseSpy shows a warning message before the data is displayed in the 結果ウィンドウ. You can suppress this hint by deactivating the Show hint when data editing is limited チェックボックス.


(C) 2019 Altova GmbH