Copyright: Copyright (c) Corel Corporation.  1998-1999.  All rights reserved.
Citation: Copyright (c) Corel Corporation. 1998-1999. All rights reserved.


Alias Manager dialog box

Use the Alias Manager dialog box to create or modify aliases for local or network directories.

Creating aliases lets you give logical names to directories and is strongly encouraged, since it frees you from typing long path names and makes your files more portable.

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use the Borland Database Engine (BDE). Disable this check box to make an alias a project alias [image] available only to applications in the current working directory.

Database Alias

Choose an alias from the list. To create a new alias, click the New button, then type the name (alias) you want to give the database.

Driver Type

Choose the desired driver. The Driver Type list shows all the drivers to which you are connected. If you want to create a database of Paradox and/or dBASE tables choose STANDARD.

Path

Type the full path of the directory location, including the drive letter.

Show options

•	Show Public Aliases Only:  enable to see only public aliases

•	Show Project Aliases Only:  enable to see only project aliases

•	Show All Aliases:  enable to see both public and project aliases

Browse

Click the Browse button to look for a directory using the Directory Browser.

New

Click the New button to open an empty box where you can type in a new alias. After you click the New button, the button becomes the Keep New button.

Keep New

Click the Keep New button if you want to save this alias without closing the dialog box. This allows you to create multiple aliases without having to close the dialog box to save each one.

The Keep New button saves the alias until you are finished. When you click the OK button, aliases saved with the Keep New button are saved permanently. If you click the Cancel button, any aliases you have saved using the Keep New button will not be kept.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box without specifying the removed name again or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want this alias to be permanent [image] usable any time you use this application. You see the Save File As dialog box. By default, this application stores saved public aliases in IDAPI32.CFG and project aliases in PDOXWORK.CFG. You are prompted to overwrite the existing .CFG file.

When you overwrite, this application appends the new alias without changing any existing configuration settings. You can undo the change by deleting the alias (using the Alias Manager dialog box).

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current session. All Windows applications currently running are affected by any changes.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with Save As remain.


Browse dialog box

Use the Browse dialog box to find a file to insert into an OLE field or object.

Look In

By default, this application displays the working directory. To choose another directory, use this drop-down list to browse until you reach the directory you want. All files of the selected type in that directory appear in the list below the Look In drop-down list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file to insert or select one from the list box below the Look In list. You don't need to type an extension; this application recognizes the type of file you want based on the type shown in the Files Of Type drop-down list.

Files Of Type

Displays the types of files you can use.

Insert

Places the selected file into the current OLE field as an OLE object.


Change Font dialog box

Use this dialog box to specify the default system font.

Font

Specify the font you want to use by default by typing it in the box or selecting one from the list box.

Sample

This field displays a sample of the specified font.

 Note

•	You must exit and restart this application for the system font change to take effect.


Change Icon dialog box

Use the Change Icon dialog box to change the icon (and its label) displayed for an iconized OLE object.

Icon

•	Current:  click to keep the current icon

•	Default:  click this to use the default icon for the selected file

•	From File:  click to use an icon from an executable file or Dynamic Link Library (DLL) file. Type the name of the file in the adjacent box, or click the Browse button to browse through the directory tree to find one.

Label

Type the label you want to appear below the icon.

Browse

Click this button to browse through the directory tree to find a file.


Change Source dialog box

Use the Change Source dialog box to change the source of a linked object in an OLE container.

Look In

By default, this application lists files in the working directory. To choose another directory, use this drop-down list to browse until you reach the directory. All files of the appropriate type in that directory appear in the list below the Look In drop-down list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the new source file or select one from the list box below the Look In drop-down list.

Files Of Type

Displays the type of file you are linking to.

Item Name

Displays the name of the specific item you want to link to in the OLE file displayed in the Filename box.


Copy To File dialog box

Use the Copy To File dialog box to copy values from any field that contains text, numbers, or dates. You cannot copy binary, OLE, or autoincrement data.

Save In

By default, this application displays the working directory. To choose another directory, use this drop-down list to browse until you reach the directory where you want to save the file. All files of the selected type in that directory appear in the file list below the Save In drop-down list.

If the directory you want has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Save In drop-down list and its files appear in the file list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file to save or select one from the list box below the Save In list. You don't need to type an extension; this application recognizes the type of file you want based on the type shown in the Save As Type drop-down list.

Save As Type

Displays the types of files you can save.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Save In drop-down list and the files in that directory appear in the file list.

Character set

Enable the ANSI button or the OEM button to choose the character set for the file.


Copy To Graphic File dialog box

Use the Copy to Graphic File dialog box to copy values in graphic fields to external files.

Save In

By default, this application displays the working directory. You can browse for another directory using this drop-down list. All files of the selected type in that directory appear in the graphics list below the Save In drop-down list.

If the directory you want has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Save In drop-down list and its files appear in the graphics list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file to save or select one from the list box below the Save In list.

Save As Type

Displays the types of files you can save.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Save In drop-down list and the graphic files in that directory appear in the graphics list.


Enter Password(s) dialog box

Use the Enter Password(s) dialog box to supply a password when this application requests it.

The Enter Password(s) dialog box appears when you attempt to open a form or report based on a table that has been password-protected. You must enter the password to open the object.

The password you enter is added to this application's password list. The password list contains all passwords that have been entered in the current session. Once you enter a specific password, you can gain access to any table that recognizes that password until you exit this application.

Password

Type the password in the Password box. Asterisks (*) represent the characters you type.

Add

Adds the password you typed in Password to this application's memory. When you click the Add button, the dialog box remains open so you can enter additional passwords for forms and reports that you intend to open later in the session. Click the Add button again to add another password.

Remove

Deletes the password from this application's memory. By default, if you have closed a password-protected form or report, you can open it again before exiting this application without supplying the password again. Clicking the Remove button, however, requires you to give the password the next time you open the form or report.

Use the Remove button when you want to open another form or report but have exceeded the maximum number of passwords per session (if this occurs, you will be notified with an error message).

Remove All

Removes all passwords from this application's memory. This means any form or report you have opened using a password will again be protected.

 Note

•	This application releases all passwords when you exit the program. You can use the Enter Password(s) dialog box to release a password without exiting this application.


Field Filter dialog box

Use the Field Filter dialog box when you want to see and edit only those records that meet certain conditions.

Filter For <field name>

Type the conditions for the records you want to see.


File Browser

Use the File Browser to select files in other directories.

Directories and Drive (Or Alias)

Select a drive or alias from the Drive (Or Alias) drop-down list, then select a directory from the Directories list box. The list box to the right of these fields displays the files in the directory you select.


Document has changed. Save it?

You tried to close the active file before saving changes. Click the Yes button to save the file. Click the No button to close the file without saving your changes. Click the Cancel button to continue working with the file.


Newly created document. Save it?

You tried to close the active file before saving it. Click the Yes button to save the file. Click the No button to close the file without saving it. Click the Cancel button to continue working with the file.


Filter Tables dialog box

Use the Filter Tables dialog box to see and edit only those records that meet certain conditions. You can also use this dialog box to specify a secondary index to view records in a certain order.

Table List

This list shows tables in the form's underlying data model.

Order By

Enable this check box to order records according to the selected index. The underlying table's primary index is preceded by an asterisk (*). Double-click an index to change which fields are shown and the arrangement of these fields in the Filters On Fields panel of this dialog box.

dBASE Index File

If the table is a dBASE table, type the name of the dBASE index to use in ordering the records. This will update the list of indexes shown above this box.

Range

Choose to specify a range of values using the Set Range for Index dialog box.

Range is available when the Order By check box is enabled and an index is selected. (For a dBASE table, the index must be a Unique index.)

Filters On Fields

Lists the fields in the underlying table. The following types of fields do not appear:

•	Linking fields

•	BLOB fields

Type the conditions for the records you want to see. For a given record to appear, the conditions specified in each field must all be true for that record.

More sophisticated conditions can be specified using special keywords and symbols.


Find And Replace dialog box

Use the Find And Replace dialog box to search for and replace text (called a string) in a memo field or formatted memo field.

Search For

Type the string to look for.

Replace With

Enter the replacement string (in ordinary searches) or the translation string (in Advanced Pattern Match searches). This function is available only when you are working in Edit Data mode.

Case-sensitive

Enable this button to search for the text exactly as you typed it, including capitalization.

Advanced Pattern Match

Enable this button to use an extended list of wildcards in the search.

Find

Click the Find button to begin the search. This application finds the first matching value, highlights it, and displays the message "Match found" in the status bar. If the value does not exist, this application displays the message "No match found" in the status bar.

Replace

Click the Replace button to change the string to the value you entered in Replace With. This application replaces the value, then moves to the next occurrence of the Search For value.

If you do not want to replace the string, click the Find button again. This application moves on to the next occurrence of the Search For value.

Replace All

Click the Replace All button to replace all occurrences of the Search For value.


Found A Match dialog box

This application displays the Found A Match dialog box when it locates the value you want to replace. Use the dialog box to confirm whether you want to replace the value, replace all occurrences of the value, or skip an occurrence without replacing the value.

Skip This Occurrence

Enable this button if you do not want to replace the value. When you click the OK button, this application moves to the next occurrence of the value.

Change This Occurrence

Enable this button to replace this occurrence of the value. When you click the OK button, this application replaces the value and moves to the next occurrence.

Change All Occurrences

Enable this button and click the OK button to replace this and all other occurrences of the value.


Go To Page dialog box

Use the Go To Page dialog box to move through the pages of a form or report. Type the page number you want to go to or click the Arrow buttons.


Insert Object dialog box

Use this dialog box to insert a linked or embedded object in an OLE field.

Create New

Click to create a new object to insert in the OLE field and choose the type of object you want to insert from the list box.

Create from File

Click to insert a copy of a file in the OLE field and type the filename of the file you want to copy into the OLE field in the text box. Click the Browse button to browse through the directory tree to find a file.

Link

Enable this check box to insert a linked object. A linked object is actually a pointer to data somewhere outside the field. When you insert a linked object in an OLE field, changes you make to the object are actually made to the source of the object.

Disable this check box to insert an embedded object. When you insert an embedded object in an OLE field, the data is actually copied into the field, and no relationship is maintained with the source of the data.

Display As Icon

Enable this check box to display the object as an icon. For example, you are embedding a graphic image and do not want to see the image in the form.

Change Icon

This button is visible only if Display As Icon is enabled. Click this button to change the icon (and its label) displayed in the OLE field.

Result

Explains the result of using the currently selected options.


Links dialog box

Use this dialog box to modify the links in OLE fields.

Links

This list box displays for each link the path and filename of the source, the type of object, and the update property setting.

Source

Displays the path and filename of the source of the selected link.

Type

Displays the type of file to which the object is linked.

Update

Choose how you want the selected links to be updated:

•	Choose Automatic to update the appearance of linked objects automatically.

•	Choose Manual to update the appearance of linked objects only when you choose to do so by choosing Update Now.

Update Now

Click this button to update the contents of the selected links now.

Open Source

Click this button to open the source files of selected links in the server application.

Change Source

Click this button to change the source file of selected links. This application opens the Change Source dialog box.

Break Link

Click this button to break the link. This means the object becomes a static object that can no longer be edited or updated.


Locate And Replace dialog box

Use the Locate And Replace dialog box to move to a particular value in a field and change that value.

Field

Click the field that contains the value you want to locate and replace.

When you click the OK button, this application finds the first occurrence of the value you want to replace and displays the Found A Match dialog box, where you can choose to skip the occurrence, change the occurrence, or change all occurrences.

Value

Type the value you want to change.

Replace With

Type the new value.

Case-sensitive

Enable the Case-sensitive check box to search for the text exactly as you typed it, including capitalization.

Exact Match

Enable the Exact Match button if you do not want to find fields that contain the value as a substring, and do not want to use a pattern.

@ and ..

Enable the @ and .. button if you want to use either or both of these wildcards in your search. @ stands for any character, and .. stands for any number of characters, including none.

Advanced Pattern Match

Enable the Advanced Pattern Match button if you want to use an extended list of wildcards in your search.


Locate Record Number dialog box

Use the Locate Record Number dialog box to enter the record number of the record to which you want to move.

Locate Record Number

Type the number of the record you want to locate.


Locate Value dialog box

Use the Locate Value dialog box to move to a particular value in a field.

Field

Choose the field in which the value is to be found.

Value

Type the value you want to locate.

Case-sensitive

Enable the Case-sensitive check box to search for the text exactly as you typed it, including capitalization.

Exact Match

Enable the Exact Match button if you do not want to find fields that contain the value as a substring, and do not want to use a pattern.

@ and ..

Enable the @ and .. button if you want to use either or both of these wildcards in your search. @ stands for any character, and .. stands for any number of characters, including none.

Advanced Pattern Match

Enable the Advanced Pattern Match button if you want to use an extended list of wildcards in your search.

When you click the OK button, this application moves to the first occurrence of the value. To move to the next occurrence, choose Record, Locate Next or click the Locate Next button on the toolbar.

If no values match, or after all matching values have been found, this application displays the message "[value] was not found" on the desktop status bar.

 Note

•	You can only locate values from this box. If you want to replace values, select Form, Edit Data, then choose Record, Locate, And Replace to open the Locate and Replace dialog box.


Lookup Help dialog box

When you use table lookup for a table with Help And Fill, and then press CTRL + SPACEBAR when resting in the lookup field in Edit mode, this dialog box appears.

Its contents vary according to the way the lookup table and field have been defined. It shows the lookup field you are filling plus related fields, if defined that way.


Move Help dialog box

Use the Move Help dialog box to move a detail record to a new master record.

The entire master table appears in the Move Help dialog box.

Select the new master record from the master table displayed and click the OK button. The selected detail record is now assigned to the new master record.

 Note

•	Move Help is available only in fields for which a one [image] many relationship or a referential integrity relationship has been defined.


Paste From File dialog box

Use the Paste From File dialog box to paste text from an external file into a selected text field or memo field. Text will be inserted at the insertion point. If text is selected, the selected text will be replaced by the inserted text.

Filename

Type in the name and extension of the file you want to copy from or select one from the list box below this box.

Files Of Type

This application displays the word <Text>, indicating you can copy text values from .PXT, .TXT, or .RTF files. The extension shows the format used to copy the text. PXT files use an internal format for rich text and object storage. TXT files are plain text files such as those created by Notepad. RTF files are standard Rich Text Format files that contain font and other information.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Look In drop-down list and the files in that directory appear in the file list.


Paste From Graphic File dialog box

Use the Paste From Graphic File dialog box to paste a value from an external file into a selected graphic field.

Look In

By default, this application displays the working directory. Use the drop-down list to choose another directory. All files of the selected type in that directory appear in the graphics list below the Look In drop-down list.

If the directory you want has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Look In drop-down list and its files appear in the graphics list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file to paste from or select one from the list box below the Look In list. You don't need to type an extension. This application recognizes the type of file you want based on the type shown in the Files Of Type drop-down list.

Files Of Type

Displays the types of files you can paste from: *.BMP, *.PCX, *.TIF, *.GIF, *.EPS.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Look In drop-down list and the files in that directory appear in the graphics list.


BDE page (Preferences dialog box)

Use this dialog box to view settings that control the Borland Database Engine (BDE).

BDE is the interface this application uses to access your data. BDE needs information about your specific environment in order to access and deliver your data properly. This information is stored in the BDE configuration file.

To change any of these settings, use the BDE Administrator. Changes do not take effect until you restart this application.

Network Control File Directory

Shows the location of your network control file, PDOXUSRS.NET.

Language Driver

•	System:  this driver can be used as a default if the Paradox and dBASE language drivers are undefined

•	Paradox:  this driver determines the sort order, capitalization, and string comparison conventions that are specific to your country's language for Paradox tables. The default for users in the United States is the Paradox ASCII driver.

•	DBASE:  this driver determines the sort order, capitalization, and string comparison conventions that are specific to your country's language for dBASE tables

Database Driver List

Shows what database drivers you have installed. You can create a table of the type of any database driver to which you are connected.

For information on ODBC drivers, look up ODBC in the BDE Administrator Help File index.

Buffer Size (in Kilobytes)

This buffer specifies the minimum and maximum amount of memory this application uses.

Local Share

When Local Share is On, you can safely share tables with non-BDE applications that you are running locally. (Note: Non-BDE applications include earlier versions of Paradox, dBASE IV, and Quattro Pro version 6 or earlier.)

When Local Share is Off, the data locks set by Local Share are turned off. If you are sharing data with non-BDE applications, this leaves you unprotected from data corruption. This option might provide a slight performance increase in accessing local data. Local Share is off by default.


Database page (Preferences dialog box)

Use this dialog box to specify general database and multi-user preferences.

Private Directory

Specify a directory to use as your private directory. The directory you specify is where this application stores any temporary tables you create. This avoids conflicts with any other network user's temporary tables.

Browse

Opens the Directory Browser so you can choose your private directory visually.

Network

These settings affect how this application works on a network and provide information about other users in a multi-user environment.

•	User Name:  shows the network user name you used to log on to a network. If you are not attached to a network, the box displays the message No user name available.

•	Current User List:  shows a list of all users who are using the same application network installation you are. This is especially useful when you want to place a lock on an object and want to find out who might be inconvenienced.


Designer page (Settings dialog box)

The Designer preferences affect the behavior and display of the Form window.

Flicker-Free Draw

Sometimes the screen flashes a bit. This is especially noticeable when a form has a dark background. Enable the Flicker-Free Draw button to suppress this behavior.

Ruler

The Form window has rulers you can use with the expanded ruler for editing and formatting text fields and formatted memo fields.

Enable or disable a ruler to display or hide it.

•	Horizontal Ruler:  enable to display a ruler along the top of the document. This ruler must be checked to set tabs using the expanded ruler.

•	Expanded Ruler:  enable to display the expanded ruler, an editing tool for use with text fields and formatted memo fields. It is displayed above the horizontal ruler. Use it to adjust margins, tabs, line spacing, and text alignment.

 Note

To set tabs, the horizontal ruler must be used with the expanded ruler. Alignment and line spacing controls work with or without the horizontal ruler.


General page (Preferences dialog box)

Use this dialog box to specify a default system font.

Default System Font

This field displays the default system font. To change the default system font, click the Change button. This application opens the Change Font dialog box.

Disable hyperlinks

Enable this check box to disable hyperlink fields.


Print File dialog box (forms)
Print File dialog box

Use the Print File dialog box to specify printing options for forms.

Print

Choose All or type in a page range. (If you have only one page, ignore this.)

To print pages in reverse order, type the higher number in the From box and the lower number in the To box.

Choose the number to print on the first page (the number from which you want to start printing). Form pages won't be numbered unless you put the special Page Number, and/or Number of Pages fields on each page.

Copies

Type the number of copies you want.

Collate

Make sure Collate is enabled if you want multiple copies collated into sets. (If your printer prints multiple copies separately, you do not need to check this check box.)


Print File dialog box (reports)
Print File dialog box

Use the Print File dialog box to set options for printing an entire report or certain pages.

After you set all options, click OK. While sending the job to the printer, this application displays a dialog box with a Cancel button. Click Cancel at any time to stop sending the report to the printer. Choosing Cancel does not cancel pages this application has already sent to the printer.

Print

Choose All or type a page range.

To print pages in reverse order, type the higher number in the From box and the lower number in the To box.

To make the report page numbers begin with a number other than 1, type that number in the Number on First Page field.

Copies

Type the number of copies you want.

Collate

Make sure Collate is enabled if you want multiple copies collated into sets. (If your printer prints multiple copies separately, you do not need to check this check box.)

Overflow Handling

Specify how to treat data that is too wide to fit on the printed page.

•	Clip To Page Width:  clips (trims) all data that does not fit across the page (within the margins)

•	Create Horizontal Overflow Page:  prints additional pages when necessary to fit all the data. Each of these pages immediately follows the page it extends.

•	Panel Vertically:  if any page of the report needs an overflow page, a second page for each page of the report prints, regardless of how many pages have overflow data


Printer Setup dialog box

In the Printer Setup dialog box, choose the printer you want from the list, or choose Modify Printer Setup to open the Windows Printer Properties dialog box for the currently selected printer. The Printer Properties dialog box allows you to configure the currently selected printer.

Then you can choose a different printer or configure an existing printer differently. Click the Help button to get detailed information on the Windows Printer Setup dialog box, or see your Windows documentation.


Select Alias dialog box

Use the Select Alias dialog box to choose an alias for the remote database to connect to. This application displays the aliases you created in the Alias Manager dialog box. Select an alias from the drop-down list and click the OK button.


Select File dialog box

Use the Select File dialog box to specify a file.

Look In

By default, this application displays the working directory. To choose another directory, use this drop-down list to browse until you reach the directory. All files of the selected type in that directory appear in the list below the Look In drop-down list.

If the directory has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Look In list box and its files appear in the file list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file or select one from the list box below the Look In list.

Files Of Type

Displays the types of files you can use for the operation you are performing.

Alias

If the directory has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Look In drop-down list and the files in that directory appear in the file list.


Select File (Open Document) dialog box
Open File dialog box

Use this Open File dialog box to specify the file you want to open.

Look In

By default, this application displays the working directory. To choose another directory, use this drop-down list to browse until you reach the directory you want. All files of the selected type in that directory appear in the list below the Look In drop-down list.

If the directory you want has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Look In list box and its files appear in the file list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file or select one from the list box below the Look In list. You don't need to type an extension; this application recognizes the type of file you want based on the type shown in the Files Of Type drop-down list.

Files Of Type

Displays the types of files you can use for the operation you are performing.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Look In drop-down list and the files in that directory appear in the file list.

Options

The available options differ according to the object you are opening.

•	Form

•	None

•	Report

•	View the Report opens the report in its view window

•	Print the Report prints the report

•	Script

•	None

Change Table

Opens a form or report using a different master table [image] a different table from the one on which it was originally designed. When you click the Change Table button, this application opens the Select File dialog box, where you specify the new master table.


Set Range For Index dialog box

Use the Set Range for Index dialog box to specify a range of records to see in a form. (Note: The primary and more powerful way to filter a form is to use the filter capabilities available directly from the Filter Tables dialog box.)

Index

Displays the table index selected from the Filter Tables dialog box.

Field Values

To display only those records whose value matches exactly the value you specify, type the value in the box in the Field Values area. For example, if you have an index on the Country field of an underlying Customer table, and you type Canada as the value to match, this application displays only those records with Canada as the Country value.

Set Range

When Set Range is enabled, another box opens so you can define the range of values to display. Type the low value in the first box and the high value in the second box. This application does not recognize blanks as part of a match or range specification.

Match Partial Strings

You can match partial values of range matches on alpha fields.

If you care only about matching the beginning letters of a string, use Match Partial Strings (for, example, if you want all names beginning with letters A to G). Match Partial Strings is hidden until you enable Set Range, and is available only if the table's index field is alpha.

To match partial strings, enable Set Range and enter low and high values. Then enable Match Partial Strings to tell this application you do not care what the full field value is, as long as it falls within that range. This application looks for the strings you enter in the range value text boxes and ignores any following characters in the string.

For example, if you type AX in the first box and CZ in the second box, this application looks for all strings whose first two letters are AX to CZ. Axminster is included, but Allen is not. Likewise, Bloom and Czech are included but Dailey is not.


Set Working Directory dialog box

Use the Set Working Directory dialog box to change your working directory.

Aliases

If your new working directory has an alias you can select it from the list.

Directory

Type the full path of your new working directory in the Working Directory text box, or click a folder from the directory tree.


Navigation icons

Moves up a level from the selected area.

Ceates a new folder in the current directory. To name the new folder, type over the default name.

Shows only folder names.

Shows folder names plus details.


Toolbars page (Preferences or Toolbar Preferences dialog box)
Toolbars dialog box

Use this dialog box to display other Toolbars instead of, or in addition to, the standard Toolbar for each Paradox window.

Certain Toolbars are only available in certain windows.

Toolbar	Displays

Standard	The Standard toolbar for each window.

Property	Tools for navigating around your database.

 Status Bar	Information about such things as objects, ongoing operations, and mouse position.

New

The new button allows you to add a new toolbar to the list.

Reset

The reset button makes changes to the highlighted toolbar standard.

Customize

You can customize the toolbars to suit your needs.

Options

The option button allows you to specify the size and appearance of the toolbars.

Checkbox

Enable the checkbox to show the titles on floating toolbars.


Save Configuration File dialog box

Use the Save Configuration File dialog box to save the settings you specify.

Save In

By default, this application displays the working directory. You can browse for another directory using this drop-down list. All files of the selected type in that directory appear in the graphics list below the Save In drop-down list.

If the directory you want has an alias, choose it in the Alias drop-down list. The name of the directory appears in the Save In drop-down list and its files appear in the graphics list.

Click any of the icons to navigate, create a folder, or change the display of folders.

Filename

Type the name of the file to save or select one from the list box below the Save In list.

Save As Type

Displays the types of files you can save.

Alias

If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Save In drop-down list and the graphic files in that directory appear in the graphics list.


Directories and aliases


Overview: Directories and aliases
Directories and aliases

You can manage files using the working directory,  private directory, and aliases.

Directories

Paradox Runtime offers two types of directories for file storage:

•	Working directory [image] the directory Paradox Runtime uses by default to open and save files

•	Private directory [image] the directory used to store temporary objects created by Paradox Runtime when performing certain actions.

Aliases

An alias is a name you can assign as a shortcut to a directory. By default, your working directory has the alias :WORK:, and your private directory has the alias :PRIV:.

There are two kinds of aliases:

•	public aliases

•	project aliases

 Note

•	When you change any of these directory or alias settings, Paradox Runtime automatically saves the changes.

 More Detailed Information


Directories


Overview: Directories
Directories

Paradox Runtime offers two types of directories to manage your files.

Working directory

A working directory is the directory Paradox Runtime uses by default to open and save files. The working directory controls which files are displayed in dialog boxes during open and save operations.

When you install Paradox Runtime on a local drive (not a network drive), a directory named WORKING is created below the system directory. This is your default working directory. You can change the working directory at any time. For more information, see Changing your working directory.

You'll probably find it convenient to use working directories to organize your files. Then, when you want to use the files in a specific directory, you change your working directory accordingly. For example, if you're working with forms and reports in a directory named C:\DATAFILES\BUDGET, you would change your working directory to C:\DATAFILES\BUDGET.

Private directory

In a multi-user environment, you need a place to put your temporary objects. Paradox Runtime creates temporary objects when performing certain actions. Temporary objects must be stored in a non-shared directory to prevent other users from overwriting them. Each user should have a separate private directory when using Paradox Runtime.

Your default private directory is PRIVATE, created below the main application directory on your hard drive or on your network home directory if you have no hard drive. You can change to another private directory if you want. For more information, see Specifying a private directory.

 Related Topics


Changing your working directory

Your working directory is the default data directory Paradox Runtime uses to open and save files.

To change your working directory

1.	Click File, Working Directory.

2.	Type the location (full path) of the directory you want in the Directory box, or locate the file in the directory tree.

 Notes

•	Your working directory is assigned the temporary alias :WORK: even if it already has another alias name. If you create a project alias, Paradox Runtime creates a file called PDOXWORK.CFG and stores it in your working directory. This file contains all project aliases. Public aliases are stored in IDAPI32.CFG.

•	You can also change your working directory from the Project Viewer. For more information, see Changing your working directory from the Project Viewer .

 Related Topics


Specifying a private directory

If you do not specify a private directory, Paradox Runtime uses the PRIVATE directory, which is installed below your system directory when you install Paradox Runtime on a local (non-network) drive. If you have no local hard disk, the network home directory on the file server should be used as the private directory.

To specify your private directory

1.	Click Tools, Settings, Preferences.

2.	On the Database page, specify a private directory in the Private Directory text box. You can type it in or click the Browse button to use the Directory Browser.

The :PRIV: alias is assigned to your private directory.

 Note

•	When you change private directories, Paradox Runtime releases the locks you have placed on tables and deletes all your temporary tables. Make sure you do not need any of your temporary tables before you change private directories.

 Related Topics


Aliases


Overview: Aliases
Aliases

An alias is a name you can assign as a shortcut to a specific directory.

At any time, you can use the Alias Manager dialog box to perform the following tasks:

•	Creating a new alias

•	Modifying and removing an alias

Example

Suppose you have a collection of text files, forms, reports, and graphics all in one directory. This collection of files is located in a directory called C:\DATAFILES\PROJECTS\NEW\PLANNER. Using the Alias Manager dialog box, you can give that full path a name [image] an alias. For example, if you create an alias named :PLAN: for this directory, you can use :PLAN: instead of the full directory path when you need files from C:\DATAFILES\PROJECTS\NEW\PLANNER.

Advantages

Aliases give you several advantages:

•	You can avoid typing long path names.

•	You can have file references within forms, reports, and similar application objects use alias names rather than full paths.

•	You can connect to or disconnect from your remote database server.

•	You can change the definition of an alias at any time. All forms, reports, or other application objects that refer to the alias automatically refer to the new definition of the alias.

Kinds of aliases

There are two kinds of aliases: public aliases and project aliases. For more information, see Public and project aliases.

 Related Topics


Overview: Public and project aliases
Public and project aliases

In Paradox Runtime you can create aliases that are available from all directories or specific to a working directory:

•	Public aliases are stored in the BDE configuration file. They are available from any working directory and visible to any application that uses the Borland Database Engine (BDE).

•	Project aliases are stored in the PDOXWORK.CFG file in the working directory. They are available only when you use Paradox Runtime and are in the working directory in which you created them.

Whenever you change working directories, Paradox Runtime unloads all project aliases associated with the old working directory and loads those project aliases that are specific to the new working directory. Public aliases are available from any working directory.

If a project alias has the same name as a public alias, Paradox Runtime does not load the project alias.

 Related Topics


Creating a new alias

You can use the Alias Manager dialog box to create aliases for local or network directories or for remote databases. For more information specific to Borland SQL Links and for creating an alias for a remote database, see Alias Manager dialog box (SQL Link).

To create a new alias

1.	Click Tools, Alias Manager.

2.	Click the New button.

3.	In the Database Alias text box, type the name (alias) you want to give the directory.

4.	Choose the driver you want from the Driver Type list box.

The Driver Type list box shows all the drivers you are connected to. To create a database of Paradox Runtime and dBASE tables, choose STANDARD.

5.	Enter the full path of the directory location, including the drive letter, in the Path text box (or click the Browse button and browse for the folder).

6.	Enable one of the following radio buttons:

•	Show public aliases only

•	Show project aliases only

•	Show all aliases

Choose Public Alias if you want the alias to be available no matter which directory you are working in.

7.	Click the Keep New button if you want to keep the alias but do not want to close the dialog box.

The Keep New button becomes the New button. You can then create another alias. If you want the alias you just created to be temporary (exist only until you exit Paradox Runtime), click OK and do not proceed to step 7.

8.	To save the alias you have created, click the Save As button.

By default, Paradox Runtime stores saved public aliases in IDAPI32.CFG and project aliases in PDOXWORK.CFG. You are prompted to overwrite the existing .CFG file. This is OK; when you overwrite, Paradox Runtime appends the new alias without changing any existing configuration settings. You can remove the alias from the .CFG file at any time (using the Alias Manager dialog box).

9.	Click OK.

The Alias Manager dialog box closes. If you click OK before saving the alias you have created, Paradox Runtime prompts you to save the alias in the appropriate .CFG file.

Tip

•	To create an alias similar to one you already have, select the appropriate alias from the list box. Click the New button, then make your changes to the alias and click the Keep New button to save the alias.

 Related Topics


Modifying and removing an alias

You can change an alias  using the Alias Manager dialog box.

To modify an alias

1.	Click Tools, Alias Manager to open the Alias Manager dialog box.

2.	Choose an alias from the Database Alias list.

3.	Type the new path in the Path text box.

4.	To save the alias you have created, click the Save As button.

Paradox Runtime opens the Save File As dialog box. You are prompted to overwrite the existing .CFG file. This is OK; when you overwrite, Paradox Runtime appends the new alias without changing any existing configuration settings. You can remove the alias from the .CFG file at any time (using the Alias Manager dialog box).

5.	Click OK.

The Alias Manager dialog box closes. If you click OK before saving the alias you have created, you are prompted to save the alias in the appropriate .CFG file.

To remove an existing alias

1.	Click Tools, Alias Manager to open the Alias Manager dialog box.

2.	Choose the alias you want to remove from the Database Alias list box.

3.	Click the Remove button.

4.	When you click OK, Paradox Runtime prompts you to save the change in the appropriate .CFG file.

 Related Topics


Glossary

A

active

alias

alpha field

ANSI

arithmetic operators

ascending order

ASCII

B

band

BDE

binary field

bind

blank field

BLOB

C

cascade

check box

client

Clipboard

command

contain

container object

D

data

data integrity

data type

database

DDE

default

default action

default value

define

descending order

desktop

dialog box

drop-down list box

E - F

field

field type

field value

Field View

file

filename

font

footer

form

Form window

Formatted memo field

function

function keys

G

Graphic field

group (n.)

H

header

highlight

I-J

icon

index

K

key

L

list box

lock

logical operator

lookup table

M

Main menu

Memo field

method

multi-record

N

number field

O

object

OEM

OLE

OLE container

OLE object

OLE server

operator

P

picture

pop-up definitions

primary index

private directory

prompt

Project Viewer

Q - R

record

record number

referential integrity

report

Report window

S

secondary index

selection condition

separator

server

short field

single-value relationship

special field

SQL

string

T

table

table frame

table header

table language driver

toolbar

U - V

validity check

W

wildcard operators

working directory

X-Y-Z

zoom


Keyboard shortcuts


Overview: Keyboard shortcuts
Keyboard shortcuts

Most application mouse operations have keyboard equivalents. These keyboard commands usually have an abbreviated series of keystrokes called shortcuts.

General keys

•	Menu command keys

•	Application access keys

•	Control menu keys

•	Help system keys

•	Dialog box keys

Shortcuts in forms

•	Navigation and selection keys

•	Form window shortcuts

•	Edit mode keys

•	Memo View keys

•	Function keys in Form windows

•	Super TAB operations

 More Detailed Information


General shortcuts


Overview: General shortcuts
General shortcuts

General shortcuts are keyboard shortcuts that let you quickly access menu items, application commands, and control menu items, Help information, and dialog box commands.

 Related Topics


Menu command keys

Use the following keys to access the menus in this application.

Use...	To...

ALT	Select the Menu bar

ALT + Hyphen	Open the child window Control menu

ALT + SPACEBAR	Open the application Control menu

Arrow keys	Select menu items

ENTER or 	Open the selected menu

ESC	Exit from a menu without choosing a command

To access Menu bar commands

•	Press ALT plus the underlined letter in the menu name. For example, ALT + F opens the File menu.

To choose a command from a menu

•	Do one of the following:

•	Press the underlined letter (access key) in the command name. For example, when the File menu is open, press the letter O to open a file, S to save a file, or X to exit this application and unload it from memory.

•	Use the Arrow keys to select the menu command, and press ENTER.

 Related Topics


Application access keys

You can use keyboard shortcuts to perform application commands.

Use...	To...

ESC	Close a Control menu but leave the Control menu box selected. Press ESC a second time to deselect the Control menu box.

ALT + ESC	Display the next application on the Windows desktop. This will restore a minimized application. The name of the application will not be shown before displaying it.

CTRL + ESC	Access the Start button on the taskbar.

ALT + Hyphen	Open the active window's Control menu.

ALT + SPACEBAR	Open the application Control menu which allows you to Restore, Move, Size, Minimize, Maximize or Close this application. The Restore option is available only if the application window has been minimized. To move the application window, choose Move, use the Arrow keys to reposition the window, and press ENTER when you finish.

ALT + TAB	Display the next application on the Windows desktop. This will restore a minimized application. The icons of all loaded applications are displayed in a box. Hold down ALT and press TAB repeatedly until the icon you want is selected, then release ALT.

 Related Topics


Control menu keys

The Control menu opens when you click the icon at the left end of a window Title Bar.

Use...	To...

ALT + Hyphen	Open the active window's Control menu.

ALT + SPACEBAR	Open the application Control menu which allows you to Restore, Move, Size, Minimize, Maximize or Close this application. The Restore option is available only if the application window has been minimized. To move the application window, choose Move, use the Arrow keys to reposition the window, and press ENTER when you finish.

ALT + F4	Close the window. Windows prompts you for confirmation if your current work is unsaved.

ESC	Close a Control menu but leave the Control menu box selected. Press ESC a second time to deselect the Control menu box.

CTRL + ESC	Access the Start button on the taskbar.

 Related Topics


Help system keys

To access Help, press the F1 key. Depending on the current context,

When...	Press F1 to display help for...

In a menu	The selected command

In a dialog	That dialog

In a child window	That window

Empty desktop	Runtime Help Table of Contents

When a Help topic is displayed, you may use the keys listed below to navigate within a Help topic, between topics, and within the Help system.

Use...	To...

ESC	Close the current Help window.

TAB	Move to the next underlined Help topic. For a jump, press ENTER. For a glossary definition, press ENTER once to see the definition; press ENTER again to make it go away.

SHIFT + TAB	Move to the previous underlined Help topic. For a jump, press ENTER. For a glossary definition, press ENTER once to see the definition; press ENTER again to make it go away.

Scroll down one line (if a vertical scroll bar is displayed).

Scroll up one line (if a vertical scroll bar is displayed).

PAGE UP, PAGE DOWN	Scroll the Help window (if vertical scroll bars are displayed).

ALT + C	Display the Help Contents for the current Help topic.

ALT + B	Return to the last Help screen you viewed.

ALT + I	Search for a particular term in the Help index.

 Related Topics


Dialog box keys

You can move in a dialog box and perform dialog box commands using keyboard shortcuts.

Use...	To...

ESC	Cancel a dialog box, leaving the settings unchanged. Same as the Cancel button.

SPACEBAR	Select. (Same as left-click.) Depending on the context, pressing the SPACEBAR can do the following: toggle a selected check box; set a selected option button; select an item in a list box or drop down list box; or activate a push button

CTRL + SPACEBAR	Select non-contiguous items in a multi-select list box. (Same as CTRL + click.)

SHIFT + SPACEBAR	Select a contiguous group of items in a multi-select list box. (Same as SHIFT + click.)

ENTER	Activate a selected command button.

TAB	Move to the next named option or group of options. Or press ALT plus an underlined letter in the option name to choose that option directly.

SHIFT + TAB	Move to the previous named option or group of options.

 and

Depending on the context, the Up and Down arrows can do the following: select a radio button; highlight a selection list item (you can also press the first letter of the item name to select the first item in the list beginning with that letter); or  move to another check box inside a group of check boxes

ALT	Drop a list down for the selected list box.

F1	Display context-sensitive Help on the dialog box.

ALT + F4	Close the dialog box.

F3	Super Back TAB. In multi-region dialog boxes, Super Back TAB moves backward from panels with tables in them to other panels. (TAB and SHIFT + TAB move among objects or fields within the region.)

F4	Super TAB. In multi-region dialog boxes, Super TAB moves forward from panels with tables in them to other panels. (TAB and SHIFT + TAB move among objects or fields within the region.)

 Note

•	If there is no Cancel button, ESC will not close the dialog. Use the Close or OK buttons as appropriate instead.

 Related Topics


Shortcuts in forms


Overview: Shortcuts in forms
Shortcuts in forms

You can use keyboard shortcuts to move through forms and to select and edit data. Paradox Runtime also provides keyboard shortcuts for moving around a memo in Memo View.

 Related Topics


Navigation and selection keys

This table shows the keys with which you can navigate when you are looking at data in forms. Make sure NUMLOCK is off when you use ALT in combination with a keypad key. Field view and non-field-view keys are listed.

Key	Non-field view	Field view
PAGE UP	Up one set of records	Up one set of records
CTRL + PAGE UP	Left one screen	Left one screen
PAGE DOWN	Down one set of records	Down one set of records
CTRL + PAGE DOWN	Right one screen	Right one screen
HOME	First field of record	Beginning of field
SHIFT + HOME	Select to first field of record*	Select to beginning of field
CTRL + HOME	First field of first record	First field of first record
ALT + HOME	First field of record	First field of record
END	Last field of record	END of field
ENTER	Next field	Next field
CTRL + END	Last field of last record	Last field of last record
ALT + END	Last field of record	Last field of record
	Left one field	Left one character
CTRL + SHIFT	Select to first field of record	Extend selection left one word
ALT	Left one field	Left one field
	Right one field	Right one character
CTRL + SHIFT	Select to last field of record	Extend selection right one word
ALT	Right one field	Right one field
	Up one field	Up one line in multi-line field or up one record in single-line field
CTRL	Move to same field of first record	Up one line in multi-line field
ALT	Up one field	Up one field
	Down one field	Down one line within multi-line field or down one record in single-line field
CTRL	Move to same field of last record	Down one line in multi-line field
ALT	Down one field	Down one field
TAB	Next field	Insert tab
SHIFT TAB	Previous field	N/A
 Related Topics


Form window shortcuts

Key combination	Action

CTRL + A	Locate next

CTRL + D	Ditto (repeat the value in same field from the previous record)

CTRL + F	Field View

CTRL + INSERT	Copy to the Clipboard

CTRL + L	Lock the current record

CTRL + SHIFT + L	Post changes made to the current record

CTRL + R	Rotate columns (on table frame)

CTRL + T	Memo View

CTRL + Z	Locate Value

CTRL + SHIFT + Z	Locate And Replace

DELETE	Clear or delete (as appropriate)

SHIFT + DELETE	Cut to the Clipboard

SHIFT + INSERT	Paste from the Clipboard

 Note

•	For additional keys, see Function keys in Form windows.

 Related Topics


Edit mode keys

This table shows the keys to use while editing. Entering Field View does not change the action of these keys.

Key	Action

INSERT	Insert record

SHIFT + INSERT	Paste (same as Edit, Paste)

CTRL + INSERT	Copy (same as Edit, Copy)

DELETE	Delete selected text (same as Edit, Delete)

SHIFT + DELETE	Cut (same as Edit, Cut)

CTRL + DELETE	Delete record*

BACKSPACE	Delete character to the left or delete selected text

CTRL + BACKSPACE	Delete word to left

ALT + BACKSPACE	Undo record edit (same as Edit, Undo)

ESC	Undo field edit

TAB	Post value and move to next field

SHIFT + TAB	Post value and move to previous field

ENTER	Post value and move to next field

CTRL + SPACEBAR	Lookup Help (if defined)

CTRL + SHIFT + SPACEBAR	Move Help (if applicable)**

 Notes

•	For dBASE tables only, CTRL + DELETE acts as toggle to delete/undelete a record. For more information, see Record, Delete/Undelete.

•	For more information on Move Help, see Record, Move Help.

 Related Topics


Memo View keys

This table shows the keys to use while editing a memo or formatted memo field.

Key	Action in Memo

TAB	Insert tab character in text

ENTER	Insert carriage return in text

PAGE UP	Up one screen

CTRL + PAGE UP	Position cursor to top left of current screen

PAGE DOWN	Down one screen

CTRL + PAGE DOWN	Position cursor to bottom left of current screen

HOME	Beginning of line

SHIFT + HOME	Select to beginning of line

CTRL + HOME	Beginning of memo field

END	END of line

CTRL + END	END of memo field

SHIFT + END	Select to end of line

Left one character

SHIFT	Select left one character

CTRL	Left one word

Right one character

SHIFT	Select right one character

CTRL	Right one word

Up one line

SHIFT	Select up one line

Down one line

SHIFT	Select down one line

SHIFT + INSERT	Paste from Clipboard

CTRL + INSERT	Copy to Clipboard

DELETE	Delete selected text

SHIFT + DELETE	Cut to Clipboard

BACKSPACE	Delete left character

CTRL + BACKSPACE	Delete left word

ALT + BACKSPACE	Undo record edit

ESC	Undo memo edit

 Related Topics


Function keys in Form windows

You can use the function keys to perform many navigational and operational commands in Paradox Runtime.

Key	Action

F1	Displays Help

F2	Field View

SHIFT + F2	Memo View (& OLE)

CTRL + F2	Persistent Field View

F3	Super Back TAB

CTRL + F3	Refresh data*

SHIFT + F3	Previous Page

F4	Super TAB

SHIFT + F4	Next Page

F5	Lock record

SHIFT + F5	Post record

CTRL + F5	Post/Keep Lock

F6	View current object's right-click menu

F7	Table View

F9	Edit/END Edit

F10 	Menu

SHIFT + F10	View current object's right-click menu

F11	Previous record

CTRL + F11	First record

SHIFT + F11	Previous set

F12	Next record

CTRL + F12	Last record

SHIFT + F12	Next set

 Notes

•	When viewing SQL data, you must press CTRL + F3 to perform a data refresh. Changes made by others do not automatically refresh the screen.

•	For additional keys, see Form window shortcuts.

 Related Topics


Super TAB operations

Use Super TAB (F4) and Super Back TAB (F3) to move among panels in multi-region windows and dialog boxes.

Multi-table forms

In multi-table forms, use Super TAB (F4) to move forward among the table objects. (TAB and SHIFT + TAB move right and left among fields within a table object.) Use Super Back TAB (F3) to move backward.

Other multi-region dialog boxes

In dialog boxes that contain embedded table images, Super TAB and Super Back TAB move you out of the table. (TAB and SHIFT + TAB move right and left among fields within a table.)

Key	Action

F3	Super Back TAB

F4	Super TAB

 Related Topics


active, defined
active

The object or window to which the next keystroke or mouse action will apply.


alias, defined
alias

A name you assign to a database in addition to its original name. When you use an alias, you don't need to specify the directory path.


align left, defined
align left

The text is aligned so that its left edge lines up at the left margin. This is the most typical alignment type.


align right, defined
align right

The text is aligned so that its right edge lines up at the right margin.


align center, defined
align center

The text is aligned so that it is centered between the margins.


align justify, defined
align justify

The text is aligned so that its left and right edges line up at both margins.


alpha field, defined
alpha field

A field containing letters, numbers, or a combination of both.


ANSI, defined
ANSI

American National Standards Institute; the character set supported by Windows.


Answer table, defined
Answer table

A temporary table used to store the results of a query.


arithmetic operators, defined
arithmetic operators

The +, -, *, /, and ( ) operators used to construct arithmetic expressions in queries and calculated fields.


ascending order, defined
ascending order

A sort order: alphabetic order in alpha fields (most often A to Z case-sensitive, but the order depends on the language driver you are using); low to high in numeric fields; earliest to latest in date fields.


ASCII, defined
ASCII

American Standard Code for Information Interchange; a sequence of 128 standard characters.


asymmetrical outer join, defined
asymmetrical outer join

A query in which an inclusive link is specified for only one of the tables involved.


axis, defined
axis

The horizontal or vertical line that defines the range of values plotted on a chart. The x-axis is the horizontal line; the y-axis is the vertical line.


band, defined
band

A repeating horizontal section of a report design.


BDE, defined
BDE

Borland Database Engine (formerly IDAPI). This application uses this database engine to access and deliver data. BDE maintains information about your PC's environment in the BDE configuration file (usually called IDAPI32.CFG).


binary field, defined
binary field

A field used to store data this application cannot interpret. A common use of a binary field is to store sound.


bind, defined
bind

To associate a form or report with one or more tables. The document then takes its data from the table(s) to which it is bound.


blank field, defined
blank field

A field that does not contain a value.


BLOB, defined
BLOB

Binary large object. Field types that can contain BLOBs include binary, memo, formatted memo, graphic, and OLE. Certain rules apply to these fields as a whole, and they are sometimes discussed collectively as BLOB fields.


cascade, defined
cascade

To use referential integrity to update child tables when a value changes in the parent table.


check box, defined
check box

A box you can enable or disable to set an option. You can enable more than one check box in a set.


checkmark, defined
check mark

The symbol [image] used in query statements to indicate that a field is to be displayed in the Answer table.


client, defined
client

The application that starts a DDE or OLE conversation and usually receives data from the other application, called the server.


Clipboard, defined
Clipboard

A temporary area used to copy and paste information from one location to another.


command, defined
command

A word on a menu or button that you choose to perform an action.


contain, defined
contain

To place one object within another object so that the behavior of the contained object is controlled by the container object.


container object, defined
container object

An object that completely surrounds and controls the behavior of all objects within it. When you move a container, its contained objects also move; when you delete a container, its contained objects are also deleted. An OLE field can be considered the container of the OLE object inserted into it.


crosstab, defined
crosstab

An object that lets you summarize the data in one field by expressing it in terms of two other fields, presenting it in a spreadsheet-like structure.


Crosstab tool, defined
Crosstab tool

A toolbar tool that creates crosstab objects.


data, defined
data

The information in a database.


data integrity, defined
data integrity

The assurance that only valid data can be entered in a field and that links between common fields in separate tables cannot be broken; supported by validity checks and referential integrity.


data type, defined
data type

The kind of data a field can contain.

•	Paradox data types are alpha, number, money, short, long integer, BCD, date, time, timestamp, memo, formatted memo, graphic, OLE, logical, autoincrement, binary, and bytes.

•	dBASE data types are character, float, number, date, logical, memo, OLE, and binary.


database, defined
database

An organized collection of information; a collection of related tables, forms, and reports in a given directory.


DDE, defined
DDE

Dynamic Data Exchange. A way for two or more applications to share data.


default, defined
default

What this application automatically does or looks like in the absence of an overriding command.


default action, defined
default action

The choice that this application determines to be the most logical or safest and the one that will be carried out unless otherwise specified. Default actions are performed by double-clicking an object or its icon.


default value, defined
default value

In validity checks, the value automatically entered in a field if no other value is entered.


define

To attach a design object to data from a table. For example, you define a field object in a form as a field in a table.


descending order

A sort order: reverse alphabetical order in alpha fields (most often Z to A, case-sensitive, but the order depends on the language driver you are using); high to low in numeric fields; latest to earliest in date fields.


design document

A form or report that you create or modify in a design window.


design object

An object you can place in design documents (forms and reports). You create design objects using toolbar tools in a design window.


design window, defined
design window

The window where you create or modify the design of a document. If you are viewing data in a Form or Report window, press F8 or click the Design button to open the corresponding design window for that document.


designed for the printer, defined
designed for the printer

A form or report for which you have chosen the Printer option from the Page Setup dialog box. Such forms and reports use screen style sheets that have a filename extension of .FP.


designed for the screen, defined
designed for the screen

A form or report for which you have chosen the Screen option from the Page Setup dialog box. Such forms and reports use screen style sheets that have a filename extension of .FT.


desktop, defined
desktop

The main window in this application.


dialog box, defined
dialog box

A box that requests user input or provides information. Many dialog boxes present options to choose among before you can perform an action; others display warnings or error messages.

All dialog boxes require interaction with the user; a modal dialog box, however, keeps the focus until you respond to it.


drop-down list box, defined
drop-down list box

A single-line text box that opens to display more choices when you click the arrow beside it.


field, defined
field

A column of information in a table. A collection of related fields makes up one record.


field type, defined
field type

The type of data a field can contain.

•	Paradox data types are alpha, number, money, short, long integer, BCD, date, time, timestamp, memo, formatted memo, graphic, OLE, logical, autoincrement, binary, and bytes.

•	dBASE data types are character, float, number, date, logical, memo, OLE, and binary.


field value, defined
field value

The data contained in one field of a record. If no data is present, the field is considered blank.


Field View, defined
Field View

A mode that lets you move through a field character by character. Use this mode to view field values that are too large to be displayed in the current field width, or to edit a field value. Pressing F2 puts you into Field View.


file, defined
file

A collection of information stored under one name on a disk.


file name, defined
filename

When entering a filename, you can simply type the name of the file; or, you can specify the filename combined with a drive, path, alias, or a combination of these elements. Some examples of valid filenames:

File name	Description

MYFILE.DB	Filename

D:\MYFILE.DB	Filename combined with drive

:MYWORK:MYFILE.DB	Filename combined with alias

:MYWORK:\PHONEDIR\MYFILE.DB	Filename combined with alias and path


font, defined
font

A design applied to all characters. Fonts are typically available in different sizes, measured in points; 1 point equals 1/72 of an inch. Font styles usually include bold, italic, and underline.


footer, defined
footer

Information that appears at the bottom of every page of a report. Footers are created in the page bands, report, and group bands of reports.


form, defined
form

An alternate presentation of a table's data. A multi-table form can display data from several tables at once.


Form window

The Form window appears when you open a form file. Use the Form window to view and edit data in a form.


Formatted memo field

A database field type similar to a memo field except that you can format the font, style, color, and size of the text.


function, defined
function

A built-in formula that performs computations or determines the status of this application or your computer system.


function keys, defined
function keys

The 12 keys across the top of the keyboard labeled F1 through F12. (Some keyboards have 10 function keys at the left.) These keys provide fast access to application operations.


Graphic field

A database field type consisting of pictures, drawings, or other graphical images in Windows bitmap format.


grid, defined
grid

A network of horizontal and vertical lines available in all design windows as aids for placement of design objects. You can show or hide the grid, as well as resize it.


group, defined
group

In a report, a set of records that either

•	have the same value in one or more fields

•	fall within a range of values

•	are displayed in a fixed number of records


handle, defined
handle

A position on a design object that lets you change an object's size or shape. When you select a design object, handles appear around it. When you pass the pointer over a handle, the pointer changes shape to show the direction of movement possible. Drag the handles to change an object's size or shape.


header, defined
header

Information that appears at the top of every page of a report. Headers are created in the page, report, and group bands of reports.


highlight, defined
highlight

To select by dragging the mouse across a line or lines of text.


icon, defined
icon

A graphical representation of an object.


inclusion operator, defined
inclusion operator

The symbol ! used with an example element to include a complete set of records in the Answer table, whether or not they match records in another table.


inclusive link, defined
inclusive link

A query whose answer includes all the values in a field of one table, whether or not there are matching values in the linked field of another table.


index, defined
index

A file that determines an order in which this application can access records in an underlying table. A Paradox table's key establishes its primary index.


inspect, defined
inspect

To right-click an object to see its menu.


key, defined
key

A field or group of fields in a Paradox table used to order records or ensure referential integrity. Establishing a key has three effects:

•	The table is prevented from containing duplicate records.

•	The records are maintained in sorted order based on the key fields.

•	A primary index is created for the table.


keycode, defined
keycode

A code that represents a keyboard character in ObjectPAL scripts. A keycode can be an ASCII number, an IBM extended keycode number, or a string representing a keyname known to this application.


keyword, defined
keyword

A word reserved for use with certain commands in ObjectPAL.


landscape, defined
landscape

Printing is along the path of the paper feed.


library, defined
library

An object that stores custom ObjectPAL code. Libraries are useful for storing and maintaining frequently used routines and for sharing custom methods and variables among forms, scripts, and other libraries.


link, defined
link

To establish a relationship between tables by linking corresponding fields.


list box, defined
list box

A list of selectable items in a dialog box.


lock, defined
lock

A device you place on a table in a multi-user environment that prevents other users from viewing, changing, or locking the table.


logical operator, defined
logical operator

One of three operators (AND, OR, or NOT) that can be used in queries.


logical value, defined
logical value

A value (True or False) assigned to an expression when it is evaluated.


lookup table, defined
lookup table

A table that assures that a value entered in one table matches an existing value in another table.


Main menu, defined
Main menu

The menu bar across the top of the desktop.


master table, defined
master table

In a multi-table relationship, the primary table of your data model. If you have only one table in your data model, that table is the master table. In a multi-table data model, the master table is the one pointing to another table. For example, in the following data model, all tables except VENDORS.DB are master tables.


Memo field

A database field type that allows you to store lengthy text messages in your table. The text can be as long as you like because Paradox stores the memo outside the table. You can determine how much of the text will appear in table view.


Memo View (definition)
Memo View

A window in which you can view the entire contents of a memo or formatted memo field. You can also edit memo text here. Memo view offers more word processing capabilities than Field View. You can access Memo View by pressing SHIFT+F2.


method, defined
method

ObjectPAL code attached to an object that defines the object's response to an event.


modal, defined
modal

A modal dialog box keeps the focus until you respond to it. You cannot move nor resize a modal dialog box.


multi-record, defined
multi-record

Refers to an object that displays several records at once in a form or report.


multi-value relationship, defined
multi-value relationship

A multi-value relationship exists between tables if, for every record in one table, no records, one record, or more than one record from another table is related to it. In a data model, a multi-value relationship is indicated by this symbol: . For example, in the following data model, a multi-value relationship exists between CUSTOMER.DB and ORDERS.DB, and between ORDERS.DB and LINEITEM.DB:


normalized data structure, defined
normalized data structure

An arrangement of data in tables in which each record includes the fewest number of fields necessary to establish unique categories. Rather than using a few redundant fields to provide all possible information within a single table, normalized tables distribute information over many tables using fewer fields. Normalized tables provide more flexibility in terms of analysis.


number field, defined
number field

A field that can contain only numbers, a sign, and a decimal point.


object, defined
object

A table, form, report, query, script, library, or SQL file. All entities that can be manipulated in this application are objects.


ObjectPAL, defined
ObjectPAL

The Paradox application language.


OEM, defined
OEM

Stands for Original Equipment Manufacturer and refers to the character set your computer uses.


OLE, defined
OLE

Object Linking and Embedding. Use OLE to insert files from OLE servers into OLE fields in forms.


OLE container, defined
OLE container

An application that requests the services of, and cooperates with, an OLE server to offer the user a way to view and edit objects created by that server. This application provides OLE container services in the form of the OLE field type.


OLE object

An object created in one application and used in another by means of OLE (object linking and embedding). OLE objects are connected to the application in which they were created and can be modified from within the application in which they have been placed.


OLE server, defined
OLE server

An application that provides services to, and cooperates with, an OLE client to offer the user a way to view and edit objects created by that server.


operator, defined
operator

A symbol that represents an operation to be performed on a value or values. For example, the + operator represents addition, and the * operator represents multiplication.


outer join, defined
outer join

A type of query that uses the inclusion operator (!) to retrieve all records in a table, whether or not they match records in another table.


picture, defined
picture

A pattern of characters that defines what you can type into a field during editing or data entry.


pop-up definitions, defined
pop-up definitions

Introduce you to terms that might be unfamiliar or words that this application uses in a special way.


portrait, defined
portrait

Printing is crosswise to the feeding of the paper through the printer.


primary index, defined
primary index

An index on the key fields of a Paradox table. A primary index

•	determines the location of records

•	lets you use the table as the detail in a link

•	keeps records in sorted order

•	speeds up operations


private directory, defined
private directory

A non-shared directory for storing temporary objects. The default private directory is PRIVATE, created below the main application directory on your hard drive, or on your network home directory if you have no hard drive. You can change to another private directory if you want.


prompt, defined
prompt

Instructions displayed on the screen. Prompts ask for information or guide you through an operation.


Project Viewer, defined
Project Viewer

A tool for organizing, managing, and using your files. The Project Viewer displays all files for the current working and private directories. Open the Project Viewer by choosing Tools, Project Viewer.


properties, defined
properties

The attributes of an object.


prototyping, defined
prototyping

A process of application development in which small parts or the general structure of an application are designed and tested interactively. These models are then used as the basis for building the finished system.


query, defined
query

A way to retrieve data from your tables.


query by example (QBE), defined
query by example (QBE)

The method of retrieving data by providing an example of what you are looking for.


query operators, defined
query operators

The reserved words used in queries.


query statement, defined
query statement

One or more filled-out query images in the Query window.


record, defined
record

A group of related fields of data about one member of the database.


record number, defined
record number

A unique number that identifies each record.


referential integrity, defined
referential integrity

A way of ensuring that the ties between like data in separate tables cannot be broken.


report, defined
report

A database object that displays data in a format that you specify. Reports, which can contain data from many tables, are flexible, powerful, and easy to use. They can be previewed on screen before being printed.


Report window

The Report window appears when you open a report file (*.RSL, *.RDL) in this application. Use the Report window to view your data and print it to the screen or to a printer.


reserved words, defined
reserved words

The names of commands, keywords, functions, system variables, and operators. These words may not be used as ObjectPAL variable or array names.


restructure, defined
restructure

To change the structure of an existing table. You can change the field names, field types, field order, key, indexes, validity checks, referential integrity, password protection, table language, and table lookup.


script, defined
script

An object that contains code within its own file, not attached to a form. Scripts perform actions automatically when run.


secondary index, defined
secondary index

An index used for linking, querying, and changing the view order of tables.


selection condition, defined
selection condition

Expressions typed in the Table Filter dialog box to specify the conditions that records must meet.


separator

A separator breaks a toolbar into sections. You can use a separator to categorize toolbar buttons.


server, defined
server

The application that responds to the calling application, or client, in a DDE or OLE conversation. The server usually sends data to the client.


set, defined
set

In a query, the specific group of records you intend to query.


set comparison operator, defined
set comparison operator

One of the reserved words (ONLY, NO, EVERY, EXACTLY) used to compare a defined set of records to other records.


short field, defined
short field

A Paradox field type that can contain numbers from -32,768 through 32,767 with no decimal values.


single-value relationship, defined
single-value relationship

A single-value relationship exists between tables if, for every record in one table, no records or only one record from another table is related to it. In a data model, a single-value relationship is indicated by this symbol: . For example, in the following data model, a single-value relationship exists between LINEITEM.DB and STOCK.DB, and between STOCK.DB and VENDORS.DB:


special field, defined
special field

A field that contains information about a form or report. Special fields include Today, Now, and Page Number.


SQL, defined
SQL

Structured Query Language (abbreviated SQL). The standard language for storing and manipulating data in relational databases.


string, defined
string

An alphanumeric value, or an expression consisting of alphanumeric characters.


structure, defined
structure

The arrangement of fields in a table.


summary operator, defined
summary operator

One of the operators (AVERAGE, COUNT, MAX, MIN, or SUM) that retrieves data from groups of records in queries.


syntax error, defined
syntax error

An error caused by an incorrectly expressed statement.


tab well, defined
tab well

The tab well is the upper half of the Horizontal Ruler where tabs, margins, and indents are displayed for a text object.


table, defined
table

A structure made up of rows (records) and columns (fields) that contain data.


table frame, defined
table frame

A frame representing a table in a form or report. A table frame looks like its source table, but a table frame is not a table.


table header, defined
table header

Paradox tables consist of two sections: the header and the data blocks. The header contains information about the number of fields, passwords, write protection, sort order, and the version of Paradox that created the table. Indexes and memos are stored in separate files.


table language driver, defined
table language driver

Determines the table's sort order and available character set. The BDE Administrator lets you set the default language driver for Paradox and dBASE tables.


toolbar, defined
toolbar

The set of buttons and tools for frequently performed tasks. The toolbar is under the menu bar and changes according to the window you are using.

To get quick help on what a tool or button does, point to it [image] and a description of the button appears in the status line.


validity check, defined
validity check

A constraint on the values you can enter in a field.


variable, defined
variable

A place in memory to store data temporarily.


wildcard operators, defined
wildcard operators

Special characters this application uses to match patterns in queries or when locating values.


working directory, defined
working directory

The default data directory this application uses to open and save files.


zoom, defined
zoom

To change the scale of a design screen. You can zoom out (decrease the scale and see a larger area) or zoom in (increase the scale and see part of the design up close).


Alignment property (field)
Alignment property

Changes the alignment of the selected text.

Left	Lines up text at the left, with the right edge ragged

Center	Clusters text in the middle of the object

Right	Lines up text at the right, with the left edge ragged

Justify	Spreads out text so both left and right margins are straight


Line Spacing property

Specifies how far apart lines of text are spaced. You can choose the number of lines separating each column or row. The choices are 1, 1.5, 2, 2.5, or 3 lines.


Size property

Changes the font point size. This application displays a list of available point sizes for you to choose from.


Font property

Changes the typeface of the selected text. Choose from the menu of available font typefaces. Standard typefaces include Helvetica, Times, Courier, and System. The typefaces available from the Font list depend on the fonts installed on your system.


Word Wrap property

Allows the contents of a formatted memo field to display on more than one line when they exceed the width of the field object.


Font Style property

Changes the style of the selected text.

Choose	To

Normal	Remove all style attributes from the text

Bold	Display the text in a heavier style

Italic	Display the text at a slanted angle

Bold Italic	Displays the text in both Bold and Italic


Effects property

Applies underline and/or strikeout effects to the selected text. Enable the appropriate check box to apply the desired effect.


Color property

Changes the color of the selected text. Choose from the palette by clicking on the desired color.


No help is available for this property.


Font page (fields)
Font page (Properties dialog box))

The following Font properties are available for formatted memo fields:

•	Font

•	Font Style

•	Size

•	Effects

•	Color


Text page (fields)
Text page (Properties dialog box)

The following Text properties are available for formatted memo fields:

•	Alignment

•	Spacing

•	Word Wrap


Reports


Overview: Reports
Reports

Reports are printing tools that allow you to format and print your data. Since they cannot be used to change the data that exists in a table, they should be designed simply to display data in a variety of ways. You can also use a report to display the data that exists in another table.

The primary difference between forms and reports is that forms are editing tools that let you display and edit data, and reports are viewing tools that let you format and print your data.

 More Detailed Information


Opening, viewing and navigating reports


Overview: Opening, viewing and navigating reports
Opening, viewing and navigating reports

Paradox Runtime lets you open and view a report. Navigational buttons and menu commands let you move through a report.

 Related Topics


Opening reports

Opening a report shows what the printed report will look like with data in it. You cannot enter or edit data in a report. A report is a viewing tool.

You can use reports to display, analyze and print your data.

To open a report

1.	Click File, Open, Report.

2.	Choose the drive where the file is stored from the Look In box.

3.	Double-click the folder in which the file is stored.

4.	Double-click the file name.

 Tip

•	You can also open a report by clicking the Open Report button on the toolbar or double-clicking the report's icon in the Project Viewer.

 Related Topics


Viewing reports

You can change the scale of a report on screen. You can zoom out (decrease the scale and see a larger area) or zoom in (increase the scale and see part of the document up close).

To zoom forms and reports

1.	Click View, Zoom in a Report window.

2.	Choose one of the following:

•	25% or 50% takes a step back from your document

•	200% or 400% takes a closer look at your document

•	Fit Width fits the width to the window

•	Fit Height fits the height to the window

•	Best Fit fits the entire document to the window

 Related Topics


Navigating a report

Navigation buttons appear on the toolbar when you open a report. Click the buttons to move among pages of the report.

Click...	To...

Move to the first page of the report

Move to the previous page of the report

Move to the next page of the report

Move to the last page of the report

Open the Go To Page dialog box, where you type in a page number

 Note

•	There is a difference between navigating in a report and navigating in a form. In a report, navigation buttons and commands on the View, Page menu move through pages. In a form, navigation buttons move through records.

 Tips

•	You can also click View, Page, to navigate a report.

•	Next page and Previous page have shortcut buttons to speed up navigation as well. SHIFT + F4 displays the next page; SHIFT + F3 displays the previous page.

 Related Topics


Printing reports


Overview: Printing reports
Printing reports

Printing a report to a file

Sometimes, you might want to print the report to a file so you can take it to a printing service or transfer it to another computer.

Using a report with a different table

You can open a report created on one table using the data from another table or from a saved query or saved SQL file.

The following are rules that apply when using a report with a different table:

•	The master table is the only table that can be changed.

•	If the original table and the new table have identical field names and table structures, Paradox automatically re-binds the fields in the report to the new table.

•	If the report has field objects on it that cannot be re-bound to the new table (because there is no corresponding field in the new table), Paradox displays those field objects as undefined.

•	If the report has calculated fields that reference missing fields, the calculated fields will have invalid expressions.

 Note

•	To print a report to a file, you need to add a printer through the Windows Control Panel and set its output to a file. Then, select that printer as the active printer before printing your report.

 Related Topics


Printing a report

You can print either a full or partial report.

To print a report

1.	Click File, Print.

2.	Choose a printer from the Current Printer list box.

3.	Do one of the following:

•	To print the entire report, enable the Full File button.

•	To print selected pages of the report, enable the Page Range buttons and choose the pages to print.

4.	Choose the number of copies to print.

 Notes

•	You can use the Overflow Handling options area to specify how to treat data that is too wide to fit on the printed page.

•	While sending the report to the printer, Paradox displays a dialog box with a Cancel button. Click the Cancel button at any time to stop sending the report to the printer. (Clicking the Cancel button does not cancel pages Paradox has already sent to the printer.)

•	If the report was designed for the screen, the fonts that appear on the printed output might not match those that you see on screen. This depends whether your screen fonts and printer fonts match.

 Related Topics


Printing to a file

Sometimes, you might want to print the report to a file so you can take it to a printing service or transfer it to another computer. To print a report to a file, you must add a printer through the Windows Control Panel and set its output to a file. Select that printer as the active printer before you print your report.

To print to a file

1.	Click File, Print.

2.	Click the Details tab.

3.	Choose the printer from the Current Printer list box.

4.	Enable the Print to File button.

5.	Type a path and a filename for the report in the Print to File box.

 Related Topics


Printing or previewing a report with a different table

You can change the table that underlies a report.

To print or preview a report with a different table from the desktop

1.	Click File, Open, Report.

2.	Choose the report.

3.	Click the Change Table button.

4.	In the Select File dialog box, choose the table, saved query, or saved SQL file to use in the report.

5.	Click OK.

The Open Report dialog box returns.

6.	Click the Open button.

To print or preview a report with a different table from the Project Viewer

1.	Click Reports, then right-click the desired report.

2.	Click one of the following menu options:

•	Run With [image] previews a specified report

•	Print With [image] prints a specified report

3.	Select the table, saved query, or saved SQL file to use in the report.

Paradox Runtime warns you if a field in the report does not have a corresponding field in the table. When the report opens, any undefined fields are given the name LABEL, and no data appears in them.

 Related Topics


Scripts


Overview: Scripts
Scripts

Scripts contain commands for starting applications and automating tasks. Script objects appear as icons in the Project Viewer.


Opening a script

You can run a script from the desktop or the Project Viewer.

To run a script from the desktop

1.	Click File, Open, Script.

2.	Double-click the script.

To run a script from the Project Viewer

•	Double-click the script on the right panel of the Project Viewer window.


No help is available for the item you selected.


Form window

The Form window appears when you open a form file. Use the Form window to view and edit data in a form.


Report window

The Report window appears when you open a report file (*.RSL, *.RDL) in this application. Use the Report window to view your data and print it to the screen or to a printer.


Project Viewer

Use the Project Viewer to manage the objects in your working directory.

Working Directory

The Project Viewer shows the objects in your working directory.

Managing files

Choose the type of object you want to see or choose Custom to see all objects in the working directory.

Right-click the name of an object for a menu of commands you can use on the object. The commands available depend on the object. Double-click an object to perform the default action (first item on the menu).

 Note

•	The Project Viewer also shows objects in your private directory.


Edit menu


Copy command

Copies the selected text or objects onto the Clipboard.


Copy To command

Copies binary, memo, formatted memo, and graphic values to non-Paradox files, without using the Export command.


Cut command

Removes selected text or objects and places them on the Clipboard.


Delete command

Deletes the selected text or object and all objects contained by it.


Find and Replace command

Searches for a text string (a word or phrase) in a selected memo field, formatted memo field or text object.


Links command

Opens the Edit Links dialog box, which allows you to modify the links in OLE containers.


<OLE object> command

Displays a secondary menu that contains the OLE commands provided by an OLE server.


Paste command

Inserts information previously placed on the Clipboard. The contents of the Clipboard are not deleted when you paste, so you can paste as many times as you want.


Paste From command

Pastes a value from an external file into a selected Paradox field or object. You can paste from .TXT, .BMP, .PCX, .TIF, .GIF, and .EPS files.


Paste Special command

Creates a linked duplicate of data entered through Dynamic Data Exchange (DDE) so that any change you make to the source is automatically made to the duplicate. Also inserts a linked object in an OLE container.


Select All command

Selects the entire field.


Undo command

Undoes the last operation or edit. You cannot use the Undo command to retrieve a record you have deleted.


File menu


Close command

Closes the active child window.


Exit command

Closes this application.


Open command

Opens a form or report or runs a script file.


Print command

Prints the active form or report.


Send To command

Sends the file to the selected destination.


Working Directory command

Opens the Set Working Directory dialog box to allow you to quickly access a group of files that are in the same directory.


Write As Text File command

Saves the current report as a text (.TXT) file.


Format menu


Form Setup command

Lets you set display properties for the screen and rulers.


Help menu


About Paradox Runtime command

Opens the About Paradox Runtime dialog box, which displays the version of Paradox Runtime that you are using.


 #Application Basics Help command

Opens the Application Basics Help file.


Insert menu


Object command

Inserts an object in an OLE field.


Record menu


Delete command

Deletes the current record from the table.


Filter command

Opens the Filter dialog box, which allows you to set filter criteria to display a selected set of records, or display the records in a specific order.


 #Go To command

Moves to the specified record.


Insert command

Places a blank record above the selected record.


 #Locate command

Finds specified records and values in a table.


Locate Next command

Searches for the next occurrence of the value you last searched for.


Lock command

Places a lock on the record you are viewing.


Lookup Help command

Opens the appropriate lookup table for a field with required values, which allows you to choose the value you want.


Move Help command

Moves a detail record to a new master record in either a 1 [image] M form or a referential integrity relationship.


 #Post/Keep Locked command

Writes your changes to the current record and moves the record to its place in a keyed table. Other users can see it, but the record is locked so you can continue editing it.


 #Record Number command

Moves to a particular record specified by number in the Locate Record Number dialog box. The record number of a Paradox table is assigned automatically by Paradox and cannot be edited.


Reference command

Allows you to access Lookup Help and Move Help table reference tools.


Replace command

Opens the Locate and Replace dialog box, which allows you to specify conditions to locate and change a particular value in a field.


Value command

Moves to a particular record specified by value in the Locate Value dialog box.


Tools menu


Alias Manager command

Opens the Alias Manager dialog box, which allows you to view, change, or add database aliases.


Data Model Designer command

Opens the Data Model Designer, which allows you to modify the data model of a design document and to load, modify, and save new data models.


Display Locks command

Finds all the locks currently placed on a Paradox table in a multi-user environment and shows which user placed them.


Passwords command

Opens the Enter Passwords dialog box, where you can specify which table passwords to use in the current Paradox session. (Passwords can be defined for your tables in the Create Table or the Restructure Table dialog boxes.)


Project Viewer command

Opens the Project Viewer, which lists all the files in your current working directory or database and your private directory.


Preferences command

Opens the Preferences dialog box to set General, Toolbars, and BDE properties for current and future Paradox sessions.


Register ActiveX Control command

Opens the Register OLE Control dialog box, where you can specify the location and name of the .OCX control you want to register in the system registry.


Register Add-In command

Opens the Add/Remove Paradox Add-In dialog box, where you can specify the location and name of the add-in DLL you want to register in Paradox.


Security command

Allows you to work with Paradox table security options.


Set Locks command

Opens the Table Locks dialog box, which allows you to place locks on a table and shows existing table locks.


Settings command

Allows you to specify various application preferences.


Table Repair command

Opens the Table Repair Utility dialog box, which lets you rebuild a damaged table or verify a table's integrity.


View menu


Edit Data command

Allows you to enter or edit data in the active form.


View Data command

Allows you to view your data but not add new data or change existing data.


Field View command

Allows you to place the insertion point in a field, rather than selecting the entire field.


 #Memo View command

Allows you to place an insertion point and use ENTER and TAB as characters in Memo and Formatted Memo fields.


Page command

Navigates through document pages.


Persistent Field View command

Keeps your table, form, or query in Field View.


 #Rulers command

Shows rulers to help you position objects on your forms and reports.


 #Run Report command

Displays the data in the report.


Show Deleted command

Displays deleted dBASE records.


Toolbars command

Opens the Toolbars page of the Preferences or Toolbar Properties dialog box, which allows you to specify which toolbars display instead of or in addition to the Standard toolbar for each Paradox window.


 #View Data command

Allows you to view your data but not add new data or change existing data.


Zoom command

Allows you change the magnification to view a larger or smaller area of the onscreen design document.


Window menu


Arrange Icons command

Arranges icons across the bottom of the Desktop in a straight line, maintaining the same order it found them in, left to right.


Cascade command

Overlaps all open windows on the Desktop so only the Title Bars of inactive windows show.


Close All command

Closes all open windows on the Desktop.


Tile Side-by-Side command

Fits all open windows side-by-side on the Paradox Desktop without overlapping. The currently active window will be the leftmost window.


Tile Top and Bottom command

Fits all open windows one above the other on the Paradox Desktop without overlapping. The currently active window will be the topmost window.


<window name> command

Activates the listed window.


Right-click menus


Data Dependent command

Opens the Data Dependent Properties dialog box, which lets you display a specified range of values with different colors or fonts.


 #Filter command

Opens the Field Filter dialog box to apply a filter to the selected field or field object.


Global command

Displays the Global toolbar when enabled.


 #Paste <OLE object on Clipboard> command

Places the OLE object on the clipboard into an OLE object on a form or report.


Properties command

Opens the appropriate Properties dialog box, which allows you to set various physical properties for the selected object.


Standard command

Displays the Standard toolbar for each window when enabled.


Project Viewer right-click

Not sure if these are going to be hooked up.


Add Reference command

Adds a reference to a file in the Project Viewer.


Cut command

Places the selected file on the clipboard to be moved to another location.


Copy command

Places a copy of the selected file on the clipboard to be used in another location.


Corel Versions command

Helps you archive files and keep track of document revisions.


Create Shortcut command

Creates a shortcut in the Custom directory to the selected file.


Delete command

Removes the selected file.


Design command

Opens the selected file in design mode.


Open command

Opens or runs the selected file.


Open With command

Allows you to choose the application to open the selected file.


Properties command

Displays the system properties of the selected file.


Print command

Opens the Print dialog box, which allows you to print the selected file.


Remove Reference command

Removes a reference to a file from the Project Viewer. Removing a reference from the Project Viewer does not delete it. The file still exists and will still appear in list boxes.


Send To command

Sends the selected file to another location.


Show Only References command (View menu)

Displays in the Project Viewer only those objects for which you have created references.


If the directory you want has an alias, you can select it in the Alias drop-down list. The name of the selected directory appears in the Look In drop-down list and the files in that directory appear in the file list.


View the Form opens the form in its view window.


Edit the Form Design opens the form in its design window.


Print the Report prints the form as a report if you also choose Open as Report.


Open as a Report opens the form as a report. This is a quick way to use a form layout to specify the layout of a report.


Run the Query runs the query and displays the Answer table.


Edit the Query opens the query in its design window.


View the Report opens the report in its view window.


Edit the Report Design opens the report in its design window.


Print the Form prints the report as a form if you also choose Open as Form.


Open as a Form opens the report as a form. This is a quick way to use a report layout to specify the layout of a form.


Run the Script runs the script.


Edit the Script opens the script in its design window.


Run the Query runs the query and displays the Answer table.


Edit the Query opens the query in its design window.


Opens a form or report using a different master table [image] a different table from the one on which it was originally designed. When you choose Change Table, Paradox opens the Select File dialog box, where you specify the new master table.


International topics


Overview: International topics
International topics

The following topics provide an overview of international features of Paradox Runtime and how to use them to adhere to different conventions, such as

•	Character set issues

•	Sorting conventions

•	Data formats

 Note

•	These issues are of particular interest to those working in international environments, but they apply to all users.

 More Detailed Information
 Related Topics


Overview: Preparation and assumptions
Preparation and assumptions

Before installing Paradox Runtime in (or using tables from) an international setting, make sure of the following:

•	The International settings of Windows Control Panel correspond to your needs.

•	You understand the differences between (and implications of) the Windows (ANSI) character set and your DOS (OEM) code page.

•	You know how to use ALT and the numeric keypad to enter extended characters in Windows applications and files (make sure NUMLOCK is on before attempting this).

For more information about these issues and concepts, consult your Windows and DOS documentation.

 More Detailed Information
 Related Topics


Overview: Sorting conventions
Sorting conventions

Paradox 9 Runtime uses language drivers to sort tables according to different conventions. If you are using a workstation with non-U.S. settings or are working with tables created on non-U.S. workstations, make sure Paradox Runtime is using the language driver(s) closest to the conventions you are used to.

In most cases, you should not have to worry about a table's language drivers after setting the default drivers for your workstation. When sharing tables between workstations, make sure the workstations are using the same default language drivers.

 More Detailed Information
 Related Topics


Overview: Character set issues
Character set issues

Because Paradox Runtime is a Windows application, it supports the ANSI character set for files that can be used only by other Windows applications. This includes forms, reports, scripts, and libraries. Paradox Runtime stores OEM characters in tables. This means Paradox Runtime translates ANSI characters to those in your OEM code page when saving table data.

For example, if you are using code page 437 (the default code page for U.S. workstations that support ASCII) and place an "Æ" (ANSI character 198) in a field, Paradox Runtime saves it as OEM character 146. You will see the same character when viewing the table, but it is not literally the same one you originally entered.

Most of the time, this is transparent; that is, there is no loss of data. However, if you enter a character that is not supported by your code page, this application converts it to one that is. For example, if you are using code page 437 and type an "Õ," Paradox Runtime converts it to an "O" because your code page does not support the original character. In this example, a mild form of data loss occurs; the tilde ( ~ ) is removed.

If you enter an ANSI character that cannot be converted to a similar character in your code page, Paradox Runtime replaces it with OEM character 254 ().

Character conversion occurs when you enter data. In most other operations, Paradox Runtime uses and saves characters from the ANSI character set.

 More Detailed Information
 Related Topics


Overview: Working with tables using different language drivers
Working with tables using different language drivers

Although you can use different language drivers for different underlying tables, we advise against linking tables using different language drivers.

Paradox Runtime is designed to handle such operations; however, some language driver combinations may yield unexpected results. For best results, choose one language driver.

 More Detailed Information
 Related Topics


Overview: Data formats
Data formats

In Paradox Runtime, the default symbols and formats used for your data are based on the International settings in the Windows Control Panel. For example, if you set your Windows Control Panel money symbol to "$," Paradox Runtime uses it when displaying money values. Similarly, Paradox Runtime formats date and time values according to the settings used by Windows.

To set Paradox Runtime's defaults permanently to different formats, begin by altering the settings in the Windows Control Panel. When you alter these settings, it affects the default formats used in all application operations, except some internal data conversion operations.

 More Detailed Information
 Related Topics


Internal data conversion


Overview: Internal data conversion
Internal data conversion

Many operations require Paradox Runtime to convert a string of characters to a number, date, or time value. For example, when you enter a date into a table, Paradox Runtime converts the characters you type to a value representing a date. This process is automatic and generally uses format settings in Windows Control Panel to control the conversion. However, a few operations use BDE to convert character strings to number, date, or time values and to convert these data formats to character strings.

Because these operations use BDE for this internal data conversion, you must ensure the BDE configuration file uses the same data format conventions and settings as Windows Control Panel; otherwise, unexpected results might occur. This does not affect the way data is formatted when you display it; Paradox Runtime uses the settings in Windows Control Panel to display data.

We recommend using standard data formats when possible.

In most cases, you will not have to worry about these settings because BDE (when installed) is configured to the data format conventions of the country defined in Windows Control Panel. However, if you customize Windows Control Panel so it uses settings that are different from your country's data format conventions, you should also configure BDE to the same settings; otherwise, queries that match date and numeric values may yield unexpected results.

For example, the "forward-slash" (/) is commonly used in U.S. workstations as a date separator. If you change this to an ampersand (&) in Windows Control Panel, you should also configure BDE so it uses an ampersand for a date separator.


BDE international settings and language drivers

You can configure BDE to specialized date, time, or number formats. You can also change the default language driver.

To configure BDE to specialized date, time, or number formats

1.	Click Start, Programs, Paradox Runtime, Utilities, Borland Database Engine.

2.	Click the Configuration tab.

3.	Double-click Configuration.

4.	Double-click System.

5.	Double-click Formats.

6.	Double-click one of the following:

•	Date

•	Time

•	Number

You will probably need to change the formats in all three sections.

7.	Type in the parameters in the various format sections that match those of the new data format.

For information about the specific sections of the format pages, see the BDE Administrator's online Help.

8.	Click File, Save.

 Notes

•	If you customize BDE so it uses special number formats, you may not be able to share saved queries with other workstations unless those workstations have also been customized to the same settings.

•	Make a backup of the BDE configuration file before changing it with the BDE Administrator.

•	You can also update BDE to the current settings in Windows Control Panel by reinstalling BDE.

To change the default language drivers for Paradox Runtime

1.	Follow steps 1 to 3 in the previous procedure.

2.	Double-click Drivers.

3.	Double-click one of the following drivers:

•	Native

•	ODBC

4.	Double-click a driver type.

5.	Type a new driver name for the LANGDRIVER parameter.

 Note

•	Each language driver is appropriate only for a particular code page. Use language drivers appropriate for your code page. To see the language drivers appropriate for each code page, see the BDE Administrator's online Help.


Alias Manager dialog box (SQL Link driver)

Use the Alias Manager dialog box to create or modify aliases for remote database directories, or to connect to or disconnect from the target SQL server.

You are working with an alias for a SQL Link driver. The settings in the Alias Manager dialog box reflect the information stored in your BDE configuration file.

If you are working with an ODBC driver connection, some of the options below are not available.

Dialog box options

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use BDE. Disable this check box to make an alias a project alias [image] available only to applications in the current directory.

Database Alias

Choose an alias from the list. To create a new SQL Link driver alias, click New, then choose the appropriate driver type, then type the new alias name.

Alias configuration options

•	Driver Type:  To create an SQL Link driver alias, choose the appropriate driver type from the list.

•	Server Name:  The name of the target SQL server.

•	User Name:  The default name for accessing the SQL server.

•	Open Mode:  The mode in which SQL Link opens the SQL database. Can be READ/WRITE (default) or READ ONLY.

•	Schema Cache Size:  The number of SQL tables whose schema information will be cached. Can be any whole number from 0 to 32 (default=8).

•	Langdriver:  The language driver used to display SQL data to this application (U.S. default=blank). Choose the language driver that uses the same character set in which the server passes data to this application, and a collation sequence that matches your server's collation sequence.

•	SQLqrymode:  SQL query mode; the method for handling queries to SQL data. Can be NULL (blank setting, which is the default), SERVER, or LOCAL.

•	SQLpassthru Mode:  SQL pass-through mode; specifies whether or not application users can access the SQL server via both QBE and the SQL Editor (pass-through SQL) in the same alias connection. Can be NOT SHARED, SHARED AUTOCOMMIT (default), or SHARED NO AUTOCOMMIT.

Password

Type the password needed to connect to the server. Asterisks (*) represent the characters you type.

Show options

•	Show Public Aliases Only:  Click this button if you want to see only public aliases.

•	Show Project Aliases Only:  Click this button if you want to see only project aliases.

•	Show All Aliases:  Click this button if you want to see both public and project aliases.

Connect

Click the Connect button to log on to the server named in the Server Name text box, using the current User Name and Password. Depending on your server, this may take a while.

Disconnect

Click the Disconnect button to log off the server named in the Server Name text box.

New

Click the New button to open an empty box where you can type in a new alias name. After you click the New button, it becomes the Keep New button.

Keep New

Click the Keep New button if you want this to be a temporary alias, existing only until you exit. Then click the OK button to close the Alias Manager dialog box.

Clicking the Keep New button does not close the dialog box. It lets you save the alias temporarily when you click the OK button. If you click the Cancel button, whatever you saved with the Keep New button is deleted. Click the Keep New button if you are creating several aliases and do not want to re-open this dialog box to create each one. Then clicking the Save As button will save them all.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want your new alias to be permanent [image] usable any time you use this application. You will see the Save File As dialog box. Unless you choose a different configuration file, this application stores saved aliases in your default BDE configuration file.

The message, "File already exists. Overwrite?", appears when you click the Save As button and choose a filename. Click the Yes button. This application appends the aliases to the file; it does not replace the ones already there.

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current application session.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with the Save As button remain.

 Related Topics


Alias Manager dialog box (InterBase SQL Link)

Use the Alias Manager dialog box to create or modify aliases for local, network, or remote database directories. You can also choose to connect or disconnect from a server. Most of the options described below are available only if you have installed a Corel SQL Link driver and have chosen the INTRBASE option from the Driver Type list.

The settings in this dialog box reflect the information stored in your BDE configuration file.

Dialog box options

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use BDE. Disable this check box to make an alias a project alias [image] available only to applications in the current directory.

Database Alias

Choose an alias from the list. To create a new InterBase alias, click the New button, then choose the INTRBASE driver type, then type the new alias name.

Alias configuration options

•	Driver Type:  To create an InterBase alias, choose INTRBASE.

•	Server Name:  The name of the target InterBase SQL server, usually a path that includes the server name.

•	User Name:  The default name for accessing the InterBase SQL server.

•	Open Mode:  The mode in which SQL Link opens the InterBase database. Can be READ/WRITE (default) or READ ONLY.

•	Schema Cache Size:  The number of SQL tables whose schema information will be cached. Can be any whole number from 0 to 32 (default=8).

•	Langdriver:  The language driver used to display SQL data to this application (U.S. default=blank). Choose the language driver that uses the same character set in which the server passes data to this application, and a collation sequence that matches your server's collation sequence.

•	SQLqrymode:  SQL query mode; the method for handling queries to SQL data. Can be NULL (blank setting, which is the default), SERVER, or LOCAL.

•	SQLpassthru Mode:  SQL pass-through mode; specifies whether or not application users can access the InterBase SQL server via both QBE and the SQL Editor (pass-through SQL) in the same alias connection. Can be NOT SHARED, SHARED AUTOCOMMIT (default), or SHARED NO AUTOCOMMIT.

•	Schema Cache Time:  The time (in seconds) that a table list is cached. A value of -1 causes the schema list to be cached until the database is closed and reopened.

Password

Type the password needed to connect to the server. Asterisks (*) represent the characters you type.

Show options

•	Show Public Aliases Only:  Click this button if you want to see only public aliases.

•	Show Project Aliases Only:  Click this button if you want to see only project aliases.

•	Show All Aliases:  Click this button if you want to see both public and project aliases.

Connect

Click the Connect button to log on to the server named in the Server Name text box, using the current User Name and Password. Depending on your server, this may take a while.

Disconnect

Click the Disconnect button to log off the server named in the Server Name text box.

New

Click the New button to open an empty box where you can type in a new alias name. After you click the New button, it becomes the Keep New button.

Keep New

Click the Keep New button if you want this to be a temporary alias, existing only until you exit. Then click the OK button to close the Alias Manager dialog box.

Choosing the Keep New button does not close the dialog box. It lets you save the alias temporarily when you click the OK button. If you click the Cancel button, whatever you saved with the Keep New button is deleted. Click the Keep New button if you are creating several aliases and do not want to re-open this dialog box to create each one. Then clicking the Save As button will save them all.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want your new alias to be permanent [image] usable any time you use this application. You will see the Save File As dialog box. Unless you choose a different configuration file, this application stores saved aliases in your default BDE configuration file.

The message, "File already exists. Overwrite?", appears when you click the Save As button and choose a filename. Click the Yes button. This application appends the aliases to the file; it does not replace the ones already there.

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current application session.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with the Save As button remain.

 Related Topics


Alias Manager dialog box (Informix SQL Link)

Use the Alias Manager dialog box to create or modify aliases for local, network, or remote database directories. You can also choose to connect or disconnect from a server. Most of the options described below are available only if you have installed a Borland SQL Link driver and have chosen the INFORMIX option from the Driver Type list.

The settings in this dialog box reflect the information stored in your BDE configuration file.

Dialog box options

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use BDE. Disable this check box to make an alias a project alias [image] available only to applications in the current directory.

Database Alias

Choose an alias from the list. To create a new Informix alias, click the New button, then choose the INFORMIX driver type, then type the new alias name.

Alias configuration options

•	Driver Type:  To create an Informix database alias, choose INFORMIX from the list.

•	Server Name:  The name of the target Informix SQL server.

•	Database:  The name of the target Informix database.

•	User Name:  The default name for accessing the Informix SQL server.

•	Open Mode:  The mode in which SQL Link opens the Informix database. Can be READ/WRITE (default) or READ ONLY.

•	Langdriver:  The language driver used to display SQL data to this application (U.S. default=blank). Choose the language driver that uses the same character set in which the server passes data to this application, and a collation sequence that matches your server's collation sequence.

•	Schema Cache Size:  The number of SQL tables whose schema information will be cached. Can be any whole number from 0 to 32 (default=8).

•	SQLqry Mode:  SQL query mode; the method for handling queries to SQL data. Can be NULL (blank setting, which is the default), SERVER, or LOCAL.

•	Date Mode:  The format in which the Informix driver sends dates to the server. Must match the Informix server's DBDATE environment variable. Can be either 0 (MDY; default) or 1 (DMY).

Password

Type the password needed to connect to the server. Asterisks (*) represent the characters you type.

Show options

•	Show Public Aliases Only:  Click this button if you want to see only public aliases.

•	Show Project Aliases Only:  Click this button if you want to see only project aliases.

•	Show All Aliases:  Click this button if you want to see both public and project aliases.

Connect

Click the Connect button to log on to the server named in the Server Name text box, using the current User Name and Password. Depending on your server, this may take a while.

Disconnect

Click the Disconnect button to log off the server named in the Server Name text box.

New

Click the New button to open an empty box where you can type in a new alias name. After you click the New button, it becomes the Keep New button.

Keep New

Click the Keep New button if you want this to be a temporary alias, existing only until you exit. Then click the OK button to close the Alias Manager dialog box.

Clicking the Keep New button does not close the dialog box. It lets you save the alias temporarily when you click the OK button. If you click the Cancel button, whatever you saved with the Keep New button is deleted. Click the Keep New button if you are creating several aliases and do not want to re-open this dialog box to create each one. Then clicking the Save As button will save them all.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want your new alias to be permanent [image] usable any time you use this application. You will see the Save File As dialog box. Unless you choose a different configuration file, this application stores saved aliases in your default BDE configuration file.

The message, "File already exists. Overwrite?", appears when you click the Save As button and choose a filename. Click the Yes button. This application appends the aliases to the file; it does not replace the ones already there.

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current application session.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with the Save As button remain.

 Related Topics


Alias Manager dialog box (Oracle SQL Link)

Use the Alias Manager dialog box to create or modify aliases for local, network, or remote database directories. You can also choose to connect or disconnect from a server. Most of the options described below are available only if you have installed a Borland SQL Link driver and have chosen the ORACLE option from the Driver Type list.

The settings in this dialog box reflect the information stored in your BDE configuration file.

Dialog box options

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use BDE. Disable this check box to make an alias a project alias [image] available only to applications in the current directory.

Database Alias

Choose an alias from the list. To create a new Oracle alias, click the New button, then choose the ORACLE driver type, then type the new alias name.

Alias configuration options

•	Driver Type:  To create an Oracle alias, choose ORACLE.

•	Server Name:  The name of the target Oracle server.

•	User Name:  The default name for accessing the Oracle server.

•	Net Protocol:  Network transport used to communicate with the database server.

•	Open Mode:  The mode in which SQL Link opens the Oracle database. Can be READ/WRITE (default) or READ ONLY.

•	Schema Cache Size:  The number of SQL tables whose schema information will be cached. Can be any whole number from 0 to 32 (default=8).

•	Langdriver:  The language driver used to display SQL data to this application (U.S. default=blank). Choose the language driver that uses the same character set in which the server passes data to this application, and a collation sequence that matches your server's collation sequence.

•	SQLqrymode:  SQL query mode; the method for handling queries to SQL data. Can be NULL (blank setting, which is the default), SERVER, or LOCAL.

•	SQLpassthru Mode:  SQL pass-through mode; specifies whether or not application users can access the Oracle SQL server via both QBE and the SQL Editor (pass-through SQL) in the same alias connection. Can be NOT SHARED, SHARED AUTOCOMMIT (default), or SHARED NO AUTOCOMMIT.

Password

Type the password needed to connect to the server. Asterisks (*) represent the characters you type.

Show options

•	Show Public Aliases Only:  Click this button if you want to see only public aliases.

•	Show Project Aliases Only:  Click this button if you want to see only project aliases.

•	Show All Aliases:  Click this button if you want to see both public and project aliases.

Connect

Click the Connect button to log on to the server named in the Server Name text box, using the current User Name and Password. Depending on your server, this may take a while.

Disconnect

Click the Disconnect button to log off the server named in the Server Name text box.

New

Click the New button to open an empty box where you can type in a new alias name. After you click the New button, it becomes the Keep New button.

Keep New

Click the Keep New button if you want this to be a temporary alias, existing only until you exit. Then click the OK button to close the Alias Manager dialog box.

Clicking the Keep New button does not close the dialog box. It lets you save the alias temporarily when you click the OK button. If you click the Cancel button, whatever you saved with the Keep New button is deleted.

Click the Keep New button if you are creating several aliases and do not want to re-open this dialog box to create each one. Then clicking the Save As button will save them all.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want your new alias to be permanent [image] usable any time you use this application. You will see the Save File As dialog box. Unless you choose a different configuration file, this application stores saved aliases in your default BDE configuration file.

The message, "File already exists. Overwrite?", appears when you click the Save As button and choose a filename. Click the Yes button. This application appends the aliases to the file; it does not replace the ones already there.

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current application session.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with the Save As button remain.

 Related Topics


Alias Manager dialog box (Sybase SQL Link)

Use the Alias Manager dialog box to create or modify aliases for local, network, or remote database directories. You can also choose to connect or disconnect from a server. Most of the options described below are available only if you have installed a Borland SQL Link driver and have chosen the SYBASE option from the Driver Type list.

The settings in this dialog box reflect the information stored in your BDE configuration file.

Dialog box options

Public Alias

Enable this check box to make an alias a public alias [image] available from all applications that use BDE. Disable this check box to make an alias a project alias [image] available only to applications in the current directory.

Database Alias

Choose an alias from the list. To create a new Sybase or Microsoft SQL Server alias, click New, then choose the SYBASE driver type, then type the new alias name.

Alias configuration options

•	Driver Type:  To create a Sybase or Microsoft SQL Server database alias, choose SYBASE from the list.

•	Database:  The name of the target database.

•	Server Name:  The name of the target SQL Server.

•	User Name:  The default name for accessing the SQL Server.

•	Open Mode:  The mode in which SQL Link opens the Informix database. Can be READ/WRITE (default) or READ ONLY.

•	Schema Cache Size:  The number of SQL tables whose schema information will be cached. Can be any whole number from 0 to 32 (default=8).

•	BLOB Edit Logging:  Enables or disables the logging of BLOB edits. Can be TRUE (default) or FALSE. When FALSE, this option helps minimize BLOB space requirements and increase performance.

•	Langdriver:  The language driver used to display SQL data to this application (U.S. default=blank). Choose the language driver that uses the same character set in which the server passes data to this application, and a collation sequence that matches your server's collation sequence.

•	SQLqry Mode:  SQL query mode; the method for handling queries to SQL data. Can be NULL (blank setting, which is the default), SERVER, or LOCAL.

Password

Type the password needed to connect to the server. Asterisks (*) represent the characters you type.

Show options

•	Show Public Aliases Only:  Click this button if you want to see only public aliases.

•	Show Project Aliases Only:  Click this button if you want to see only project aliases.

•	Show All Aliases:  Click this button if you want to see both public and project aliases.

Connect

Click the Connect button to log on to the server named in the Server Name text box, using the current User Name and Password. Depending on your server, this may take a while.

Disconnect

Click the Disconnect button to log off the server named in the Server Name text box.

New

Click the New button to open an empty box where you can type in a new alias name. After you click the New button, it becomes the Keep New button.

Keep New

Click the Keep New button if you want this to be a temporary alias, existing only until you exit. Then click the OK button to close the Alias Manager dialog box.

Clicking the Keep New button does not close the dialog box. It lets you save the alias temporarily when you click the OK button. If you click the Cancel button, whatever you saved with the Keep New button is deleted. Click the Keep New button if you are creating several aliases and do not want to re-open this dialog box to create each one. Then clicking the Save As button will save them all.

Remove

Click the Remove button to tag the selected alias for removal. The alias is removed when you exit the box or when you click the Save As button and overwrite the current file containing the alias.

Save As

Click the Save As button if you want your new alias to be permanent [image] usable any time you use this application. You will see the Save File As dialog box. Unless you choose a different configuration file, this application stores saved aliases in your default BDE configuration file.

The message, "File already exists. Overwrite?", appears when you click the Save As button and choose a filename. Click the Yes button. This application appends the aliases to the file; it does not replace the ones already there.

OK

Click the OK button if you want to save any changes you have made in the dialog box, but only for the current application session.

Cancel

Cancels only the changes in type-in boxes. Any changes you made with the Save As button remain.

 Related Topics


LANGDRIVER settings

Long driver name	Short name	Character set	Collation seq.

Paradox 'ascii'	ascii	DOS code page 437	Binary

Paradox 'intl'	intl	DOS code page 437	Paradox 'intl'

Paradox 'intl' 850	intl850	DOS code page 850	Paradox 'intl' 850

Paradox 'nordan'	nordan	DOS code page 865	Paradox 'nordan'

Paradox 'nordan40'	nordan40	DOS code page 865	Paradox 'nordan40'

Paradox 'swedfin'	swedfin	DOS code page 437	Paradox 'swedfin'

Paradox ANSI INTL	ANSIINTL	ISO8859.1 (ANSI)	Paradox 'intl'

Paradox ESP 437	SPANISH	DOS code page 437	Paradox ESP 437

Paradox ISL 861	iceland	DOS code page 861	Paradox ISL 861

Pdox ANSI INTL850	ANSII850	ISO8859.1 (ANSI)	Pdox 'intl' 850

Pdox ANSI NORDAN40	ANSINOR4	ISO 8859.1 (ANSI)	Pdox 'nordan40'

Pdox ANSI SWEDFIN	ANSISWFIN	ISO 8859.1 (ANSI)	Pdox 'swedfin'

Pdox ESP ANSI	ANSISPAN	ISO 8859.1 (ANSI)	PDox ESP437

SQL Link ROMAN8	BLROM800	ROMAN8	Binary

Borland ENU Latin-1	BLLT1US0	ISO 8859.1 (ANSI)	Binary


SQLQRYMODE settings

Setting	Meaning

NULL (blank setting)	Server-local mode (default). Query goes first to the server. If the server is unable to perform the query, the query is performed at the desktop.

SERVER	Server-only mode. Query is sent to the server. If the server is unable to perform the query, the query fails.

LOCAL	Local-only mode. Query is always performed at the desktop.


SQLPASSTHRU MODE settings

•	NOT SHARED
(blank setting) (Default for InterBase, Oracle, Sybase)
Pass-through SQL and non-pass-through SQL do NOT share the same connection.

•	SHARED AUTOCOMMIT
(Default for Informix)
Pass-through SQL and non-pass-through SQL will share the same connection, and (as long as you are not in an explicit client transaction or batch mode) pass-through SQL will be automatically committed.

•	SHARED NOAUTOCOMMIT
Pass-through SQL and non-pass-through SQL share the same connection, but pass-through statements will not be automatically committed.


NET PROTOCOL settings

Value	Description

3270	IBM 3270 protocol

APPC	IBM APPC LU 6.2 protocol

ASYNC	Asynchronous (dial-up) access protocol

DECNET	Digital Equipment Corporation DECnet protocol

NAMED PIPES	Named Pipes protocol, as used by OS/2

NETBIOS	NetBios protocol, as used by LAN Manager and other PC LANs

SPX/IPX	SPX/IPX protocol, as used by Novell NetWare

TCP/IP	Transport Control Protocol/ Internet Protocol, as used by Unix and VAX workstations

VINES	Banyan VINES protocol


Database Information dialog box

Use the Database Information dialog box to view or modify the connection parameters you set for accessing remote servers. You need to modify these parameters when

•	you connect to a server for the first time in a session

•	you change connections to access data in a different location

This application displays the parameter settings you entered in the Alias Manager dialog box. In most cases, all you need to add or modify is the user name and password.

Dialog box options

Database Alias

This application displays the alias name you entered in the Alias Manager dialog box, or specified when you tried an operation against a remote database.

Server Name

This application displays the full path of the database specified in the alias. If necessary, type a new path for the database, including the name of the server.

User Name

Type the name of the user recognized by the database server.

 Related Topics


Default BDE configuration file

The BDE configuration file used at application startup. The default configuration file is listed in the Windows registry.

The BDE configuration file that comes with this application is called IDAPI32.CFG. However, you can give your BDE configuration file any name as long as it ends in ".CFG" and is no more than 12 characters long.


ODBC driver connection

A connection from your BDE application to an ODBC driver. The connection requires your BDE application, a vendor-supplied ODBC driver, the Microsoft ODBC Driver Manager, a BDE alias on the workstation side, and an ODBC data source on the server side.

Once you create an ODBC driver connection, it appears on the list of available drivers in the BDE Administrator. This enables you to set up an alias for the target ODBC data source and connect to it through your BDE application.


Welcome to Paradox 9 Runtime


Overview: Welcome to Paradox 9 Runtime
Welcome to Paradox 9 Runtime

Paradox Runtime lets you view and edit database records that are stored in underlying database files. These database files are called tables. You can do the following in Paradox Runtime:

•	View, enter and edit data using forms.

•	View and print data using reports.

•	Perform automated tasks using scripts.

 More Detailed Information


Exploring the work area


Overview: Exploring the work area
Exploring the work area

The desktop is the first thing you see when you launch Paradox Runtime. It is the primary workspace. From the desktop, you can

•	manage files

•	define defaults and preferences

•	control all Paradox Runtime objects

•	set object properties

Many of the preferences you define remain in effect for a full Paradox Runtime session from the time you open Paradox Runtime until you exit. Paradox Runtime lets you save other preferences permanently.

Parent and child windows

Paradox Runtime objects such as forms, reports, and queries open in their own window. The desktop is the parent window, and all other windows are child windows. For example, forms always appear in a Form window, and queries always appear in a Query window. Each type of window contains specialized commands that apply only to that type of object or document.

Common dialog boxes

A dialog box requests user input or provides information. Many dialog boxes present options to choose among before you can perform an action; others display warnings or error messages.

Application objects

Paradox Runtime uses objects to store, display, and present information. Objects include the following:

•	files on a disk

•	forms and reports

•	scripts

 Related Topics


Overview: Parent and child windows
Parent and child windows

The desktop is the parent window or primary workspace in Paradox Runtime. All other windows are child windows. A child window has some degree of independence, but cannot exist without the desktop. Each type of child window has its own specialized commands and functions. All commands and functions of the desktop remain available in child windows.

The following are the child windows available on the desktop:

•	Form window

•	Report window

•	Project Viewer

 Related Topics


Overview: Common dialog boxes
Common dialog boxes

Many dialog boxes in Paradox Runtime have common features. These include a file list box, a Save In or Look In list box, a Files Of Type list box, and an Alias list box. Dialog boxes that you use to open and save files are good examples of this kind of dialog box.

Use the icons beside the Save In or Look In list to navigate, create a folder, or change the display of folders.

 Related Topics


Overview: Application objects
Application objects

Each window title bar is identified by the icon corresponding to its object type. These are the same icons that appear in the Project Viewer to represent form, report, and script objects.

Click an icon or window name below for a brief description.

	Form window
	Report window
	Project Viewer
 Related Topics


The Project Viewer


Overview: The Project Viewer
The Project Viewer

The Project Viewer provides a convenient way to work with your files. From the Project Viewer, you can right-click object file icons to view their menus, or double-click to perform the default action (the first item on the menu).

The Desktop toolbar is the default toolbar when using the Project Viewer.

 Related Topics


Using the Project Viewer

The Project Viewer lists objects in your working and private directories. It gives you easy access to these objects.

To open the Project Viewer

•	Click Tools, Project Viewer.

 Tip

•	You can also click the Project Viewer button on the toolbar to open the Project Viewer.

To use the Project Viewer

1.	Click an icon on the left panel to choose the type of object you want to see.

2.	Right-click an object name on the right panel and to see its menu, and then choose a command. (Double-clicking an object executes the first command on the menu, which is usually opening the object).

 Notes

•	If you are viewing all files, you will see that some files do not have menus. This is because they are created automatically along with an application object, and they are modified automatically when you modify the object. You cannot open or modify these files manually using Paradox Runtime.

•	See Directories and aliases for more information about working and private directories.

 Related Topics


Changing your working directory from the Project Viewer

Your working directory is the default data directory Paradox Runtime uses to open and save files. You can change your working directory from the Project Viewer. When you change your working directory, Paradox Runtime will close any open files from the old working directory. For more information, see Changing your working directory.

To change your working directory from the Project Viewer

•	Click the Browse button to select a directory.

 Related Topics


Selecting objects and navigating records


Overview: Selecting objects and navigating records
Selecting objects and navigating records

Paradox Runtime offers toolbar buttons and menu items that make object selection and table navigation fast and easy.

 Related Topics


Selecting objects with the mouse

You can use the mouse to select fields and text in forms and reports.

To select	Do this

A field	Point and click.

Specific text	Point and click, then click to place the insertion point and drag to select the text.

For information on selecting more than one item at a time in lists, see Selecting items from lists.

 Related Topics


Selecting items from lists

In some lists, you can select more than one item at a time.

To select	Do this

A single item	Click the item.

A contiguous block	Click the first item, then SHIFT + click the last item.

Scattered items	CTRL + click (hold down CTRL while you click the items).

 Related Topics


Navigating through records

You can use keys and the mouse to navigate through records in Paradox Runtime. A set of records is the number of records currently visible on screen.

Example of toolbar navigational buttons

Moves to the first record in the selected field.

Moves to the previous set in the selected field.

Moves to the previous record in the selected field.

Moves to the next record in the selected field.

Moves to the next set of records in the selected field.

Moves to the last record in the selected field.

 Tip

•	You can also use the Record menu for the above operations.

Keyboard shortcuts

There are many keyboard shortcuts to simplify navigation and editing. These topics list many of them:

•	Data entry shortcuts

•	Navigation and selection keys

•	Edit mode keys

For a complete list, see Keyboard shortcuts.

 Notes

•	In a form, navigation buttons move through records. Commands on the Page menu move through pages.

•	In a report, both navigation buttons and commands on the Page menu move through pages.

 Related Topics


Application preferences


Overview: Application preferences
Application preferences

In Paradox Runtime, preferences are global settings that affect the overall performance of the application and the default settings or values that appear for many of its operations.

The Preferences dialog box contains the following pages:

•	General

•	Database

•	BDE

 Related Topics


Viewing and changing application, desktop, and system settings

You can view or change information about your system and desktop.

To view or change application settings

•	Click Tools, Settings, Preferences.


Toolbars


Overview: Toolbars
Toolbars

Below the menu bar is a collection of buttons and tools called the toolbar. The buttons available on the toolbar depend on the toolbar type and the kind of object active on the desktop. For example, if a form is active, the toolbar buttons will be those that help you perform tasks with a form. Many toolbar buttons provide quick equivalents to menu commands or keystrokes. Others provide handy ways for you to navigate through your data.

To get quick help on what a tool or button does, point to it with the mouse. The application displays a description of the button next to it.

You can display more than one toolbar on the desktop. Toolbars can be moved away from their standard position near the top of the desktop window. You can dock them at either side or the bottom of the desktop, or let them float undocked. For more information, see Displaying, hiding and moving a toolbar.

The Standard toolbar

This is the default toolbar that usually appears immediately below the menus. This toolbar displays buttons and tools which are shortcuts to common menu commands such as cut, copy, paste, print, open, and save.

Other toolbars

As you work with different windows, a toolbar appears to provide buttons that match the active window. There are three types of toolbars:

•	Desktop toolbar

•	Form toolbar

•	Report toolbar

 More Detailed Information
 Related Topics


Overview: Desktop toolbar
Desktop toolbar

The following buttons appear on the toolbar when the Desktop is empty or the Project Viewer window is active. Click a button below for more information. Use the toolbar buttons to open application objects.

Open
Open Form
Open Report
Open Script
Like the menus, the toolbar changes when the active window changes. Each window has a unique toolbar.

 More Detailed Information
 Related Topics


Overview: Form toolbar
Form toolbar

All actions performed by toolbar buttons can be performed through menu commands or shortcut keys. Toolbars are provided to speed up your operations. The toolbar buttons which appear when a Form window is active are listed below. Click a button to see specific information about it.

View Data
Edit Data
Locate
Locate Next
First Record
Previous Record Set
Previous Record
Next Record
Next Record Set
Last Record
Filter
The six buttons that control movement among records (First Record, Previous Record, and so on) are called navigation buttons.

 More Detailed Information
 Related Topics


Overview: Report toolbar
Report toolbar

All actions performed by the toolbar buttons for a Report window can be performed in other ways, either through menu commands or shortcut keys. The toolbar is provided to speed up your operations. Click a button below to see specific information about it.

First Page
Previous Page
Next Page
Last Page
Go to Page
The buttons that control movement among the pages of the report are called navigation buttons.

 More Detailed Information
 Related Topics


Customizing toolbars


Overview: Customizing toolbars
Customizing toolbars

Toolbars let you access features you use frequently. Paradox Runtime comes with several predefined toolbars; however, you can create your own toolbars, move or hide toolbars, and edit toolbars and toolbar buttons.


Creating toolbars

You can create your own toolbars from an assortment of toolbar buttons. Paradox Runtime creates a personal toolbar to which you can drag or copy toolbar buttons. You can also create a separator to categorize buttons.

You can have as many toolbars on the screen as memory and screen area allow.

Paradox Runtime provides descriptions of each button in the form of QuickTips.

To create a toolbar

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Click the New button.

4.	Type a name for the toolbar.

5.	Click OK.

6.	In the Command Categories list, double-click the folder that contains the command control you want to add, then click the command.

The control icon assigned to the command by default is highlighted with a gray border. If no control is highlighted, click any of the available icons.

7.	Drag the control icon from the Buttons box to the toolbar.

 Tips

•	To quickly create a toolbar, right-click a toolbar, click Customize, then drag an icon to any non-toolbar space. A toolbar is created with a default name.

•	To rename your toolbar, see "Editing a toolbar."

To add a separator between buttons

1.	Choose the button to the right of the location where you want to place the separator.

2.	Drag the mouse slowly over the button until the pointer changes to an arrow.

3.	Release the mouse.

 Note

•	Make sure the Customize dialog box is open when you perform the previous procedure. If it is not open, hold down ALT while you create the separator.

To see a description of a button

•	Move the mouse pointer over the button.

 Notes

•	If you exit Paradox Runtime, your toolbar is displayed when you restart Paradox Runtime.

 Related Topics


Displaying, hiding and moving a toolbar

You can display toolbars horizontally or vertically around the Paradox Runtime window, or display a floating toolbar within the spreadsheet window. You can hide any toolbar you don't want displayed.

You can reposition a toolbar by dragging it to the top, bottom, left, or right edge of the application window. If you drag the toolbar away from all edges of the application window, it becomes a floating toolbar.

To display or hide a toolbar

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Do one of the following:

•	Enable the check box for any toolbar you want to display.

•	Disable the check box for any toolbar you want to hide.

To move a toolbar

1.	Point to any of the following locations:

•	an empty area of the toolbar

•	the title bar on a floating toolbar

•	the two vertical gray lines at the beginning of a toolbar

2.	Drag the toolbar to a new position.

 Note

•	To have a toolbar title display on a floating toolbar, right-click a toolbar, and click Toolbars. Click the Options button. Enable the Show Titles on Floating Toolbars check box.

 Tip

•	Right-clicking on any toolbar displays a list of toolbars.

 Related Topics


Editing a toolbar

You can rename or delete a toolbar you have created. Although you can edit standard toolbars, you cannot rename or delete them. If you make changes you no longer want, you can reset the toolbar to its default settings.

To rename a toolbar

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Right-click the toolbar that you want to rename, and click Rename.

4.	Type the new name.

To delete a toolbar

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Choose the toolbar you want to delete.

4.	Click the Delete button.

To reset a standard toolbar to its default settings

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Choose the toolbar to reset.

4.	Click the Reset button.

Any controls, property settings, and link commands that had been changed are restored to their original state.

To change the shape of a floating toolbar

•	Drag the edges of the toolbar.

 Tip

•	You can right-click any toolbar and click Toolbars to display the Toolbars menu.

 Related Topics


Editing toolbar buttons

You can drag buttons from other toolbars, copy buttons, or delete buttons. If a button is dimmed, the button does not function in that window. For example, buttons for customizing charts will not work when a notebook window is active.

To view the available toolbar buttons

1.	Click Tools, Settings, Customize Toolbars.

2.	In the Command Categories box located on the left, click the category for the type of button you want.

Available buttons appear on the right.

To...	Do the following...

Copy a toolbar button	Hold down CTRL + ALT and drag the button to another toolbar.

Move a toolbar button	Drag a button to a new position or toolbar.

Delete a toolbar button	Drag the button off the toolbar.

To resize toolbar buttons

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Click the Options button.

4.	Change the Button and Border settings.

 Related Topics


Editing the graphic or text of a toolbar button

You can change the graphic or text of a toolbar button, or have Paradox Runtime display text under all toolbar buttons.

To display either a graphic or text on a toolbar button

1.	Click Tools, Settings, Customize Toolbars.

2.	Right-click a button on the toolbar, then click Properties.

3.	In the Button Properties dialog box, enable one of the following buttons:

•	Show text [image] to show text instead of an icon.

•	Show image [image] to display an icon on the button.

 Tip

•	While in Customize mode, you can also right-click a toolbar button and toggle between text and graphic.

To change the text of a toolbar button

1.	Follow steps 1 and 2 in the previous procedure.

2.	Enable the Show Text button.

3.	In the Show Text box, type the text you want displayed.

To change the graphic of a toolbar button

1.	Follow steps 1 and 2 in the "To display either a graphic or text on a toolbar button" procedure.

2.	Enable the Show Image button.

3.	Consider the following options:

•	To display colors, click colors from the color palette and apply it to the button image.

•	To display a shadow effect, click the Shadow box and apply it to the button image.

•	To display highlights, click the Highlight box and apply highlights to the button image.

•	To revert to the default background color, click the Face button and apply the color to the button image.

•	To use the text color, click the Text button and apply the color to the button image.

To restore the default button

1.	Follow steps 1 and 2 in the "To display either a graphic or text on a toolbar button" procedure.

2.	Click the Restore Defaults button.

To display text under all toolbar buttons

1.	Click Tools, Settings, Customize Toolbars.

2.	Click the Toolbars button.

3.	Click the Options button.

4.	Enable the Text Below Image button in the Default Button Appearance box.

 Related Topics


Getting Help


Overview: Getting help
Getting help

You can get help using Paradox Runtime by performing one of the following actions:

•	Click Help, Application Basics Help.

•	Click a Help button in a dialog box.

When you click a Help button in a dialog box, Paradox Runtime provides information specific to that dialog box.

Any time the mouse pointer changes to a hand, you can click the text to view more information. Normally, the pointer will change to a hand when placed over text that is underlined with a solid or dotted line. Often, this text is green.

You can also do the following:

•	Highlight a "book" in the Help Contents and click the Print button to print all topics in that sequence.

•	Choose Index to display the Help Index and search for a defined index entry.

•	Choose Contents or Index, then choose Find to search for any text you enter.

For details about using Help in Windows 98 and 95

•	Click the Start button in the lower left corner of the Windows desktop, then choose Help. In the Help Contents, double-click the How To book, then double-click Use Help.

For details about using Help in Windows NT

•	In the Program Manager, click Help, How To Use Help.

 Related Topics


Exiting Paradox Runtime

Exiting Paradox Runtime will close all child windows and the desktop window.

To exit Paradox Runtime

•	Click File, Exit.


Context-sensitive help


Toolbar dialog box/Toolbar Customization dialog box


Click to create a new toolbar. The new toolbar is added at the bottom of the list and a blinking cursor appears next to its check box so that you can type a name for it.


Use this button to reset the toolbar you have selected to its default configuration. When you select a custom toolbar that you have created yourself, use this button to delete it.


Opens the Customize dialog box.


Click to set the options for toolbars, including button size, border, and appearance.


Lists the available toolbars in Paradox.


Adjust the slider to change the size of toolbar buttons; the options are small, medium, and large.


Adjust the slider to change the width of the border that surrounds the buttons in toolbars.


Enable to have only the button image appear in the toolbar.


Enable to have only the name of the button appear in the toolbar.


Enable to have the name of the button appear beneath the button image in the toolbar.


Enable to have the toolbar name appear in the Title Bar when the toolbar is floating on screen.


Use this section to set custom options for the toolbars.


Displays the available commands. Double-click a command category to open it.


Click the toolbar button to open the Toolbars dialog box, where you can display other Toolbars instead of, or in addition to, the standard Toolbar for each Paradox window. You can also add or delete custom toolbars.


Displays the command buttons for the current command category. Click a button to see its description, or drag it to add it to any toolbar on the screen.


Choose the Property Bar you want to customize from this list box. Drag the appropriate toolbar item icon to the Property Bar on your screen to add it to that Property Bar.


Gives a short description of the selected toolbar command.


About dialog box


Displays the trademarking, copyright, and other information for Paradox. Hold down the left mouse button to stop the scrolling screen at a particular point. Click and drag to pan across the screen.


Opens the License dialog box, which lets you view the license agreement for the application.


Opens the Copyright dialog box, which lets you view and print the application's copyright information.


Opens the System Info dialog box, which displays detailed information about any of the following five categories: system, display, printing, Corel .EXE and .DLL files, and system .DLL files.


Opens the Serial Number/PIN dialog box, which lets you edit the serial number and personal identification number for your version of the application.


Displays your personal registration information, serial number, and identification number.


Displays the serial number located on your proof of purchase.


Displays the personal identification number (PIN). This number is not needed to run the software but is necessary to receive customer support.


Displays the system information for the chosen category.


Provides a list of system information categories, including: System, Display, Printing, Corel EXEs and DLLs, and System DLLs.


Saves all system information as SYSINFO.TXT. Once saved, a message box appears informing you of the location of the saved file.


Displays copyright and licensing information regarding this product.


Open the Print dialog box, which allows you to print your work, modify print options, and change the printer and its properties.


Forms


Overview: Forms
Forms

Forms let you see and work with data from tables one record at a time, rather than with an entire table full of data. You can work with as much (or as little) of your data as you want in the format you prefer.

The primary difference between forms and reports is that forms are editing tools that let you display and edit data, and reports are viewing tools that let you format and print your data.

 More Detailed Information


Field types


Overview: Field types
Field types

You use forms to enter data into database fields. There are many different field types to hold different kinds of data. Some common field types are the following:

•	Alpha [image] strings containing letters, numbers, special symbols like %, &, #, or =, and other printable ASCII characters

•	Number [image] numeric values for calculation purposes

•	Money [image] currency values

•	Date [image] date values

•	Time [image] time values

The following field types require special methods of data entry:

•	Memo [image] long text strings

•	Formatted Memo [image] long text strings which can be formatted

•	Graphic [image] image files

•	OLE [image] other object files

 Related Topics


Form window settings


Overview: Form window settings
Form window settings

The behavior and display of the Form window can be changed with the form settings for the current window.

Form settings are temporary and are discarded when the document is closed.

•	You can suppress screen flashes as the screen is redrawn each time you move from field to field, or to a new page. For more information, see Customizing your form window.

•	You can specify which rulers to display at the top of the Form window. Rulers are used for placing tabs and formatting text in memo fields. For more information, see Customizing your form window.

 Related Topics


Customizing your form window

The Designer preferences affect the behavior and display of the Form window. For example, sometimes the screen flashes a bit. This is especially noticeable when a form has a dark background. You can eliminate some of this flickering.

The Form window has rulers you can use with the expanded ruler for editing and formatting text fields and formatted memo fields.

To prevent screen flashing

1.	Click Format, Form Setup.

2.	Enable the Flicker-Free Draw check box.

 Note

•	Turning on Flicker-Free Draw eliminates some screen flickering, but it may cause the movement from one field to another to be somewhat slower on some graphic adapters. Experiment with Flicker-Free Draw on and off to see what works best for you. If the screen redrawing is too slow, turn Flicker-Free Draw off.

Displaying or hiding rulers

•	Enable one or both of the following check boxes:

•	Horizontal Ruler [image] enable to display a ruler along the top of the document. This ruler must be checked to set tabs using the expanded ruler.

•	Expanded Ruler [image] enable to display the expanded ruler, an editing tool for use with text fields and formatted memo fields. It is displayed above the horizontal ruler. Use it to adjust margins, tabs, line spacing, and text alignment.

 Note

•	To set tabs, the horizontal ruler must be used with the expanded ruler. Alignment and line spacing controls work with or without the horizontal ruler.


Viewing forms


Overview: Viewing forms
Viewing forms

Paradox Runtime allows you to change the way you view the form window. You can change the magnification of the form either by zooming in or out, or by sizing the form to the screen size.

 Related Topics


Viewing a form

You can change the scale of a form on screen. You can zoom out (decrease the scale and see a larger area) or zoom in (increase the scale and see part of the document up close).

To zoom forms and reports

1.	Click View, Zoom in a Form window.

2.	Choose one of the following:

•	25% or 50% takes a step back from your document

•	200% or 400% takes a closer look at your document

•	Fit Width fits the width to the window

•	Fit Height fits the height to the window

•	Best Fit fits the entire document to the window


Opening and moving around a form


Overview: Opening and moving around a form
Opening and moving around a form

Paradox Runtime provides you with several ways to move around a form.

Using the scroll bars

Use the scroll bars to scroll quickly through the entire form. You cannot use the scrollbars to select objects on the form.

Using the cursor-control keys

The cursor-control keys are the most reliable ways to move among records on a form. PgUp and PgDn scroll to the prior or next record respectively, while the arrow keys move from field to field.

 Tip

•	You can also use the TAB key to move from object to object in the form.

 Related Topics


Opening a form

You can open a form from the desktop or the Project Viewer.

To open a form from the desktop

1.	Click File, Open, Form.

2.	Double-click the form you want to open.

To open a form from the Project Viewer

•	Do one of the following:

•	Double-click the form.

•	Right-click the form, and click View Data.

 Related Topics


Moving among form fields

The TAB key is a reliable and predictable method of navigating in simple forms. As a form becomes more complex, with more objects on it, tab order can become confusing. You can always use the mouse to move quickly to an object.

To move to any field in a form using the mouse

•	Click the field.

To move to any field in a single-table form using the keyboard

•	Do either of the following:

•	Use the Arrow keys.

•	Press TAB or SHIFT + TAB.

 Notes

•	TAB moves from field to field in left-to-right, top-to-bottom order. When you reach the last (most bottom-right) field, pressing TAB returns to the first (most top-left) field on the screen.

•	SHIFT + TAB reverses the tab order. The sequence of movement is right-to-left, bottom-to-top.

•	Using TAB is reliable and predictable in simple forms.

 Related Topics


Moving among form records

There are several methods by which you can move through records in a form.

To move among form records

•	Do one of the following:

•	Click Record, and click Next, Previous, First, Last, Next Set, or Previous Set. Each of these menu choices has an equivalent shortcut key displayed next to it on the menu.

•	Click the navigation buttons on the toolbar.

•	Press the appropriate keyboard key (such as PAGE UP or PAGE DOWN).

 Tip

•	Using the shortcut keys to move among records is the most reliable method. For example, if you are editing a memo field, PAGE UP or PAGE DOWN scrolls the memo instead of changing records.

 Related Topics


Moving among form pages

When working with a multi-page form, you can move to the first, last, next, or previous page.

To move among form pages

1.	Click View, Page.

2.	Choose a page from the Page menu.

To go to a specific page

•	Follow the above procedure, but click View, Page, Go To and type the page number you want.

 Tip

•	Use SHIFT + F4 to move quickly to the next page and SHIFT + F3 to move to the previous page.

 Related Topics


Printing forms


Overview: Printing forms
Printing forms

Although forms are intended for use primarily as screen-based documents, it is possible to print a form.

When you print a form, Paradox Runtime prints only the current record; use a report to print every record. If you open the form as a report and print the report, the pages of your report will be in the format of the form.

 Related Topics


Printing a form

Although forms are designed primarily to be viewed on screen, you can print a form directly from the Form window.

To print a form's records

1.	Click File, Print while viewing a form.

The application displays the Print File dialog box.

2.	If you're printing a multi-page form, specify a page range or select All to print every page.

3.	Type the number you want printed on the first page.

Form pages won't be numbered unless you put the special Page Number, and/or Number of Pages fields on each page.

4.	Specify the number of copies.

5.	Click Print.

When you print a form, Paradox Runtime prints only the current record. A form is not printed for each record in the table. Use a report to print every record.

 Note

•	If the form was designed for the screen, the fonts that appear on the printed output might not match those that you see on screen. This will depend whether your screen fonts and printer fonts match.

•	Enable the Collate Copies check box if you are printing more than one copy and you want the pages collated.


Locking records in a form


Overview: Locking records in a form
Locking records in a form

Locking a record prevents other users from placing a read or write lock on the table. It also prevents users from performing any operations that require a read or exclusive lock. Paradox Runtime automatically locks a record when you start editing it and removes the lock when you leave the record. A message appears in the status bar to inform you of these automatic locks. You can also manually lock a record.

Locking is important if you use Paradox Runtime in a multi-user environment. When you lock a record, other users can view it but can't edit or delete it.

 Related Topics


Locking and unlocking records

With Paradox Runtime, you can maintain data security by putting a lock on a record. You can unlock the record when you want it accessible to other users.

To lock a record

•	Click Record, Lock.

 Notes

•	The desktop status bar tells you when you have locked a record.

•	After you lock a record, the Lock command changes to Unlock. You must unlock the record before another user can edit or delete it.

To unlock a record

•	Click Record, Unlock.

This releases the record for other users' access without moving off it.

 Note

•	Paradox Runtime automatically unlocks a record when you move off it or exit Edit mode.

 Tip

•	If you try to edit a record and discover that it has been locked by another user, you can look at the status bar to see the name of the user who has locked the record.

 Related Topics


Posting a record without unlocking it

Paradox Runtime automatically saves (posts) any changes you make when you leave the record, but it is possible to save your edits before you leave the record.

To post a record without unlocking it

•	Click Record, Post/Keep Locked.

 Note

•	Sometimes Paradox Runtime moves a record to a different location when you post it. This happens if the underlying table is keyed and the new record is not in its correct location in the table. Paradox Runtime moves the record to its correct location. When you choose Record, Post/Keep Locked, the moved record remains selected.

 Related Topics


Toolbar definitions


Opens the Print File dialog box to print the active form or report.


Cuts the selected text or object, removing it and placing it on the Clipboard for future use.


Places a copy of the selected text or object on the Clipboard for future use.


Places the text or object from the Clipboard into the selected field.


Opens the Locate Value dialog box to locate a specific value in a field.


Locates the next occurrence of the value specified in the Locate Value dialog box.


Displays the first record in the database.


Moves to the first record in the previous record set (a specific number of records related to the underlying database).


Displays the last record in the database.


Moves to the first record in the next record set (a specific number of records related to the underlying database).


Displays the next record.


Displays the previous record.


Opens the Filter Tables dialog box to view only specific information from the underlying database.


Switches to Field View to allow editing of text within a field.


Switches from View mode to Edit mode for data entry.


Displays the data on the first page of the active report.


Displays the data on the previous page of the active report.


Displays the data on the next page of the active report.


Displays the data on the last page of the active report.


Displays the Go To Page dialog box to move to a specific page of the active report.


Allows you to view your data but not add new data or change existing data.


Opens a form, report, or script file.


Entering and editing data


Overview: Entering and editing data
Entering and editing data

You can enter data into forms by typing in Edit mode. In addition to typing values in fields, you can cut or copy data from a field and paste into different fields. Or you can paste in data from other applications. Data you cut or copy to the Clipboard remains there until you change it, clear it, or exit Windows. The Clipboard provides temporary storage for data you want to move to a different location.

Edit commands

With a form open in Edit mode, you can use commands on the Edit menu to work with your data.

Guidelines for entering and editing data

Paradox Runtime uses forms for data entry. To enter or edit data, you must put the form into Edit mode. Make your edits in Edit mode and Field View or Persistent Field View. For more information, see the following topics:

•	Edit mode

•	Editing data in Field View

 Note

•	Paradox Runtime automatically saves the data you enter as soon as you leave a record.

 More Detailed Information


Edit mode


Overview: Edit mode
Edit mode

Before you can edit data in a form, you must enter Edit mode. This tells the application that you don't just want to look at the data, you want to change it. The look of the form changes slightly when you enter Edit mode.

If you need to position the insertion point at some particular point within the field (for example, to change a spelling or typing error), enter Field View. For more information, see Editing data in Field View.

 Related Topics


Using Edit mode

Once you're in Edit mode, you can move the insertion point to any of the form's fields and begin typing. This replaces the existing contents of the field.

To enter  Edit mode

•	Do any of the following:

•	Click View, Edit Data.

•	Click the Edit Data toolbar button.

•	Press F9.

 Note

•	Entering data in memo, formatted memo, graphic, and OLE fields can be different. For more information, see Editing special data types.

 Related Topics


Editing data in Field View

In normal Edit mode, whatever you type in a field overwrites the data entered there. To change only part of a field, use Field View.

If you want to move from field to field and remain in Field View, you can enter Persistent Field VIew.

To enter Field View

•	Choose a field and do one of the following:

•	click View, Field View

•	press F2

•	click the selected field again

 Tip

•	In Field View, you can use the Left and Right arrows, as well as BACKSPACE and DELETE.

To exit Field View

•	Do any of the following:

•	click View, Field View

•	press F2

•	select a different field

 Tip

Pressing ENTER, TAB, or ALT with the Arrow keys lets you exit Field View and move to a different field.

To enter and exit Persistent Field View

•	Click View, Persistent Field View.

 Note

•	When editing memo fields and formatted memo fields, you can enter Memo View, which gives you greater use of the keyboard. For more information, see Editing memos and formatted memos.

 Related Topics


Saving data

Paradox Runtime automatically saves the data you enter as soon as you leave a record. Saving a record is also called posting or committing a record.

 Related Topics


Data entry


Overview: Data entry
Data entry

There are shortcuts available to make data entry fast and easy. If you are having trouble entering data, see Problems with data entry.

These topics give additional keyboard shortcuts for entering and editing data:

•	Navigation and selection keys

•	Edit mode keys

 Related Topics


Data entry shortcuts

Use these keyboard shortcuts for faster data entry. You can also use the navigation buttons on the toolbar.

Press...	To...

HOME	Move to the first field of the table, remaining on the selected record

CTRL + HOME	Move to the first field of the first record of the table

END	Move to the last field of the table, remaining on the selected record

CTRL + END	Move to the last field of the last record of the table

CTRL + BACKSPACE	Delete the word to the left of the insertion point. (CTRL + BACKSPACE works only when you are in Field View and do not have text selected.)

ESC	Undo a field edit (you must press ESC before you leave the field!)

SPACEBAR	Enter current date, time, or both in date, time, or timestamp fields. You must press the spacebar for each part of the field's format.

 Related Topics


Problems with data entry

If you experience a problem when you attempt to enter data, the status bar at the bottom of the desktop tells you what the problem is. If you cannot see a status bar, you can maximize the application window.

Several things can prevent you from leaving a field:

•	The field requires that a value be entered, and you have not entered one (for example, maximum or minimum values have been specified, or a picture string has been specified). Type a character or number that satisfies any validity checks defined for that field to get out of the field.

•	The field requires specific values from a lookup table, and you have not provided an acceptable one. To get out of such a field:

•	press CTRL + SPACEBAR to see the lookup table and choose a value from that

•	if the lookup table was defined with Help And Fill enabled, it appears for you to choose from

•	if no lookup table appears, press ESC to undo your entry. Find out what the acceptable values are before you continue.

•	The value you typed violates referential integrity requirements. Press ESC to undo your entry. Find out what the acceptable values are before you continue.

•	The value you typed violates the table's key. Click Edit, Undo to remove the current record.

 Related Topics


Inserting, posting, and deleting records


Overview: Inserting, posting, and deleting records
Inserting, posting, and deleting records

You can insert new blank records or delete existing records from a form.

Inserting and posting records

You can insert a blank record above the selected record. Paradox Runtime saves the new information as soon as you move off the record or click Record, Post/Keep Locked.

Saving a record is often called posting or committing a record. When working in a multi-user environment, other users do not see changes you've made until you've posted them.

When working in a single-record form, inserting a record seems like inserting a blank screen. When you press INSERT or click Record, Insert, the record values appear blank. This is because Paradox Runtime has both inserted and moved to the new blank record.

Deleting records

When using a form with an underlying Paradox table, you cannot retrieve a deleted record. When using a dBASE table, deleting a record does not remove it permanently. You can choose to view deleted records with the Show Deleted command.

 Related Topics


Inserting and posting records

You can insert records in your form. Paradox Runtime saves the changes you make to a record when you exit Edit mode or move to a different record. This is called posting the record.

To insert a record

1.	Click View, Edit Data.

2.	Click Record, Insert.

Paradox Runtime opens a new blank record.

3.	Type data into the fields of the new record.

4.	Move off the record.

To post a record

1.	Follow steps 1 to 3 in the previous procedure.

2.	Click Record, Post/Keep Locked.

 Related Topics


Deleting records

Paradox Runtime lets you delete records in a form.

When using a form with an underlying Paradox table, you cannot retrieve a deleted record. When using a dBASE table, deleting a record does not remove it permanently. You can view deleted dBASE records with the Form, Show Deleted command.

To delete records

1.	Click View, Edit Data.

2.	Choose the record that you want to delete.

3.	Click Record, Delete.

 Related Topics


Cutting, copying, and pasting data


Overview: Cutting, copying, and pasting data
Cutting, copying, and pasting data

In addition to typing values in fields, you can cut or copy data from one field and paste it into a different field or a different application. Data you cut or copy remains on the Windows Clipboard until you change it, clear it, or exit Windows. The Clipboard provides temporary storage for data you want to move to a different location.

Using the Clipboard

You can use the Windows Clipboard to help you enter, copy, and move data. When you cut or copy an object using Edit, Cut or Edit, Copy, Paradox Runtime stores the object on the Clipboard. You can paste these stored objects from the Clipboard back into forms by using Edit, Paste. You can paste into only one field at a time.

You can paste only a valid value into a field. For example, you can't paste a graphic value into an alphanumeric field.

The Clipboard stores only one image at a time. Each time you place an object on the Clipboard, the previous image is discarded.

You can delete objects without storing them on the Clipboard. For more information, see Deleting data.

Undoing Clipboard actions

Edit, Undo does not work for Clipboard actions, like cut, copy, and paste. To undo a paste, delete the pasted object. To undo a cut, paste the object back in. You cannot undo a copy.

Copying to a file

You can use Edit, Copy To to copy field values to external files.

When using a form, you can copy values from any field type to an external file format without using the Export command. In Field View or Memo View, you can copy selected text inside the field.

Paradox Runtime can copy graphic files only to the .BMP file format.

When you work with a binary field in a Table window, you can use Copy To to copy binary field values to an external file format. You'll see the Copy To File dialog box, which looks like the Copy To Graphic File dialog box except the Type list shows <Files>, and the file extension you use is unrestricted.

Pasting from a file

You can use Edit, Paste From to paste values from external files into fields in Paradox Runtime. (Note: You can use Edit, Insert Object to paste files into OLE fields.)

When you click Edit, Paste From (you must be in Edit mode), you'll see the Paste From dialog box. You can also open the Paste From dialog box by right-clicking a memo or formatted memo field (you must be in Memo View), graphic field, or binary field (in Edit mode).

The exact Paste From dialog box you see depends on the type of field or object you selected.

You can paste text into all field types except graphic and OLE. For more information about pasting from graphic files, see Placing a graphic in a field using Paste From.

When you select the file you want and click the Open button, Paradox Runtime places the contents of the file in the selected field.

 Related Topics


Copying data

You can paste data you have copied to the Clipboard into other fields or other Windows applications.

To copy from a field

1.	Choose a field.

2.	Click Edit, Copy.

 Notes

•	To copy only a portion of a field's data, enter Field View and select the data you want. For information about Field View, see Editing data in Field View.

•	You can copy data to and from files. For instructions, see Copying to a file and Pasting from an external file.

 Related Topics


Deleting data

You can delete any data you've entered in a form.

To delete data and store it on the Clipboard

1.	Choose the data to delete.

2.	Click Edit, Cut.

To delete data without storing it on the Clipboard

1.	Choose the data to delete.

2.	Click Edit, Delete.

 Note

•	In this case, the object is not saved and cannot be pasted from the Clipboard. To retrieve it, click Edit, Undo immediately.

 Related Topics


Pasting data

You can paste data saved on the Clipboard. The contents of the Clipboard are not deleted when you paste, so you can paste as many times as you want.

You can use Edit, Paste From to paste data from external files. For more information, see Pasting from an external file.

To paste data from the Clipboard

1.	Click View, Edit Data.

2.	Choose the field, text, or object to paste into

3.	Click Edit, Paste.

 Related Topics


Copying to a file

You can use Edit, Copy To to copy field values to external files.

To copy a field's value to an external file

1.	Choose the desired field.

2.	Click Edit, Copy To.

The dialog box that appears depends on the type of field from which you are copying.

3.	Type the filename (including full path if necessary) and extension in the Filename box.

4.	Click Save.

Paradox Runtime creates a new file with the name you have specified and places the contents of the selected field in it.

 Related Topics


Copying text to a file

You must be in Field View or Memo View to copy selected text. Paradox Runtime creates a new file with the name you've specified and places the contents of the selected field in it. If you choose an existing filename, Paradox Runtime overwrites the existing file's contents.

Paradox Runtime can copy text data to the .TXT or .PXT file formats.

To copy a field's value to a text file

1.	Choose the desired field.

2.	Enter Field View and Edit mode.

You can select the entire field or any part of it.

3.	Click Edit, Copy To.

4.	In the Copy To File dialog box, do one of the following:

•	Choose the name of an existing file (the contents of the field will overwrite the existing contents of the file)

•	Create a new file by entering the name you want to give the file in the Filename box

By default, Paradox Runtime copies the value to a file in the working directory. To save the file in a different directory, either type the full path in the Filename box or use the Save In list box to choose a different directory.

 Related Topics


Pasting from an external file

You can paste values from non-Paradox files into a Paradox Runtime form. For details about pasting from graphic files, see Placing a graphic in a field using Paste From.

To paste a value from an external file in a field in Paradox Runtime

1.	Choose the field to paste into.

2.	Click View, Edit Data.

3.	Click Edit, Paste From.

The dialog box you see depends on the type of field or object into which you are pasting.

4.	Enter the filename (including full path if necessary) and extension in the Filename box.

 Related Topics


Spell checking your data


Overview: Spell checking your data
Spell checking your data

The writing tools can help you with spelling and correct word usage when your are editing forms in Paradox Runtime. You can use Spell Checker to check form fields for misspelled words and other writing errors, such as improper capitalization or duplicate words. When Spell Checker finds a misspelled word, you can replace it with the suggested word, edit the word manually, skip the word, or add it to the dictionary so that Spell Checker recognizes it as a valid word.

Customizing Spell Checker

You can customize the way that Spell Checker searches for misspelled words or irregular capitalization. For example, you can have Spell Checker beep when it finds a possible spelling error. The options you enable remain effective for all spell checking sessions until you change them.

 Related Topics


To check for spelling errors

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	When Spell Checker stops on a word, click any of the available options, or edit the word in the Replace With box.

 Note

•	The form must be open in Edit Data mode (click View, Edit Data) and a field must be selected before Spell Checker can be launched.

 Related Topics


To replace a misspelled word

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	When Spell Checker stops on a word and suggests replacements, choose the word you want from the Replacements list box.

4.	Click Replace.

 Tip

•	If Spell Checker does not offer replacement words, click Skip, or edit text manually in the Replace With box.

 Related Topics


To skip misspelled words

You can instruct Spell Checker to skip over one or all occurrences of a misspelled word in your forms and tables.

To skip a word once

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	When Spell Checker stops on a word, click Skip Once.

Use this feature when Spell Checker identifies an occurrence of a word that you don't want to change. Spell Checker skips the current occurrence, but it will flag any other occurrences of the same word.

To skip all occurrences of a word when you check the spelling

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	When Spell Checker stops on a word, click Skip All.

Spell Checker ignores the word for the rest of the spell-checking session.

 Related Topics


To edit text manually during a spell-check

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	When Spell Checker stops on a word, click in the Replace With box and type changes to the text.

4.	Click Replace in the Spell Checker window to continue.

 Related Topics


Using custom Spell Checker options

You can set up Spell Checker to scan text for capitalization errors and words with numbers using the Options button.

To check for words that contain both letters and numbers

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	Click the Options button.

4.	Enable the Check Words With Numbers option.

5.	Click Start.

This option may not be available in all languages.

To check for irregular capitalization

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	Click the Options button.

4.	Enable the Check irregular capitalization option.

5.	Click Start.

Use this option to check for words with capital letters that do not begin a word (such as "THe"). This option may not be available in all languages.

To have Spell Checker beep on misspelled words

1.	Click the field you want to check.

2.	Click Tools, Spell Check.

3.	Click the Options button.

4.	Enable the Beep on misspelled option.

5.	Click Start.

 Related Topics


Choosing a Spell Checker language

Every language has specific ways of formatting dates, time, currency symbols, and other text. You can use the Language feature to check for the formatting conventions of another language.

For example, you can have Spell Checker format all the dates in your form or table in the language you choose (such as 12 avril 1996 for French).

You do not need an additional language module to check formatting conventions in another language. However, if you want to check the spelling or grammar of a field in another language, you must purchase an additional language module.

To choose a language

1.	Click Tools, Spell Check.

2.	Click Options, Language.

3.	Choose a language from the list box and click OK.

 Tip

•	If you want this language to be the default language for Spell Checker, enable the Save As Default writing tools language option.

 Related Topics


Adding Words to Spell Checker

When Spell Checker detects an unknown word such as a technical word or proper name, it treats it like a spelling error. You can add such a word to the dictionary so that Spell Checker will recognize it as a valid word.

To add words

1.	Click Tools, Spell Check.

2.	When Spell Checker stops on a word that you want to add to the dictionary, click Add.

Spell checker will no longer recognize the word as being misspelled.

 Related Topics


Finding and replacing data in forms


Overview: Finding and replacing data
Finding and replacing data

Paradox Runtime provides two ways to find and change existing field values quickly in Edit mode or Memo View. You can either use Record, Locate, And Replace to change a field's value or use Edit, Find And Replace to change a string within a memo field or text object. You can use Wildcards if you can't remember the exact spelling or syntax of the data you want to locate, search to find text in memo fields, or search to locate specific records, fields, or values.

 Related Topics


Overview: Wildcards
Wildcards

If you can't remember the exact spelling or syntax of the data you want to locate, you can use wildcards. Wildcards are operators that let you suggest patterns for Paradox Runtime to search.You can use two wildcards in any search string you specify using Find And Replace or Locate And Replace.

Wildcard...	Represents...

@	Any single character

..	Any value

To search for these characters as literals, you must precede them with a backslash ( \ ).

For examples, see Sample search strings with wildcards.

Extended list of wildcards

You can use an extended set of wildcards in a search string when you enable Advanced Pattern Match in the Find And Replace and Locate And Replace dialog boxes.

Wildcard	Represents

@	Any single character

..	Any value

^	Beginning of field

$	End of field

*	Match none or more of the expression before the *

+	Match one or more of the expression before the +

?	Match one or none of the expression before the ?

, 	Match either the characters before or after the vertical bar

[abc]	Match any of the characters contained within the brackets

[^abc]	Match any characters not contained within the brackets

(abc)	A group (a series of literals)

\	Use the following wildcard operator as a regular character

\r	Carriage return

\n	Line feed

\t	Tab

\f	Form feed

For examples, see Sample search strings with wildcards.

 Related Topics


Sample search strings with wildcards

Here are some examples of wildcard characters in a search string and what they find when you enable Advanced Pattern Match in the Find And Replace dialog box.

Search string	Finds

co@l	cool and coal, but not col

s..ch	search, scorch, and such

^any	any only when it occurs at the start of a paragraph (when Case-sensitive is not checked)

able$	able only when it occurs at the end of a paragraph (and is not followed by a period)

(success)	success

[success]	Any s, u, c, or e

[^success]	Any character except s, u, c, or e

a, (an)	Either a or an ("an" is a group here)

hands?	hand and hands (hand with or without the s)

suc?es?	success or Sue (when Case Sensitive is not checked). The ? stands for one "c" or none and one "s" or none.

suc*es*	success or Sue (when Case Sensitive is not checked). The * stands for any number of c's or none at all, and any number of s's or none at all.

suc+es+	success only; the + stands for one or more c's and one or more s's

4\^2	4^2 (read "four squared"). Without the backslash, only paragraphs ending in 4 followed by a paragraph starting with 2 would be found.

apples\\pears	apples\pears

apples\\\\pears	apples\\pears

 Note

•	You can use ?, *, or + if you are not sure how to spell success.

 Related Topics


Overview: Searching for text in memo fields
Searching for text in memo fields

With Paradox Runtime, you can quickly find and replace text in memo fields. If you can't remember the exact spelling or syntax of the data you want to locate, you can use wildcards. For a list of wildcard characters, see Extended list of wildcards.

 Related Topics


Finding and replacing text in memo fields and text objects

A memo field can be very large. You can find and replace text in memo fields in a form.

To find and replace text in a memo field or formatted memo field

1.	Press F9 to enter Edit mode.

2.	 Choose the block of text you want to search in a field.

3.	Click Edit, Find and Replace.

4.	Type the text for which you want the application to search in the Search For box.

5.	Type any replacement text you want in the Replace With box.

6.	Consider the following options:

•	To search for the text exactly as you typed it, including capitalization, enable the Case Sensitive check box.

•	To use @ and .. plus other wildcard characters in the search, enable the Advanced Pattern Match check box.

7.	Click the Find button.

Paradox Runtime finds and highlights the first occurrence of the value you typed in Search For.

8.	Click Replace for the application to both replace the text with the value you entered in Replace With and move to the next occurrence of the value you entered in Search For.

 Note

•	If you select a block of text and then do a find-and-replace operation, the application will find and replace only within the selected block of text. Clicking the Replace All button, however, will search the whole file and not just the selected block of text.

 Tips

•	You can continue to click the Replace button each time Paradox Runtime finds a value you want to replace. If you do not want to replace the value, click the Find button to leave it intact and move to the next occurrence.

•	Click the Replace All button for the application to replace all occurrences of the Search For value with the value you entered in Replace With.

•	You can move the Find and Replace dialog box out of the way by clicking on its title bar and dragging it so you can see the highlighted text as it is found.

 Related Topics


Overview: Locating records, fields, or values
Locating records, fields, or values

Use the Locate commands on the Record menu in a Form window to find specific records and values in you data. You can include wildcards in a search. For information about wildcards, see Wildcards.

 Related Topics


Locating a particular record or value in a form

You can quickly locate a particular record or value in a form. You can also replace one value with another.

To find a particular record or value in a form

1.	Click Record, Locate.

2.	Click one of the following:

•	Record number [image] lets you enter a record number to locate

•	Value [image] lets you specify a field type and value to locate

•	Replace [image] lets you replace the specified value with another value you specify

 Note

•	The record number is assigned automatically and cannot be edited. It shows the record's position in the underlying table.

To search for more occurrences of an item

•	Click Record, Locate Next.

 Related Topics


Locating and replacing values in a field

Paradox Runtime lets you locate and replace field values. You can use wildcards and Advanced Pattern Matching to enhance your search. For more information, see Wildcards.

Paradox Runtime offers a Locate Next feature to quickly display the next occurrence of the record or value you want to locate.

To locate and replace values in a field

1.	Press F9 to enter Edit mode.

2.	Click Record, Locate, Replace.

3.	From the Field list, choose the field that contains the value you want to change.

4.	In the Value box, type the value you want to change.

5.	In the Replace With box, type a replacement value.

6.	Consider the following options:

•	To find text that matches in uppercase and lowercase just as you have typed it, enable the Case-sensitive check box

•	To find text that matches exactly the text you typed, enable the Exact Match button.

•	To use wildcards in your search, enable the @ And .. button.

•	To use the extended list of wildcards in your search, enable the Advanced Pattern Match button.

 Notes

•	Paradox Runtime stops at each field that contains the value you specified and asks if you want to skip it, replace it, or replace all occurrences.

•	If Paradox Runtime cannot find the value you entered, "[Value] was not found" appears on the status bar.

To locate the next record with the defined value

•	Click Record, Locate Next to search for the next occurrence of the value for which you last searched.

Locate Next is unavailable until you click Record, Locate, Value and specify a value.

 Tip

•	You can also use CTRL + A or the Locate Next button on the toolbar:

 Related Topics


Editing special data types


Overview: Editing special data types
Editing special data types

Some field types require special methods of data entry. For example, you must place an actual picture into a graphic field [image] you can't simply type a value. Likewise, certain rules and conventions control the way you can enter and edit data in OLE fields, memo fields, and formatted memo fields.

Paradox Runtime does not display a special window to show you the contents of a memo, formatted memo, graphic, or OLE field. These fields always appear in the size and shape originally specified when the form was created.

 More Detailed Information


Editing memos and formatted memos


Overview: Editing memos and formatted memos
Editing memos and formatted memos

Entering data in memo and formatted memo fields is similar to entering data in alphanumeric fields. However, in memo and formatted memo fields, Paradox Runtime places no limits on the amount of data you can enter.

Memo fields are used for storing large amounts of text data in a database. Formatted memo fields are exactly the same as memo fields except that you can change the font, style, color and size of the text and use tabs and other tools to format the text.

When you're editing a memo or formatted memo field, you can use Memo View, which gives you some word processing capabilities and gives your keyboard greater functionality than Field View.

 Related Topics


Entering Memo View

When you're editing a memo or formatted memo, you can use Memo View, which gives you some word processing capabilities and gives your keyboard greater functionality than Field View. For example,

•	in Field View, ENTER and TAB move you off the field

•	in Memo View, ENTER inserts a line break and TAB inserts a tab character

In Memo View, you can

•	insert a hard carriage return (line break) by pressing ENTER

•	move to the next tab setting by pressing TAB (tabs are set for every half inch)

•	delete text one character at a time to the left of the insertion point by pressing BACKSPACE

•	delete the whole word to the left of the insertion point by pressing CTRL + BACKSPACE

•	delete text one character at a time to the right of the insertion point by pressing DELETE

•	work with selected blocks of text by using Edit menu commands and keystrokes

•	select blocks of text using the mouse by dragging across the text to highlight it

•	select blocks of text using the keyboard by holding SHIFT and using the Arrow keys

For a complete list of keys you can use in Memo View, see Memo View keys.

 Related Topics


Entering Memo View from a form

From a form, you can enter either Field View or Memo View.

If you enter Field View, you can press ENTER or TAB to move to a different field on the form. This method is handy if you want to enter just single paragraphs or make quick edits.

To enter Memo View from a form

•	Click View, Memo View.

To exit Memo View

•	Click View, Memo View again.

When you leave the field, the data at the beginning of the memo is displayed.

 Note

•	You can insert line breaks using ENTER and tabs using TAB. You must exit Memo View to once again use ENTER and TAB to move between fields.

 Related Topics


Entering memo data

You can enter large amounts of text in a memo field.

To enter memo data

1.	Select the memo field.

2.	Click View, Memo View.

3.	Begin typing.

 Related Topics


Exiting Memo View and ending a memo field edit

When you are finished editing a memo field, you must leave Memo View to end your memo field edit and save the changes.

To exit Memo View

•	Click View, Memo View.

Paradox Runtime saves the data in the memo field when you leave Memo View.

 Related Topics


Formatted memo fields


Overview: Formatted memo fields
Formatted memo fields

Formatted memo fields are exactly the same as memo fields except that you can format the font, style, color, and size of the text.

Formatted memo fields can be virtually any length. The size value can be from 1 to 240 characters. Paradox stores the whole memo outside the table (in the .MB file). Paradox retrieves the data from the .MB file as you scroll through the records of the table. The amount of data a memo field contains is limited only by the disk space available on your system.

Memo fields can contain letters, numbers, special symbols (such as %, &, #, and =), or any other printable ASCII character (except null). You can enter line breaks, tabs, and other print control characters in memo fields.

In a form, only a portion of the formatted memo text may appear. If you click View, Memo View, you can view your formatted memo data in full.

For more information about formatting text in a formatted memo field, see the following:

•	Using rulers

•	Placing tabs

•	Using Indent markers

•	Changing margins, alignment, and spacing

•	Changing font attributes

 More Detailed Information
 Related Topics


Using rulers


Overview: Using rulers
Using rulers

Paradox Runtime provides rulers to help you place tabs and set margins in formatted memo text.

The Form window has two optional rulers:

•	the Horizontal ruler [image] used for placing tabs and setting margins in formatted memo fields. For more information, see Using the Horizontal ruler.

•	the Expanded ruler [image] used (in combination with the Horizontal ruler) for formatting text fields and formatted memo fields; the Expanded ruler is displayed above the Horizontal ruler. For more information, see Using the Expanded ruler.

 Related Topics


Using the Horizontal ruler

The Horizontal ruler is used to set tabs, margins, and indents for formatted memo fields. This is done with markers that are set by moving them to the desired location with the mouse.

The Horizontal ruler applies to only one text field at a time. It is displayed regardless of the field selected, but the tab, indent, and margin markers appear only when you place an insertion point in a formatted memo field (not when you select the object as a whole). The markers apply only to the text field in which you are working.

Default tabs in the Horizontal ruler are a half inch apart.

When you select text for formatting, the following guidelines apply:

•	When you select all the text in the field, the settings apply to all the text within the field.

•	When you select specific text or position the insertion point inside the text field without selecting any text, the changes apply only to the paragraph containing the cursor.

 Related Topics


Using the Expanded ruler

The Expanded ruler, used with the Horizontal ruler, is an editing and layout tool for use with text fields and formatted memo fields. Use it to select the type of tab desired, set the line spacing, and choose the text alignment (justification).

The Expanded ruler applies only to the text field in which you are working. It is displayed regardless of the field selected, but the buttons function only when you place the insertion point inside the text field.

When you select text for formatting, the following guidelines apply:

•	When you select all the text in the field, the settings apply to all the text within the field.

•	When you select specific text or position the insertion point inside the text field without selecting any text, the changes apply only to the paragraph containing the cursor.

Expanded ruler buttons

Use the buttons on the Expanded ruler as follows:

Alignment		Choose left, centered, right, or justified to align selected text.
Tabs		Select a Tab button, then click above the object in the ruler to place the tab. Slide a tab to move it, or drag it off the ruler to remove it. Types of tabs available are right, left, center, and decimal.
Line Spacing		Click the line spacing you want for the selected paragraph. Choose 1 for single-spaced text, 2 for double-spaced, and so on.
 Note

•	The Tab and Line Spacing buttons work only inside a formatted memo field. The alignment buttons work in all kinds of text fields.

 Related Topics


Displaying and hiding rulers

You can display rulers on a form. You can also choose to hide rulers.

To set the ruler display for the current document

1.	Click Format, Form Setup.

2.	Enable one or both of the following check boxes:

•	Horizontal Ruler [image] used for placing tabs and setting margins in formatted memo fields

•	Expanded Ruler [image] used (in combination with the Horizontal ruler) for formatting text fields and formatted memo fields

 Note

•	This change affects the current document only. Each time you open another form, you need to select which rulers to display.

 Tip

•	To show or hide the rulers quickly, click View, Rulers.

 Related Topics


Placing tabs


Overview: Placing tabs
Placing tabs

Tabs can be set on the Horizontal ruler; however, to change the type of tab, you need to use the Expanded ruler. For more information on these rulers, see Using rulers.

Setting tabs

Tabs are set in the Form window with the mouse. Tabs can be set only for text inside formatted memo fields. If you are in a regular text field or memo field, the tab and margin markers won't be displayed on the Horizontal ruler.

Moving and deleting tabs

Tabs are moved or deleted with the mouse on the Horizontal ruler. Tabs can be adjusted only inside formatted memo fields. If you are in a regular text field or memo field, the tab and margin markers won't be displayed on the Horizontal ruler. For more information, see Adding tabs.

 Note

•	Default tabs in the Horizontal ruler are a half inch apart.

 Related Topics


Adding tabs

Paradox Runtime offers several types of tabs for formatting memos:

Left:
Text following the tab is pushed right so that its left edge lines up under the tab marker. This is the most typical tab type.

Right:
Text following the tab is pushed left so that its right edge lines up under the tab marker.

Center:
Text following the tab is centered under the tab marker.

Decimal:
Decimal points line up under the tab marker. Use a decimal tab to align columns of figures at the decimal point.

To add a tab marker

1.	Click Format, Form Setup.

2.	Enable both the Horizontal and Expanded Ruler check boxes.

3.	Click inside the text in a formatted memo field.

4.	Click one of the tab buttons on the Expanded ruler to select a tab type.

5.	Click in the tab well to place the tab marker.

Paradox Runtime deletes default tabs to the left of tab markers that you place.

 Note

•	The Tab and Line Spacing buttons work only inside a formatted memo field. The alignment buttons work in all kinds of text fields.

 Related Topics


Moving or deleting tabs

If you don't place any tabs, Paradox Runtime uses default tab settings to place tabs that you can't move or delete. However, you can move and delete the tabs you place. If you delete all the tabs you place, Paradox Runtime returns to its default tab settings.

To move a tab

•	Drag it to a new location.

To delete a tab

•	Drag it away from the ruler.

 Note

•	You cannot move or delete the default tabs with the mouse; however, when you place a tab on the Horizontal ruler, all default tabs to its left are removed. To delete all default tabs, place a tab near the right margin.

 Related Topics


Using indent markers


Overview: Using indent markers
Using indent markers

Use indent markers [image] in the Horizontal ruler to place indents and create hanging paragraphs in selected formatted memo fields. When the indent marker is to the right of the margin marker, the paragraph is indented. When the indent marker is to the left of the margin marker, the paragraph is outdented.

 Related Topics


Adding and moving indent markers

You can indent text in a formatted memo field.

To place an indent marker

1.	Click Format, Form Setup.

2.	Enable the Horizontal Ruler check box.

3.	Click inside the text in a formatted memo field.

4.	Drag the indent marker in the tab well to the location you want.

To move an indent marker

•	Drag it.


Changing margins, alignment, and spacing


Overview: Changing margins, alignment, and spacing
Changing margins, alignment, and spacing

Paradox Runtime lets you change margins, align text differently, and increase or decrease line spacing.

Margins

You can change margins in your formatted memo field.

Text alignment

Paradox Runtime establishes the default margins of text by the location of the text field. By default, text is aligned along the left edge of the field. You can align text at the left or right margin, down the center of the text field, or at both the left and right margins.

Use the alignment [image] buttons in the Expanded ruler to align text fields.

The alignment buttons are left, centered, right, and justified.

Line spacing

Vertical spacing can be set only for text inside formatted memo fields. If you are in a regular text field or memo field, the vertical spacing buttons on the Expanded ruler will not function. The default vertical spacing is single-spaced.

 Related Topics


Changing margins

Change margins for a formatted memo field in the Horizontal ruler or Expanded ruler. The default margins of your text are the left and right borders of the selected text field.

To change a margin

1.	Click Format, Form Setup.

2.	Enable the Horizontal Ruler check box.

3.	Click inside the text in a formatted memo field.

4.	Drag the margin icon [image] to the tab well location you want.

 Related Topics


Changing text alignment

You can change the way text is aligned.

To change the alignment

1.	Click Format, Form Setup.

2.	Enable the Expanded Ruler check box.

3.	Click inside the text in a text field, memo field, or formatted memo field.

4.	Do one of the following:

•	Select typed text, or place the cursor inside the text field or paragraph you want to align, then click the alignment button you want.

•	In a blank field, or on a new line in a memo field, click the alignment button you want before you begin typing. The next text you type will be aligned the way you chose.

 Related Topics


Changing vertical line spacing

There are several types of line spacing available in Paradox Runtime. The Line Spacing Buttons on the Expanded ruler offer five settings:

Choose 1 for single-spaced text, 2 for double-spaced, and so on.

Vertical spacing can be set only for text inside formatted memo fields. If you are in a regular text field or memo field, the vertical spacing buttons on the Expanded ruler will not function. The default vertical spacing is single-spaced.

To change the vertical spacing

1.	Click Format, Form Setup.

2.	Enable the Expanded Ruler check box.

3.	Place the cursor anywhere in a paragraph of a formatted memo field.

3.	On the Expanded ruler, click a line-spacing button.

 Related Topics


Changing font attributes


Overview: Changing font attributes
Changing font attributes

You can change font attributes such as color, size, alignment and spacing in a formatted memo field.

 Related Topics


Changing font attributes

In a formatted memo field, you can change font attributes such as color, size, alignment and spacing.

To change font attributes

1.	Select the text to be formatted.

2.	Right-click, and click Properties.

3.	In the Properties dialog box, choose Font or Text.

4.	Specify your changes.

5.	Click OK to close the Properties dialog box and apply the changes.


Entering graphic data


Overview: Entering graphic data
Entering graphic data

If the form you are using has a graphic field, you can store graphic data in the database. Data in a graphic field can be any picture, or graphic, that is a scanned image, line art, or graphic file created in a paint or draw application.

Paradox Runtime gives you two ways to place a graphic in a field:

•	using the Cut, Copy, and Paste commands

•	using the Paste From command

You cannot edit a graphic in Paradox Runtime; you must edit it in its source application.

 Related Topics


Overview: Using OLE
Using OLE

OLE stands for Object Linking and Embedding. If the form that you are working with contains an OLE field, you can use it to hold virtually any kind of data, from graphics to text to calculations. The advantage of using an OLE field is that once you place a linked OLE value, it maintains a link to its source application. You can always open the source application from the OLE object that you place in a form field. Changes you make to the OLE object are then updated in your form in Paradox Runtime.

Object Linking and Embedding provides a way for a data file from one application (for example, a form in Paradox Runtime) to contain data from another application (for example, a bitmap image). OLE makes it possible for you to view and edit this data in Paradox Runtime without ever leaving it. In this scenario, Paradox Runtime acts as the OLE container and Paintbrush acts as the OLE server.

Paradox Runtime can contain OLE objects but is not a server.

A form which contains an OLE field can be used to store any OLE object. For example, a form might have an OLE field to hold sound (.WAV) files, allowing you to actually store, play, and edit the .WAV files inside a form in Paradox Runtime.

 Note

•	OLE objects can only be stored in OLE fields. If the form you are using does not contain an OLE field, you cannot use OLE objects as data.

 Related Topics


Placing a graphic in a field using Cut and Paste

You can place a graphic in a graphic field on a Paradox Runtime form. Paradox Runtime converts the graphic into the .BMP file format.

To place a graphic in a graphic field from a Windows application that supports the Clipboard

1.	Open the graphic file in its source application.

2.	Select the graphic and cut or copy it to the Clipboard.

3.	Open the desired form.

4.	Press F9 to enter Edit mode.

5.	Select the desired graphic field.

6.	Click Edit, Paste.

 Related Topics


Placing a graphic in a field using Paste From

Paradox Runtime lets you place .BMP, .PCX, .TIF, .GIF, or .EPS graphic files directly into a graphic field without opening the graphic's source application using the Edit, Paste From command.

To place a graphic in a graphic field without using the Clipboard

1.	Open the desired form.

2.	Press F9 to enter Edit mode.

3.	Select the desired graphic field.

4.	Click Edit, Paste From.

5.	Choose the desired graphic file.

6.	Click Open.

 Related Topics


Filtering data


Overview: Filtering data
Filtering data

Sometimes you don't want to see all the data in a database. You can use filters to limit your view to those records whose field values meet the conditions you set.

Filters let you view a subset of records. For example, you might want to see only those customers in North Carolina and California. Or maybe, among those customers, you want to see only those who have placed orders totaling $1,000 or more.

Filters make it possible to view and edit records

•	whose fields meet conditions specified by you

•	in a different order than that specified by the primary index in a keyed underlying table

•	whose fields contain a range of values based on a primary or secondary index of your choice

You can also use a filter to change the order in which records are displayed.

 Related Topics


Overview: Either/or conditions
Either/or conditions

You refer directly to a field by typing a value for it in the Filters on Fields panel of the Filter Tables dialog box.

For example, suppose you have a form that includes the State/Prov field and the Country field. If you type FL in the State/Prov field in the Filter Tables dialog box, Paradox Runtime shows you only those customers in the state of Florida.

Suppose, however, you want to see customers who are in either Florida or the Bahamas. If you type Bahamas in the Country text box (with FL still in the State/Prov text box), you tell Paradox Runtime to show all customers who are in both the state of Florida and the Bahamas. Since no records could meet that condition, Paradox Runtime shows no records in the filtered view.

To tell Paradox Runtime you want to see customers that are located either in Florida or the Bahamas, you must specify OR conditions across fields. You can do this by referring to one field from the text box of another field. So, to see customers who are in either Florida or the Bahamas, you type FL or Country=Bahamas in the State/Prov text box.

 Notes

•	When referring to a field name that contains a space or special characters (those listed in Operator precedence in filters) you must enclose the field name in brackets. For example, the condition City = Venice or [Customer No] = 1560 is valid, but the condition City = Venice or Customer No = 1560 is not. Furthermore, the condition [Sale%] < 20 is valid, but the condition Sale% < 20 is not.

•	It doesn't matter which text box you use to specify filter conditions. You could type Bahamas or [State/Prov] = FL in the Country field. You could even type [State/Prov] = FL or Country = Bahamas in the Name text box (or any other text box).

 Related Topics


Operator precedence in filters

Paradox Runtime evaluates operators in filters in a certain order. In expressions containing more than one operator, the operators are evaluated in the order of precedence shown in the following table:

Precedence	Operator

1	( ) [ ] " "

2	* / %

3	+ -

4	= <> < <= > >=

5	NOT

6	AND

7	OR

8	,

 Note

•	Any expression contained in parentheses is evaluated first, and inner levels of parentheses are evaluated before outer levels. When two or more operators of equal precedence are in a single expression, they are evaluated from left to right.


Filtering fields and forms


Overview: Filtering fields and forms
Filtering fields and forms

You needn't view a form in its entirety all the time. Paradox Runtime lets you pick and choose which records you want to display. You can view the form in a different order by choosing a secondary index view order or you can select particular records by defining one or more fields. You can also set a range of values.

 Related Topics


Filtering a field

Single-field filters are quick and easy to implement. Paradox Runtime limits the view of the records to those with the target value.

To filter a field

1.	Right-click the field you want to filter and click Filter.

2.	In the Filter For box, type the value you want filtered.

 Related Topics


Filtering a form

You can specify conditions for the records you want to filter. All the fields on which you can set a filter are listed in the Filters On Fields panel. For a given record to appear, the conditions specified for each field must all be true for that record. For example, suppose you want to work only with orders that were placed on or after January 1, 1990. You can create a filter on the Orders table by typing >=1/1/90 in the Sale Date text box in the Filters On Fields panel.

To filter your view of data

1.	Click Record, Filter.

The Filter Table dialog box displays, showing all the underlying tables that you can filter.

2.	Choose a table.

3.	Enable the Order By check box to order records according to the selected index.

4.	Select the index by which you want the filter to sort.

An asterisk (*) precedes the primary index. If the table is keyed or has secondary indexes defined, you can choose which index Paradox Runtime uses to sort.

5.	Type the conditions for the records you want to see in the box beside each field listed in the Filters On Fields section.

 Notes

•	You can specify a range of values to view. For more information, see Viewing a range of data. The Range button is available for keyed tables only.

•	You can choose a composite index from the list box under the Order By check box. For more information, see Setting ranges on a composite index.

 Related Topics


Removing a filter

You can remove a filter you've placed on a form.

To remove a filter on a field

1.	Right-click the field and click Filter.

2.	Delete the filter condition text.

When you click the OK button, Paradox Runtime displays all records.

 Related Topics


Viewing ranges of data


Overview: Viewing ranges of data
Viewing ranges of data

You can view ranges of data in your form. Paradox Runtime gives you the option of viewing exact data or data based on partial strings of text you specify.

Specifying an exact match in a range

An exact match on a range displays only those records whose value matches exactly the value you specify.

For example, if the Customer table has an index on the Country field, and you enter Canada as the value to match, Paradox Runtime displays only those records with Canada as their Country value.

Matching partial values of range matches

You can match partial values of range matches on alpha fields. This would allow you to filter all records in a Name field that begin with a range of letters such as C to F.

 Related Topics


Viewing a range of data

You can use a filter to show only those records whose fields contain a range of values based on a primary or secondary index of your choice.

To view a range of data

1.	Click Record, Filter.

2.	Enable the Order By check box.

3.	Select an index from the list below the Order By check box.

For a dBASE table, you can use an expression index. You can set an exact match, inexact match, or partial range on an expression index.

4.	Click the Range button.

The Set Range For Index dialog box appears. The fields that appear, and the order in which those fields appear, are determined by the index you chose, which is shown in the Index field.

5.	In the Set Range for Index dialog box, do one of the following:

•	To specify an exact match, type the value you want to find in the Field Values box. You can only filter records based on the values in the key field(s) of the index you chose in step 4 of the previous procedure.

•	To specify a range of values, enable the Set Range check box.

 Notes

•	You can choose a composite index from the list box under the Order By check box. For more information, see Setting ranges on a composite index.

•	The way you specify the range depends on the type of range you want to set. For more information, see the following topics:

Specifying an exact match in a range.

Example of matching partial strings in a range

 Related Topics


Specifying an exact match in a range

You can choose a range that matches exactly the information you specify.

To specify an exact match in a range

1.	Click Record, Filter.

2.	Enable the Order By check box.

3.	Select an index from the list below the Order By check box.

For a dBASE table, you can use an expression index. You can set an exact match, inexact match, or partial range on an expression index.

4.	Click the Range button.

The Set Range For Index dialog box appears. The fields that appear, and the order in which those fields appear, are determined by the index you chose, which is shown in the Index field.

5.	Place the insertion point in the text box for a field, and enable Set Range.

Another text box appears below the first text box in the Field Values panel.

6.	Enter the low value in the top text box and the high value in the bottom text box to define the range of values to display.

Paradox Runtime does not recognize blanks as part of a match or range specification. A blank matches all records in the field. Blanks are allowed only in the last field of a composite index.

 Note

•	If you enable Set Range without first placing the insertion point in a text box, Paradox Runtime automatically chooses the last field for which you have specified a value.

•	You can choose a composite index from the list box under the Order By check box. For more information, see Setting ranges on a composite index.

 Related Topics


Example of matching partial strings in a range

You can match partial values of range matches on alpha fields.

Suppose you divided responsibility for contacting customers alphabetically among your employees. One employee is responsible for customers whose names begin with the letters A through J. The form in the example below would have an underlying Customer table that contains a Name field.

The Match Partial Strings option is only available if you enable the Set Range check box with an alpha field in the Field Values panel.

To view this range of customers

1.	Click Record, Filter.

2.	Choose an index on the Name field. This sorts the records of the Customer table alphabetically by name.

3.	Click the Range button to open the Set Range For Index dialog box.

4.	Enable the Set Range check box.

5.	Type A in the top text box. This tells Paradox Runtime to begin the range with names that start with A.

6.	Type J in the bottom text box. This tells Paradox Runtime to end the range with the names that start with J.

7.	Enable the Match Partial Strings check box .

This tells the application you do not care what the full field value is, as long as it starts with a letter that falls within the range. Click the OK button to return to the Filter Tables dialog box.

8.	Click OK.

Paradox Runtime displays all records for customers whose names start with A through J.

 Related Topics


Filtering keyed and indexed data


Overview: Filtering keyed and indexed data
Filtering keyed and indexed data

You can filter keyed and indexed data from Paradox, dBASE, and SQL tables used by Paradox Runtime. When you choose a different index using the Table Filters dialog box, the records are sorted by the values of the chosen index. You can

•	set ranges on a composite index

•	view keyed Paradox tables in a different order

•	view indexed dBASE tables in a different order

•	view indexed SQL tables in a different order

 Related Topics


Setting ranges on a composite index

When you choose a composite index from the list box under the Order By field in the Filter Tables dialog box, that index determines the order of the fields shown the Set Range For Index dialog box after you choose Range.

Rules for setting ranges on a composite index

•	When setting ranges on a composite index, you must select a single contiguous set of records on the chosen index.

•	You do not have to specify a range for every field of the index, but you cannot skip over a field. For example, if you have a three-field index, you

•	can set a range on the first field, but not the second or third

•	can set a range on the first and second fields, but not the third

•	cannot set a range on the first and third fields, skipping the second

•	You can specify exact matches and range matches on the same composite index, but you can use a range match only on the last of the fields you define a match for. Using the example of the three-field index, you

•	can set an exact match on the first and second fields, and a range match on the third

•	can set an exact match on the first field, a range match on the second, and leave the third blank

•	can set a range match on the first field, and no range on the second or third

•	cannot set a range match on the first field and an exact match on the second or third

 Note

•	You cannot use a composite index on a dBASE table to set a range. You can, however, use an expression index. You can set an exact match, inexact match, or partial range on an expression index.

 Related Topics


Viewing keyed Paradox tables in a different order

To view data from an underlying keyed Paradox Runtime table in a different order than that specified by the primary index, use a secondary index to change the view order.

To view keyed Paradox tables in a different order

1.	Click Record, Filter.

2.	Enable the Order By check box.

3.	Choose an available index from the list below the Order By check box.

4.	Click OK.

Paradox Runtime creates a view of the table's data sorted by the values in the secondary index you chose.

 Related Topics


Viewing indexed dBASE tables in a different order

You can view data from an underlying indexed dBASE table in different orders by using different indexes such as an .NDX file or a tag from a different .MDX file.

To use a production index

1.	Click Record, Filter.

2.	Enable the Order By check box.

The list box below the Order By check box shows all tags included in the table's production index (the .MDX file that shares the table name).

3.	Select an index from the list.

If you want records to appear in natural order, choose NO INDEX.

To use an index other than the production index

1.	Click Record, Filter.

2.	Type the name of the index (including its .MDX or .NDX extension) in the dBASE Index File field.

 Note

•	When you change the view order of a dBASE table, the record numbers (which show the true location of each record in the table) are shown out of order.

 Related Topics


Viewing indexed SQL tables in a different order

You can view data from an underlying indexed SQL table in different orders by using different indexes.

To view an indexed SQL table in a different order

1.	Click Record, Filter.

2.	Enable the Order By check box.

3.	Choose an available index from the list below the Order By check box.

4.	Click OK.

Paradox Runtime creates a view of the table's data sorted by the values in the index you chose.

 Related Topics