Data Explorer
Go Up to View Menu
View > Data Explorer
Adds new connections; modifies, deletes, or renames your connections. The Data Explorer is a tabbed pane that is located, along with the Project Manager and the Model View tabs, in the upper-right corner of the IDE window.
Contents
The Data Explorer works for databases that use FireDAC connection types.
The Data Explorer lets you browse database server-specific schema objects, including tables, fields, stored procedure definitions, stored functions, triggers, and indexes. FireDAC databases also display primary keys, foreign keys and generators.
The Data Explorer presents a list of available database types (such as MYSQL) that you can access and perform various actions on, using the context menus. With Data Explorer, you can easily create and manage database connections. Additionally, you can drag and drop data from a data source to a project to build your database application quickly.
The commands available in the Data Explorer depend upon the object selected in the tree view. To display the associated context menu commands, right-click the following node types:
- Provider types (ODBC, ASA, ASE, and so on)
- Provider connections
- Tables node
- Individual tables
- Individual views
- Individual stored procedures
- Individual stored functions
- Synonyms
- Tip: If you are using a 64-bit Windows operating system then and you use the control panel to create the datasource while on this 64-bit machine, then you will define a 64-bit datasource. Since the Appmethod IDE is a 32-bit application, it obviously needs a 32-bit datasource. So, on a 64-bit machine this datasource needs to be created by running the 32-bit ODBC Data Source Administrator, located at c:\Windows\SysWOW64\odbcad32.exe.
Provider Types Commands
The following commands are available when you select nodes for provider types, such as DB2, and Interbase:
Item | Description |
---|---|
Add New Connection |
Adds a new connection to the Data Explorer. |
Individual Provider Commands
The following commands are available when you select nodes for individual provider connections:
Item | Description |
---|---|
Refresh |
Re-initializes all connections defined for the selected provider. |
Delete Connection |
Deletes the current connection. |
Modify Connection |
Makes changes to the appropriate values in the editor. |
Close Connection |
Closes the current connection. |
Rename Connection |
Provides a new name to a named connection. |
Tables Node Commands
The following commands are available when you select the Tables node for a connection:
Item | Description |
---|---|
Refresh |
Re-initializes all connections defined for the selected provider. |
Individual Table Commands
The following commands are available when you select individual tables:
Item | Description |
---|---|
Refresh |
Re-initializes all connections defined for the selected provider. |
View |
Opens a tabbed Data Explorer page for viewing and editing stored procedure parameter data in the Code Editor. The stored procedure can also be executed from this page. |
View Commands
The following commands are available when you select individual views:
Item | Description |
---|---|
Refresh |
Re-initializes all connections defined for the selected provider. |
View |
Opens a tabbed Data Explorer page in the Code Editor, displaying the data from the selected view. The Data Explorer page lets you sort and modify the data, but changes will not be saved back to the database. |
Stored Procedure Commands
The following commands are available when you select individual stored procedures:
Item | Description |
---|---|
Refresh |
Re-initializes all connections defined for the selected provider. |
View |
Opens a tabbed Data Explorer page for viewing and editing stored procedure parameter data in the Code Editor. The stored procedure can also be executed from this page. |