Subject | Re: [IBO] WhereSQL |
---|---|
Author | Jason Wharton |
Post date | 2001-07-13T07:55:01Z |
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
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/
>
>