Subject Re: [IBO] Using parambyname('param').asstring stop the
Author davissammybr
Thanks Helen, but it's not possibe, after call it the program enter
on infinite loop.

--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:
>
> 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@t...>
> >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/