What is ANISDB? Is it by any chance a TIBOStoredProc?

Try...

> ANISDB.SQL.CLEAR;
> ANISDB.SQL.ADD('SELECT * FROM ANI WHERE ANI = :ANI');

ANISDB.Prepare;

> anisdb.ParamByName('ANI').asstring := aniedit.text;
> ANISDB.OPEN;

I prefer to always add the explicit prepare in situations such as
this. However IBO will normally automatically prepare a statement
when using ParamByName. The only instance I am uncertain of is
TIBOStoredProc.

Note: The Prepare process gives the SQL to the server, which both
validates the SQL and returns information about the fields and
parameters involved (data types etc). IBO needs this information to
support additional processing - such as ParamByName etc.


Geoff Worboys
Telesis Computing