gASQL manual | ||
---|---|---|
<<< Previous | Data manipulation queries | Next >>> |
As stated in the previous section, the other cases of DML queries (INSERT, UPDATE and DELETE SQL commands) are automatically created from the corresponding SELECT query.
Having defined a SELECT query using the interface described in the previous section, the user can attach one or more 'grids' and 'forms'. The grids and forms depend exclusively on one query (this is why they are listed in the 'Queries' page of the main window, under the query on which they depend).
Wiews and forms can be edited for their properties. The most important property is, in case the query deals with several tables at the same time (using joins), the table which gets modified when data is inserted, updated or deleted.
As shown in the figure above, the dialog is divided in three zones:
The top part allows to give the grid or form a name and some comments, allows the selection of the table which will be modified (tables are ranked by the usefullness of their modification in the considered query, from zero to four stars), and the selection of the kind of presentation (grid or form).
The middle part is where the user will specify which actions will be available in the grid or form (not all actions can be performed in each one, and these ones, even if selected will be removed). The actions appear as buttons at the bottom of the grid or form.
The lower part corresponds to a functionnality not yet implemented: importing a dialog designed with the Glade interface builder, and use it as a base for the form. This will allow the user to have other forms than the ones built by gASQL (which begin to look bad if there are too many fields as they all appear in one column).
The grid view (also called tabular view) is a table displaying the result of a SELECT query. There is one result on each row of the view; this is the usual way of presenting the result of a SELECT query.
A form is the interface used to manipulate one row of a resultset: to insert new data, update or delete some data retrieved by a SELECT query; To use this feature, the user must already have selected a table which is to be modified. I the form, only the fields which belong to that table will appear, not all the fields which are part of the result of the query.
If, for a query, no form has been defined, then a simple default one is dynamically created by gASQL when needed.
<<< Previous | Home | Next >>> |
Data manipulation queries | Up | Plugins usage |