RAD Studio
ContentsIndex
PreviousUpNext
Browsing a Database in the Data Explorer

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

To browse database objects

  1. Choose ViewData 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 (tables, views, and procedures).
    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 ViewData 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.

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!