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:
- Select Tools Global Options | Database Explorer
- 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:
- Fetch the next couple of rows (as defined by FetchStep).
- Fetch all remaining records,
- Stop the fetch ( records already read remain in the query window).
- 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:
- Develop a complete application with a lightweight Pointbase database.
- For deployment, transfer the table structures to an Oracle database to create
the Oracle database without editing SQL .
Legal Notices