I may be wrong but I know that
at using Filter the table brings all data and then selects it.
I thougt that if use where clouse I can prevent getting un used data from
server...

if I'm wrong please notify me...

Burak

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, July 13, 2001 10:55 AM
Subject: Re: [IBO] WhereSQL


> If you are using the SQLWhere property this is the whole where clause
> including the WHERE token.
> I think it would be preferable to use the Filter property (with Filtered =
> true) since you get some other benefits as well.
>
> Also, there is the OnPrepareSQL event coupled with the SQLWhereItems
> property, InvalidateSQL/Refresh methods, etc.
>
> See help resources for more information about these and come back if you
> have more questions.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Burak OZLER" <zeroptr@...>
> To: "IB Objects" <IBObjects@yahoogroups.com>
> Sent: Friday, July 13, 2001 12:46 AM
> Subject: [IBO] WhereSQL
>
>
> > I create forms at runtime
> >
> > procedure TfrmPlasiyer.FormShow(Sender: TObject);
> > begin
> > dbPlasiyer.SQLWhere.Clear;
> > dbPlasiyer.SQLWhere.add('PLASIYERID = 4');
> > dbPlasiyer.Active := True;
> > end;
> >
> >
> > dbPlasiyer.tablename = PLASIYER
> > dbPlasiyer = TIBOTable
> >
> > What am I doing wrong?
> >
> > Thanks for your interest
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>