How to get Seed and Increment values of IDENTITY column with ADO ?

How to get Seed and Increment values of IDENTITY column with ADO ?

Post by Andrei Sid » Sat, 29 Nov 2003 17:59:51


I can create new IDENTITY column with SQL command and set seed and increment
values.

ALTER TABLE ...
...< column_definition > ::= { column_name data_type }
| [ IDENTITY [ ( seed , increment )

...



How can I get this values with ADO?

Any help would be appreciated.
 
 
 

How to get Seed and Increment values of IDENTITY column with ADO ?

Post by Mike Colli » Sat, 29 Nov 2003 23:22:02

> I can create new IDENTITY column with SQL command and set seed and
increment


Not ADO, ADOX. Gives the results for me (using JET4, Access in adoanywhere).
I don't have code examples.

(Couldn't see anything in OpenSchema or field dynamic properties to answer
your question).

ADO Browser for viewing ADO properties on your system.
http://www.yqcomputer.com/
https://www.regsoft.net/regsoft/vieworderpage.php3?productid=64520