ADO Schema Rowsets and "identity"

Hi there,
I'm working on an ADO generic application that tries to get as much info as
possible
from the ADO schema rowsets.
Is it possible - somehow - to know if a column is defined with the
"identity" property?
I cannot seem to find it ...
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, mysql & MS SQL
Server
Upscene Productions
http://www.upscene.comHi
I don't know much about ADO schema rowsets
But using T-SQL like
SELECT o.name, c.name FROM syscolumns c, sysobjects o
WHERE c.id = o.id AND (c.status & 128) = 128
or
SELECT COLUMNPROPERTY( OBJECT_ID('authors'),'au_lname',IsIdenti
ty)
you can easily return the info about IDENTITY existence.
"Martijn Tonies" <m.tonies@.upscene-removethis.nospam.com> wrote in message
news:upL2I4ySFHA.3176@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> I'm working on an ADO generic application that tries to get as much info
as
> possible
> from the ADO schema rowsets.
> Is it possible - somehow - to know if a column is defined with the
> "identity" property?
> I cannot seem to find it ...
> --
> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, mysql & MS
SQL
> Server
> Upscene Productions
> http://www.upscene.com
>|||
> I don't know much about ADO schema rowsets
> But using T-SQL like
> SELECT o.name, c.name FROM syscolumns c, sysobjects o
> WHERE c.id = o.id AND (c.status & 128) = 128
> or
> SELECT COLUMNPROPERTY( OBJECT_ID('authors'),'au_lname',IsIdenti
ty)
> you can easily return the info about IDENTITY existence.
Yes, I know ... :-)
But this would defeat part of the "generic-ness" of the application. But if
this
the only way to go, then it's the only way to go ...
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, mysql & MS SQL
Server
Upscene Productions
http://www.upscene.com|||Martin
What is "generic-ness" of the application?
"Martijn Tonies" <m.tonies@.upscene-removethis.nospam.com> wrote in message
news:uC6C$AzSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>
> Yes, I know ... :-)
> But this would defeat part of the "generic-ness" of the application. But
if
> this
> the only way to go, then it's the only way to go ...
>
> --
> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, mysql & MS
SQL
> Server
> Upscene Productions
> http://www.upscene.com
>|||> What is "generic-ness" of the application?
By using the ADO schema rowsets, I'm trying not to use any database engine
specific SQL and let the ADO driver figure it out.
So the application is generic... Or at least, should be.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, mysql & MS SQL
Server
Upscene Productions
http://www.upscene.com