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

Subscribe to our news:
Partners
Testimonials
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
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

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