Plans for the MS SQL 2012 new sequence feature?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kurtbilde
Posts: 113
Joined: Wed 16 Mar 2005 16:02
Location: Odense, Denmark

Plans for the MS SQL 2012 new sequence feature?

Post by kurtbilde » Sat 31 Mar 2012 08:32

Hi,

Any plans for support for new MS SQL 2012 sequence feature?

-Kurt

AndreyZ

Post by AndreyZ » Mon 02 Apr 2012 14:49

Hello,

If you are using SQL Server 2012, you can work with sequences using SDAC. Here is a code example:

Code: Select all

MSConnection.ExecSQL('CREATE SEQUENCE Seq1 AS INT START WITH 1 INCREMENT BY 1 MAXVALUE 1000 NO CYCLE CACHE 10', []);

kurtbilde
Posts: 113
Joined: Wed 16 Mar 2005 16:02
Location: Odense, Denmark

Post by kurtbilde » Tue 03 Apr 2012 07:44

Sorry, what I meant was in the TMSTable component... For primary key ect. Like TOraTable does

-Kurt

AndreyZ

Post by AndreyZ » Wed 04 Apr 2012 08:40

We will investigate the possibility of adding such functionality. You can also leave your suggestion at our UserVoice page ( http://devart.uservoice.com/forums/1046 ... components ), and if there are many votes for your suggestion, we will implement it faster.

Post Reply