Edit DBF File
There are the main operations to edit DBF file data:
Cut (Ctrl+X), Copy (Ctrl+C), Copy Record, Clone Record, Paste (Ctrl+V) in DBF file
These are the core clipboard operations:
- Cut - cuts current cell value to clipboard.
- Copy - copies current cell value to clipboard.
- Copy Record - copies current row cell values divided by semicolon to clipboard. For example, in this case:
the clipboard will contains "aaa;bbb;ccc;".
- Clone Record - adds the clone of current row at the end of the current file. For example,
, and after:
- Paste - tries to paste clipboard value to current cell.
For example, if the clipboard contains value "aaa" and the destination field type is Integer, there will raise the "Could not paste the data. Please check the field type" error. However, if the clipboard contains "12/31/2010", the system date format is "dd.mm.yyyy" and destination field type is Date - in this case the source value will be converted to appropriate format and the destination value will turn out as "31.12.2010".
Find and replace in DBF file (Ctrl+F), Find Next (F3)
The dialog box looks like:
- Find Fields- the fields participate in search.
The more fields checked at the list (maximum 26) - the slower is search. Click <All> item to check/uncheck all items.
- Find Text - the text to find. To start search click Find Next button or press Enter or F3 key.
- Replace with - after Replace button click found cell value will be replaced with this text.
- Replace All - click to replace all of found cell values.
- Direction - the search direction.
- Case Sensitive and Partial Compare - the search options.
- Transparency - move the slide block to change Find and Replace dialog box transparency.
If the search was successful, the main form becomes active, but the Find and Replace dialog box stays visible too.
Click Find Next menu item (or press F3) to go to the next occurrence. If Find Text edit is empty - Find Textmenu item is disabled.
Append/Insert Record in DBF file (Insert)
On this command execute a blank record appears between current and previous record. After you specify the data this record will be added to the end of the DBF file (becomes the last record).
Delete Record from DBF file (Ctrl+Del)
Use this command to delete the current record.
The DBF file record removing is not exactly removing - the record just marks as deleted by the internal flag. So actually the record keeps on to exist. Those records are light-red color filled:
To completely remove deleted records use Pack Table command. To restore current record click Recall Record or Recall All to restore all of the deleted records.
Delete All Records command intended to delete all of the records in DBF file (in a similar to the Visual FoxPro's ZAP command).
Delete Field from DBF file
Deletes current field in DBF file. After the operation backup file (BAK-extension) will be created.
Pack DBF Table
Packs current DBF file. All deleted records (light-red colored) will be removed completely. Backup file will NOT be created.
Recall Record (Ctrl+R)
Cancels row removing. So, deleted record will be restored.
Restores all of the deleted records.
If a field value is NULL - the grid shows it as NULL text. This mean, the cell contains nothing, NULL. It is not the same value as empty string in character fields (""), or a zero value in numeric fields (0).
If the field doesn't accept NULL values - the appropriate error box will appear. In this case you can to allow NULLs at the File Structure dialog window, and try again.
Go to Record (Ctrl+G)
In the dialog box appears specify the record number you want to move to and click Go (or press Enter).
Insert Current Filename (Ctrl+F5)
If there is at least one DBF file currently open and the SQL Panel is visible - this command inserts current DBF file's full file name at the SQL Panel cursor position.