Data Viewer

From Delphi for PHP Documentation Wiki

Jump to: navigation, search

View Image:pathPDF.jpg Data Viewer

Accessed through the menu via View | Data Viewer and by default docked on the bottom zone of the IDE, the Data Viewer features a two tab interface with Data and SQL tabs.

Image:data_viewer.png

Data Tab: The Data tab hows a DBGrid that can be used to browse the dataset currently selected in the Data Explorer. The Data tab includes buttons to navigate the dataset as well as buttons to insert, delete and edit records.

Image:data_viewer_sql.png

SQL Tab: The SQL tab allows the user to execute an SQL query against the database currently selected in Data Explorer.

Below the buttons, there is a SQL query editor which uses the same syntax highlighting settings as the rest of the editors but with SQL syntax.

Use the Execute SQL Query button to execute the query.

Results of the execution of the query are shown on the grid just below.

There is a history buffer for executed queries which stores unique queries and discards repeated queries. There are two buttons to browse through the query buffer.

The caption of the window shows information about the selected connection including the connection name and the database name.

Retrieved from "http://www.qadram.com/vcl4php/docwiki/index.php/Data_Viewer"
Personal tools