EhLib
|
Keep a list of special parameters and values that is used when performing SQL expressions.
property SpecParams: TStrings;
Property SpecParams kept a list of parameters and values. TXXXDataDriverEh use them when performing SQL expressions. Value of each parameter have to be wrote in the separate line in the format "PARAMETER_NAME =VALUE". Depending on the type of the server (InterBase, Oracle, MSSQL, Informix) SpecParams can contain the following parameters.
On interaction with InterBase server:
"GENERATOR" |
defines a name of the InterBase generator. DataDriver uses this parameter to get current value of generator after the insertion of new record. |
"GENERATOR_FIELD" |
defines a name of the field, which will be assigned current value of the generator after the insertion of new record. |
"AUTO_INCREMENT_FIELD" |
defines a name of the field, which DataDriver will set AutoIncrement type. It is used on making a structure of the internal array of record. |
On interaction with Oracle server:
"SEQUENCE" |
will assign a name of the field Oracle sequences. DataDriver uses this parameter for the reception of the current value of the sequence after the insertion of new record. |
"SEQUENCE_FIELD" |
will assign a name of the field, which will be assigned current value of the sequence after the insertion of new record. |
"AUTO_INCREMENT_FIELD" |
defines a name of the field, which DataDriver will set AutoIncrement type. It is used on making a structure of the internal array of record. |
On interaction with MSSQL server:
"AUTO_INCREMENT_FIELD" |
defines a name of the field, which DataDriver will set AutoIncrement type. It is used on making a structure of the internal array of record. |
On interaction with Informix server:
"AUTO_INCREMENT_FIELD" |
defines a name of the field, which DataDriver will set AutoIncrement type. It is used on making a structure of the internal array of record. |
Example of the list of parameters for InterBase server:
GENERATOR=EMP_NO_GEN
GENERATOR_FIELD=emp_no
AUTO_INCREMENT_FIELD=emp_no
SQL expression for the insertion of record must contain EMP_NO_GEN generator:
INSERT INTO
employee (EMP_NO, FIRST_NAME)
VALUES
(:EMP_NO_GEN, :FIRST_NAME)
Copyright (c) 1998-2013. All rights reserved.
|
What do you think about this topic? Send feedback!
|