Dataset Filter

[pcerdaz]

Hi, I'm changing from BDE + Paradox to IBX. There are some things that work in a different way: on BDE Dataset there is a Filter property but how can I do a runtime filter over the dataset over IBX?
Thank you,
pcerdaz

[Wayne Niddery [TeamB]]

Post by pcerdaz
Hi, I'm changing from BDE + Paradox to IBX. There are some things
that work in a different way: on BDE Dataset there is a Filter
property but how can I do a runtime filter over the dataset over IBX?

Use Where clauses in your SQL statements.

[pcerdaz]

Not only Where but also Order by clauses will be necesary
to change from Paradox to IBX, but still I have another
problem: there are many places where I use them with different
conditions. Do you know a method to make SQL on runtime or
change some lines of the SQL made previously at design time?

Thank you,
pcerdaz

Post by Wayne Niddery [TeamB]

Post by pcerdaz
Hi, I'm changing from BDE + Paradox to IBX. There are some things
that work in a different way: on BDE Dataset there is a Filter
property but how can I do a runtime filter over the dataset over IBX?

Use Where clauses in your SQL statements.
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"If there is any principle of the Constitution that more imperatively
calls for attachment than any other, it is the principle of free
thought — not free thought for those who agree with us, but freedom for
the thought that we hate." - Oliver Wendell Holmes

[Wayne Niddery [TeamB]]

Post by pcerdaz
Not only Where but also Order by clauses will be necesary
to change from Paradox to IBX, but still I have another
problem: there are many places where I use them with different
conditions. Do you know a method to make SQL on runtime or
change some lines of the SQL made previously at design time?

You can put any SQL you want into a TIBQuery, TIBDataset, or TIBSQL at
runtime:

MyIBSQL.SQL.Text := 'select * from some table where somcondition order by
somefields';

You can also do it with parameters:

MyIBSQL.SQL.Text := 'select * from some table where somefield=:somparam
order by somefields';
MyIBSQL.Params[0].AsInteger := 100;