Subject Re: [IBO] unique fieldvalue?
Author Helen Borrie (TeamIBO)
At 01:11 PM 22-03-02 +0000, you wrote:
>I want to get the information if a field must contain a unique value,
>before doing a post. Is there any property or function, that gives me
>an information if a unique index is set on a field?

Yes: if you enable the SchemaCache, a unique index will appear in
IndexDefs.ibo as

The SchemaCache.IndexDefs property of your connection component is a
stringlist containing these.

See the IBO help for tib_connection.SchemaCacheDir.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at