Links to execute operations with SQLEdit

Which are links to use to let an SQLEdit elemento execute operations as creating new record, modifying or deleting of an existing one?

What it says to SQLEdit of choosing an operation or another one, is the part of page url which has an SQLEdit element on the right of the question mark symbol. This part is also known as "query string".

We suppose therefore that our page with the SQLEdit element is available to the url

http://www.domain.ext/index.pl/our_page

to execute database operations with our SQLEdit element, this page must be linked with these "query string":

per fare eseguire operazioni sul database al nostro elemento SQLEdit questa pagina va chiamata con le seguenti "query string":

• to add a new record is sufficient to open this url without query string or, use this query string:

...?exec=new

• to modify an existing record you must creare a link with query string formed by the parameter "exec = edit" and by all primary keys of the table with their correct value. If table, as an example, has three primary keys "pk1", "pk2" and "pk3" and you wish to edit the record with "pk1 = v1", "pk2 = v2" e pk3 = v3" you must use this query string:

...?exec=edit&pk1=v1&pk2=v2&pk3=v3

• in analogous way, to delete an item, the link must be formed by the url above and by a query string that has the values of the primary keys of the element to delete and the parameter "exec = delete". By using the example above, the link would be as:

...?exec=delete&pk1=v1&pk2=v2&pk3=v3

• This last link doesn't delete the record directly but asks a confirmation before executing deletion. To delete directly the record without show the confirmation page, you must use this link:

...?exec=deleteConfirm&pk1=v1&pk2=v2&pk3=v3