Drop a TIB_MonitorDialog on the form and watch what happens when Prepare is
called.

Helen


At 08:29 AM 08-09-02 -0300, you wrote:

>No works yet, its stop before enter on "if not Prepared then Prepare" line;
>
>
>----- Original Message -----
>From: "Helen Borrie" <helebor@...>
>Newsgroups: egroups.ibobjects
>Sent: Sunday, September 08, 2002 12:11 AM
>Subject: Re: [IBO] Using parambyname('param').asstring stop the
>
>
> > At 06:42 PM 07-09-02 +0000, you wrote:
> > >Hi,
> > > I'm using the folowing code:
> > >
> > > Var Qry_prev:TIBoQuery;
> > >Begin
> > > Qry_Prev := TIBOQuery.Create(Self);
> > > Qry_Prev.DatabaseName := Connection.Database;
> > >
> > > with Qry_Prev do
> > > begin
> > > Sql.Clear;
> > > SQL.add('Select * from mytable where C_login=:login');
> > > ParamByName('Login').asstring := '7';
> > > open;
> > > end;
> > >end;
> > >
> > > I'm debuging the code but the delphi stop in "parambyname" code
> > >line, and don't show any message error. Where is my error?
> >
> > try this:
> > ...
> > with Qry_Prev do
> > begin
> > // Sql.Clear; Not needed
> > SQL.add('Select * from mytable where C_login=:login');
> > if not Prepared then Prepare;
> > ParamByName('Login').asstring := '7';
> > open;
> > end;
> > ...
> >
> > Helen
> >
> >
> >
> >
>___________________________________________________________________________
> > IB Objects - direct, complete, custom connectivity to Firebird or
>InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>___________________________________________________________________________
> > http://www.ibobjects.com - your IBO community resource for Tech Info
>papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>_______________________________________________________________________
>Yahoo! Encontros
>O lugar certo para encontrar a sua alma gêmea.
>http://br.encontros.yahoo.com/