> Got help from a colleague, who told me to write
>
> TIB_ColumnDB_KEY(TIB_DSQL1.Params[1]).Value:=...
>
> rather than
>
> TIB_DSQL1.Params[1].AsVariant:=...
>
> Since the parameter is of type TIB_ColumnText, doing
>
> (TIB_DSQL1.Params[1] as TIB_ColumnDB_KEY).Value fails.
>
> I'm surprised that comparing rdb$db_key to a parameter value
> is more complex than other parameters (and I'm also surprised
> that I cannot remember having read about this on this list
> before - maybe rdb$db_key is less used as a parameter in
> TIB_DSQL than I thought).
>
> But now I'm happy that everything works as I intended,

This suggests there is a bug of some sort.
I'll add this to my list of items to check into.

Jason Wharton



[Non-text portions of this message have been removed]