A transaction is a group of SQL statements whose effects are logically
connected. Anything from simple queries to inserting, and deleting operations
can be considered a transaction, as well as more complex groups of several
statements which accomplish a specific task.
A recordset is the result of executing an SQL query.
It is composed of multiple rows, each row having multiple columns. The
columns presented in the query result depend on the column list declared
in the query (they can belong to different tables). The number of rows
and their order depend on the query conditions (WHERE, GROUP BY, HAVING,
ORDER). The recordset acts as a source of dynamic
data
in web applications.
A query is a SQL command that will extract information from the tables
of a database. Essentially, a query is a request for information from
your database.
The InterAKT Dynamic Data tool is a replacement for the standard dynamic
data dialog. It is used in the MX Kollection 3, to provide a unified way
of building mark-ups, or place holders. These are recordset fields, server
or session variables, and other types of dynamic data that are replaced
at runtime by their corresponding values
Use the transaction recordset to preserve submitted values
To allow easier error handling methods, the new Transaction
Engine 3 uses the transactionrecordset
as a means of transferring data.
The transaction recordset goes through three different states:
Initial state - when it is created, it is filled
with some default values. If the page contains an update transaction,
the transaction
recordset will be populated with filtered data from the table to be updated,
based on the record ID passed to the page.
When the page is submitted, the recordset will contain
all data from the form corresponding to the transaction it is registered
to. This way, when error handling is done server side, it can rollback
to the page containing the form, which will be populated with data extracted
from the transaction recordset. The wrong or missing fields will be highlighted,
or if there is a different kind of error (like a duplicate entry, or a
bad password, etc) the error message displayed, but no values will be
lost.
