ODAC

TOraDataSet.KeySequence Property

Used to specify the name of a sequence that will be used to fill in a key field after a new record is inserted or posted to a database.

Class

TOraDataSet

Syntax

property KeySequence: string;

Remarks

Use the KeySequence property to specify the name of a sequence that will be used to fill in a key field after a new record is inserted or posted to a database.

Note: KeySequence is used by TOraDataSet only if the KeyFields property is assigned.

Example

Here is an example of PL/SQL block generated by TOraDataSet:

begin
   SELECT DEPT_SEQ.NEXTVAL
   INTO :DEPTNO
   FROM Dual;
   INSERT INTO DEPT
      (DEPTNO, DNAME)
   VALUES
      (:DEPTNO, :DNAME);
end; 

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback