Subject Re: [IBO] problems with SQL query
Author Mihai Chezan
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
> Use the FieldByName() method.
> Or, use the ParamByName() method.
> Other methods have you tied into variants instead of the native
> types and this can lead to unusual errors.
>
> Jason Wharton
Thank you.
So to conclude this:
there is no ib_query.Params['param name'] or
ib_query.Fields['column name']
and if you want to use the name of the column to get the TIB_Column
object then you use ib_query.ParamByName('param name') or
ib_query.FieldByName.('coulmn name')
and if you want just the value (as an variant) then you can use
ib_query.ParamValues['param name'] or
ib_query.FieldValues['column name']