🚀 go-pugleaf

But is very slow!!! I'm changing the sql text every time query that i
do!!!!!

"Neo" <klink_stalag13@nospam_yahoo.com> wrote in message
news:3aa6578a_2@dnews...
> Use Query->SQL->Clear();
> then
> Query->SQL->Add(sql string);
> then
> Query->Open();
> Jorge Leibowich <jorge@lid.com.ar> wrote in message
news:3aa5134d_1@dnews...
> > I'm want to do an applicattion that do about 10000 SELECTS, NOT INSERTS.
> >
> > I'm tested with parametrized querys with "Insert" and it is very faster.
> > But i have a problem with SELECTS.... for example, this works WELL
> >
> > Query->SQL->Text="insert into qwe(field,zxc) values :asd,:zxc"
> > Query->Prepare();
> > for (...100000)
> > {
> >    Query->ParamByName("field")->AsInteger=i;
> >    Query->ParamByName("zxc")->AsString="...";
> >    Query->ExecSQL();
> > }
> > Query->UnPrepare();
> >
> > BUT... If a put the same replacing the text in "select from table where
> > field = :field"
> > and replacing Query->ExecSQL(); to Query->Open(); I do NOT get the
correct
> > RESULT. I'm Getting always the same result, and it is not correct. The
> > QUESTION: The prepare method dont works in
> > Query->Open() method? Only works in ExecSQL ???
> >
> > THANK YOU
> >
> >
>
>