2. Data Sources
  3. Data Sources.Updatable Query

Data Sources.Updatable Query

Page settings

Appearance

Here you can select the number of cards to be placed in a row for each of supported screen resolutions. Your current resolution is highlighted in this way.
Cancel Save changes

Updatable queries allow you to create pages with quite complex business logic. For example, you can insert or update records in multiple tables simultaneously transparently for a user, who just fills an Insert/Edit form and presses Submit. To make a query updatable, it is necessary to provide INSERT, UPDATE, and DELETE statements that are executed when a record inserted, updated, and deleted accordingly. Please refer to the manual to learn how to write such statements.

You can find another example of using an updatable query in our NBA Database Demo. Starting from version 18.3 the same technique can be also used for views.

Add new
Refresh
Export
Print
Actions First Name Last Name Birthday Email
Patrick Smith 1997-05-01 ranford_smith@example.com
Timo Wittman 1986-10-12 timo_wittman@example.de
Linda Madson 1960-10-04 linda_madson@example.au
Ben Jones 1999-12-24 ben_jones@example.au
Anne Brown 1980-08-01 anne_brown@example.de
Paul Davis 1977-02-23 paul_davis@example.en
Maria Kerber 1971-04-08 maria_kerber@example.de
Rebecca Taylor 1991-08-15 rebecca_taylor@example.org
Terry Moore 1986-02-20 terry_moore@example.org
James Goodridge 1952-09-02 james_goodridge@example.au

Filter builder