ADO Unique values Field

[Anonymous]

Hi there all,

Does anyone know how to identify if a ADO recordset field has the property "no duplicates allowed"? (or which combination of properties)

I Use the reference activex data objects 2.8 library, with Autocad 2006/2007 and I read the recordset from a MS Access database.

Any help/advise?

A Caddie.

[Anonymous]

Caddie,

With ADO 2.8 you can check to see if your Attributes property exposes the adFldIsNullable enum. If so then you'll know the Field accepts null values.

G'Luck

Bob Coward