ZSQLProcessor works similar to ZQuery, but SQL files can be loaded directly and executed immediately. Furthermore, there are some parameters that can not be set in ZQuery.
No assignment found, meaning is for clear all properties user have set.
Connects to ZConnection (= database). Click on> far left to display the ZConnection Properties.
The delimiter (separator) between the SQL commands. Default is a semicolon.
The name of the ZSQLProcessor component.
The identifier before the parameters. Is usually a colon and does not need to be changed.
ParamCheck determines if the Params property is cleared and regenerated if the SQL property of the query changes at runtime. By default, ParamCheck is True. This ensures that the correct number of parameters are generated for the current SQL statement.
When preparing a query, it becomes an array of params for the parameters a dynamic SQL statement. Params is a starting zero-indexed array of TParam objects with one element per parameter of the query; the first parameter is Parms (0), the second params (1), and so on.
For example, suppose a ZQuery component named ZQuery1 has the following SQL statement:
INSERT INTO ADRESS (NAME, SURNAME, ...)
VALUES (:Name, :Surname, ...)
Params kann dann dazu verwendet werden, die Werte der Parameter wie
folgend zu spezifizieren:
ZQuery1.Params(0).AsString := 'Johann';
ZQuery1.Params(1).AsString := 'Maier';
ZQuery1.Params(2).AsString := ...
Mit diesen Anweisungen wird der Wert 'Johann' an den Parameter :Name
gebunden, 'Maier' an den Parameter :Surname.
Contains the text of the SQL statement to be executed by a query component. The property type is TStrings. In contrast to ZQuery, SQL statements with SetTerm are also possible here.
A Lazarus standard property for distinguishing components, etc.
When you call ApplyUdates to write the data to the database, AfterApplyUpdates is called after applying ApplyUpdates, and you can use your own program parts here.
Will be triggered after a cancellation process.
Dispatched after the record has been closed.
Will be triggered after a successful deletion.
Dispatched after the record has been placed in edit mode.
Dispatched after the record has been placed in insert mode.
Dispatched after the table has been opened.
Dispatched after changes have been written to the underlying database.
Will be triggered after a refresh
Dispatched after the cursor has changed position.
Dispatched before ApplyUpdates is called.
Will be triggered before a cancellation process.
Dispatched before the table / query is closed.
Is triggered before a deletion.
Dispatched before putting the record into edit mode.
Dispatched before the record is put into insert mode.
Dispatched before a table / query is opened.
Called before changes are uploaded to the database.
Dispatched before the Refresh command is executed.
Dispatched before the cursor changes position.
Dispatched when ApplyUpdate fails.
Dispatched when calculating computed field values.
Dispatched when a deletion fails.
If an error occurs while editing
Triggered while filtering records.
Dispatched when a new record is created.
Dispatched when a post operation fails.
Dispatched when an update is issued.