Editing Records

  • 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: