Subject Re: Getting validation source from a domain
Author Ed Dressel
> I'm dubious about the above - it's part of the Metadata
> components...however, perhaps that's what you're working with. I
> just can't find a public declaration for that function.
>

it's my own function that creates and assigns a TIB_Cursor properties
for easier coding.

> RecordCount is meaningless. An IB_Cursor doesn't know about it. It
> has a single-row buffer.

Ouch... then why is it a public property?

> Not quite this simple. The field you are querying is a blob. It
> happens to contain text but it's a subtype 1 blob. You can assign a
> blob to a TStrings of some sort (stringlist, memo, etc.) and read
> and concatenate its Strings or read its Text.

I realize that but just as a TDataset, the .AsString does work, so did
this as soon as I fixed my code (not seen here).

> Also, you don't need SELECT FIRST in your SQL. A domain has only
> one record in RDB$FIELDS. If you actually want to target the first
> validation rule in the blob, you'll need to process the stringlist
> string-by-string in some fashion.

My thinking was for efficiency--that FB would stop looking as soon as
it found the first item--rather then always searching for a single
domain. Make sense?

Thanks
Ed Dressel