>
> I tend to use is ParamByName() almost for everything I do as it is

a bit

> more readable and thus maintainable - even if it is supposed to be

slower.

Norman, thanks for the answers.

I also use ParamByName as well. But in this case I get data
through a XML file, so I have to build the SQL string dynamically,
so I use 'insert into xx values (?,?,?,?...)' and then build the
params as I parse the XML data.

> However, I did a bit of investigating and wandering through the

help file

> and found out that it translates to the following if you want to

use the

> Params property :
>
> IB_Query1->Params->Columns[0]->AsInteger = StrToInt(Edit1-
>Text);

I now use the Columns[xx] field and its good to get confirmation
that this is the right thing to do.

Eric.