Hints and Tips for Use with the Database Explorer

This section provides general tips and hints for use with the Database Explorer.

Limiting the numbers of database rows

You can prevent the IDE from trying to load thousands of rows accidentally. To do so:

  1. Select Tools Global Options | Database Explorer
  2. Set Fetch limit to enable a number of rows to be fetched without user confirmation (the default is 100.) When the number of rows returned by the query exceeds this number, Forte for Java warns you and ask s what to do:
    1. Fetch the next couple of rows (as defined by FetchStep).
    2. Fetch all remaining records,
    3. Stop the fetch ( records already read remain in the query window).
  3. Set FetchStep to specify the number of rows fetched after fetch limit.

Recreating tables in a different database

You can recreate tables in a different database from the one from which you saved the structure, even if the SQL syntax to create the second database is different from the syntax of the first. You can thus create database-independent schemas with the Database Explorer. To do so, you can, for example:

  1. Develop a complete application with a lightweight Pointbase database.
  2. For deployment, transfer the table structures to an Oracle database to create the Oracle database without editing SQL .

 


Legal Notices