Browsing a Database in the Data Explorer

From RAD Studio
Jump to: navigation, search

Go Up to How To Perform Database Procedures

After you have a live connection, you can use the Data Explorer to browse database objects.

To browse database objects

  1. Choose View > Data Explorer.
  2. Expand a provider node to expose the list of available connections.
  3. Expand a connection node to view the list of database objects.

    Note: If you receive an error because your connection is not live, you should refresh your provider, and/or modify your connection.

To retrieve data from the database

  1. Expand a connection in the Data Explorer.
  2. Double-click a table name or view name to retrieve data. This operation returns a result set into a tabbed Data Explorer page in the Code Editor.

    Tip: You can also select a table in the Data Explorer and right-click to display a pop-up menu with a Retrieve Data From Table command.

To run a stored procedure

  1. Choose View > Data Explorer.
  2. Expand a connection in the Data Explorer and locate a stored procedure.
  3. Double-click the stored procedure to view its parameters. The parameters open in a separate page on the design surface.
  4. Edit input parameters as necessary.
  5. Click the Execute button in the top left corner of the page to execute the procedure. The result set appears in a datagrid.

    Tip: You can also select a procedure in the Data Explorer and right-click to display a pop-up menu with an Execute command.

See Also