Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev Return to chapter overview Next

Data input form

Use Data Input Form to add new records or edit existing ones. To invoke the dialog, use the corresponding link from the popup menu or Ctrl+Alt+D shortcut.

 

 

The dialog's fields contain the values of the current grid row. Use the Insert button to enter values of a new record and the Post button to update the current row. The Cancel button reverts all the field values within a form to their initial values (or to the last posted values). The Previous and Next buttons allow you to switch between grid records without closing the dialog.

 

Controls containing values of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly. Controls containing values of required (NOT NULL) columns are marked with a red asterisk.

 

There are possibilities to use lookup editors on working with columns linked with foreign keys, a calendar for timestamp columns and a calculator for decimal ones.



Prev Return to chapter overview Next