EhLib
ContentsIndexHome
PreviousUpNext
TCustomSQLDataDriverEh.SpecParams Property

Keep a list of special parameters and values that is used when performing SQL expressions.

Pascal
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!