ANISDB is a table that contains phone numbers or "Automatic Number ID" or
Caller ID's . I tried the prepare method as well.

Gordon Hamm

----- Original Message -----
From: "Geoff Worboys" <geoff@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 18, 2001 8:46 PM
Subject: Re: [IBO] Params


> 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
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>