Entering data

Paradox lets you enter and edit data in a table. For example, you can search for and replace data, or check data for spelling mistakes.

In this section, you'll learn about

  editing the content of a table field
  
  viewing data entry rules
  
  copying table field data
  
  copying files
  
  locating and replacing table fields, records, and text
  
  checking the spelling for data
  
For more information about editing table data, see Reference: Editing table data.

Editing the content of a table field

To edit table field data, you must enable Edit mode. Once you're in Edit mode, you can edit field data. You can also delete the entire content of a field. You can disable Edit mode when you finish editing the table field.

If you are having difficulty leaving a table field, you may be violating data entry rules. For more information about data entry rules, see "Viewing data entry rules."

To enable or disable Edit mode

1	Open a table.

2	Press F9.

When Edit more is enabled, the word "Edit" appears displays on the Status Bar. When Edit mode is disabled, the word "View" displays on the Status Bar.

Note

  When you initially open a table, View mode is enabled by default.
  
To edit or enter data in a table field

1	In Edit mode, click a table field.

2	Click View  Field view.

The word "Field" displays on the Status Bar.

3	Edit the data, and press ENTER.

You can also	

Cancel the edit	Press ESC before exiting the table field.

Place an insertion point and use ENTER and TAB as characters in memo and formatted memo fields	Click View  Memo view. A bullet displays beside the menu command to indicate that the feature is enabled.

Move to another field while remaining in field view	Click View  Persistent field view. A bullet displays beside the menu command to indicate that the feature is enabled.

To delete the entire content of a table field

1	In Edit mode, click a table field.

2	Press DELETE.

Tip

  You can also delete data in a table field by pressing CTRL + BACKSPACE.
  
Viewing data entry rules

If you can't exit a table field, it may be because a value violates the validity checks, table lookup, referential integrity relationships, or key. Moreover, you may have tried to enter data that is incompatible with the table field type. To find out what type of values you can enter, you can view the field data entry rules to see what rules have been defined for the table field.

To view table field data entry rules

1	In Edit mode, click a table field.

2	Click View  Table structure.

3	Click one of the following tabs:

  Field roster-displays all validity checks
  
  Table lookup-displays table lookup details
  
  Referential integrity-displays parent tables, which allows you to check for valid values for that table field
  
4	Click Done.

Note

  If you experience data entry problems, the status bar displays the problem. If you cannot see the status bar, maximize the Paradox window.
  
Copying table field data

In addition to entering data in table fields, you can copy data from one table field to another or to a different application. You can also copy multiple table fields, columns, rows, and tables to a new table or a different application.

To copy table field data

1	In Edit mode, click a table field.

2	Click Edit, and click one of the following:

  Cut-relocates the data to the windows clipboard
  
  Copy-duplicates the data and places it in the windows clipboard
  
3	Click in the table field where you want to place the data.

4	Click Edit  Paste.

To copy multiple table fields to another application

1	In Edit mode, click a table field.

2	Marquee select the table fields you want to copy.

3	Click Edit, and click one of the following:

  Cut-relocates the data to the windows clipboard
  
  Copy-duplicates the data and places it in the windows clipboard
  
4	Open the application to which you want to copy the fields.

5	Copy the fields.

Note

  You cannot paste multiple table field values into a Paradox table. You can, however, paste them into any other application that accepts them. For example, you can paste them into a Quattro Pro spreadsheet.
  
To copy a column of data

1	In Edit mode, click a table field.

2	Double-click the field's column heading.

3	Click Edit  Copy.

To copy a row of data

1	In Edit mode, click a table field.

2	Double-click an unselected record number.

3	Click Edit, and click one of the following:

  Cut-relocates the data to the windows clipboard
  
  Copy-duplicates the data and places it in the windows clipboard
  
Note

If the record number is selected when you double-click it, you enable field view.

To copy the contents of a table field

1	In Edit mode, click a table field.

2	Click Edit  Select all.

3	Click Edit, and click one of the following:

  Cut-relocates the data to the windows clipboard
  
  Copy-duplicates the data and places it in the windows clipboard
  
Copying files

You can copy the table field data found in graphic, binary, memo, and formatted memo fields to a file without exporting the data. When you copy data to a file, a new file is created. You can paste table field data from the file into Paradox fields and objects. You can paste data from .pxt, .txt, and .rtf files into memo or formatted memo fields.

To copy data to a file

1	In field view, marquee select the table field content.

2	Click Edit  Copy to.

3	Choose the file and folder where you want to copy the data.

4	Type the filename in the File name box.

5	In the Character set area, enable one of the following options:

  Ansi-applies the Ansi charater set, which is the character set supported by Windows
  
  Oem-applies the Original Equipment Manufacturer character set, which is the character set supported by your computer
  
6	Click Save.

Notes

  You must be in field view or memo view to copy data to a file.
  
  Graphic files can be copied only to the .bmp file format.
  
Tip

  You can copy data to a file in memo view.
  
To copy data or text from a file to a table

1	In Edit mode, click a table field.

2	Click in the table field where you want to copy the data.

If you selected a memo or a formatted memo field, click View  Memo view.

3	Click Edit, and click one of the following:

  Paste from-pastes data from an external file into a Paradox field or object
  
  Insert object-pastes files into OLE fields and objects
  
4	Choose the file and folder where the file is stored.

5	Double-click the file.

Locating and replacing table fields, records, and text

When working in tables, you can locate table field data, a value contained within a table field, and a record number.. When locating a value, the search locates the first occurrence of the value that matches your search criteria. You can then move to subsequent matches. If you can't remember the exact spelling or interfere syntax of the data you want to locate, you can use wildcards. Wildcards are operators that let you suggest patterns for the search. For more information about wildcard characters, see "Wildcards for locating values" and "Wildcard characters."

You can also find and replace values or a string within a memo field or text object.

To locate a table field

1	Click Record  Locate  Field.

2	Double-click a table field in the Fields list.

To locate a record number

1	Click Record  Locate  Record number.

2	Type a record number in the Locate record number box.

To locate a value in a table field

1	Click Record  Locate  Value.

2	Choose a table field from the Field list box.

3	Type a value in the Value box.

If you want to locate only values that have the same capitalization as the value you type, enable the Case-sensitive check box.

4	Enable one of the following options:

  Exact match - lets you locate only the values that are identical to the value you typed in the value box
  
  @ and - lets you locate values by using wildcard characters; @ represents any character, and represents any number of characters, including none
  
  Advanced pattern match-lets you locate values by using an extended list of Paradox wildcards, other than @ and .., in a search
  
If you want to search for the next occurrence of the value you are searching for, click Record  Locate next.

Note

  You get improved performance when locating a value if the table field you use has an index. and if the Case setting matches the locate operation.
  
To locate and replace a value in a table field

1	In Edit mode, click a table field.

2	Click Record  Locate  Replace.

3	Choose a table field from the Field list box.

4	Type a value in the Value box.

If you want to locate only values that have the same capitalization as the value you type, enable the Case-sensitive check box.

5	Enable one of the following options:

  Exact match - lets you locate only the values that are identical to the value you typed in the value box
  
  @ and - lets you locate values by using wildcard characters; @ represents any character, and represents any number of characters, including none
  
  Advanced pattern match - lets you locate values by using an extended list of Paradox wildcards, other than @ and .., in a search
  
6	Type the replacement value in the Replace with box.

7	Click OK.

8	In the Found a match dialog box, enable one of the following options:

  Skip the occurrence
  
  Change this occurrence
  
  Change all occurrences
  
To find and replace text

1	In Edit mode, click a memo field.

2	Click View  Memo view.

3	Click Edit  Find and replace.

4	In the Search for box, type the text you want to find.

If you are using wildcards in the search, enable the Advanced pattern match check box.

If you want to search only the values that use the same capitalization, enable the Case-sensitive check box.

5	Type the replacement text in the Replace with box.

6	Click Find.

7	Click Replace.

You can also	

Skip the text string if you do not want to replace it	Click Find next.

Replace all occurrences of the search text	Click Replace all.

Checking the spelling for data

You can check table fields for misspelled words and other writing errors, such as improper capitalization or duplicate words. When a misspelled word is found, you can replace it with the suggested word, skip the word, or add it to the dictionary so that it is recognized it as a valid word.

The spelling checker can be customized to search for words that contain numbers or irregular capitalization. You can customize spelling checker to sound a beep when it finds a possible spelling error. The options you enable, such as customizing the spell checker to sound a beep, remain effective for all spell checking sessions until you change them.

Because every language has specific ways of formatting dates, time, currency symbols, and other text, by choosing a language for the spelling checker, you can check for the formatting conventions of another language. For example, you can display all the dates in a table in French.

To check for spelling errors

1	In Edit mode, click a table field.

2	Click Tools  Spell checker.

3	Choose an item from the Check list box.

4	Click Start.

5	Click one of the following:

  Replace-Replaces the misspelled word with the word found in the Replace with box
  
  Skip once-Ignores the first occurrence of the word, but flags subsequent occurrences
  
  Skip all-Ignores all occurrences of the word for the rest of the spell-checking session
  
You can also	

Replace a misspelled word with a word from the Replacements list	Choose a word from the Replacements list. Click Replace.

Edit the misspelled word while in the Spell Checker	Edit the misspelled word in the Replace with box. Click Replace.

To add a word to the dictionary

1	In Edit mode, click a table field.

2	Click Tools  Spell checker.

3	Click Add.

4	Type a word in the Enter a word to add to the current user word list box.

To customize the spell checker

1	In Edit mode, click a table field.

2	Click Tools  Spell checker.

3	Choose an item from the Check list box.

4	From the Options list box, choose one of the following options:

  Check words with numbers
  
  Check irregular capitalization
  
5	Click Start.

Note

  You may not be able to customize the spelling checker for all languages.
  
To sound a beep on misspelled words

1	In Edit mode, click a table field.

2	Click Tools  Spell checker.

3	Choose an item from the Check list box.

4	Click Options  Beep on misspelled.

5	Click Start.

To choose a language for the spelling checker

1	In Edit mode, click a table field.

2	Click Tools  Spell checker.

3	Choose an item from the Check list box.

4	Click Options  Language.

5	Choose a language from the Current language list.

If you want to set language as the default language for the spelling checker, enable the Save as default writing tools language check box.

Note

  You do not need an additional language module to check formatting conventions of a field in another language. However, if you want to check the spelling or grammar of a table field in another language, you must purchase an additional language module.
  
Reference: Editing table data

The following section contains reference information pertaining to editing table data.

Wildcards for locating values

You can use an extended set of wildcards in a search string when you enable the Advanced pattern match option in the Find and replace and Locate and replace dialog boxes. You can access the Find/Locate and replace dialog box by clicking Edit  Find/Locate and replace.

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 in the brackets

[^abc]	Match any characters not contained in 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

Wildcard characters

Wildcard characters are useful when you want to find data, but you can't remember the location, exact spelling or content of the data. For example, you need to find a customer named Elliott in a customer table, but you are unsure of the spelling. It could be Elliott, Eliot, or Elliot. Paradox allows you search for the name using the following search pattern: El..t. The ".." in the search pattern represents the part of the word you don't know.

Here are some examples of what wildcard characters in search strings will locate and what Paradox finds when you enable the Advanced pattern match option when searching for data.

Search string	Locates

co@l	cool and coal, but not col

s..ch	search, scorch, and such

^any	any, but only when it occurs at the start of a paragraph (when the Case-sensitive check box is disabled)

able$	able, but only when it occurs at the end of a paragraph (and is not followed by a period)

(success)	success

[success]	Any of the characters 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?	Sue when the Case-sensitive check box is disabled. The ? stands for one "c" or none at all, and one "s" or none at all.

suc*es*	success or Sue (when the Case-sensitive check box is disabled). 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

 

Shortcuts for faster data entry

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.

	Note: CTRL + BACKSPACE works only when you are in Field View and do not have text selected.

CTRL + D	Duplicate the information from the record above the selected field to the selected field.

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 SPACEBAR for each part of the field's format.






