hello Mark,

in addition of what Helen said:

> Sql.Add('Select objid from table_accounts where account_name =

:AccName');

> Prepare;
> ParamByName('account_name').AsString:='MYACCOUNT'; <----

if your SQL statement is really as above, maybe:

ParamByName('AccName').AsString:='MYACCOUNT';
^^^^^^^

regards
Salvatore