Subject | Re: [IBO] problems with SQL query |
---|---|
Author | Mihai Chezan |
Post date | 2004-07-31T00:00:53Z |
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
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']
wrote:
> Use the FieldByName() method.Thank you.
> 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
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']