- Click on the “Browse Data” tab, and select the table to edit:
Saving Changes
- Press the “Write Changes” button to save any changes:
Editing Existing Values
- Double-click on the value you want to change
- Edit the value in the top-right panel of the window,
- Press the “Apply” button to make the change
Adding Records
- Press the “Insert New Record” button
- Type new details into the popup windows
You can use the tab key to move from field to field
Bug Alert
DB4SQL does not let you type in numbers that start with a zero, such as a phone number, even into a text field. Type in an “x” instead of the zero, and edit it later.
Boolean Values
- 1 for True
- 0 for False
Dates
- Type as yyyy-mm-dd
eg 2021-04-31
Times
- Type as hh:mm:ss
eg 15:56:00
Deleting Records
- Click anywhere in the row you want to delete
- Press the “Delete current Record” button: