 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
pcerdaz
Guest
|
 Posted: Wed Oct 11, 2006 4:37 am Post subject: Dataset Filter |
 |
|
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 |
|
| Back to top |
|
 |
Wayne Niddery [TeamB]
Guest
|
| Posted: Wed Oct 11, 2006 7:08 pm Post subject: Re: Dataset Filter |
|
|
pcerdaz wrote:
| Quote: | 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 |
|
| Back to top |
|
|
pcerdaz
Guest
|
| Posted: Sun Oct 29, 2006 5:14 am Post subject: Re: Dataset Filter |
|
|
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
"Wayne Niddery [TeamB]" <wniddery (AT) chaffaci (DOT) on.ca> wrote:
| Quote: | pcerdaz wrote:
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
|
|
|
| Back to top |
|
|
Wayne Niddery [TeamB]
Guest
|
| Posted: Sun Oct 29, 2006 9:17 pm Post subject: Re: Dataset Filter |
|
|
pcerdaz wrote:
| Quote: | 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;
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Reality is that which, when you stop believing in it, doesn't go
away." — Philip K. Dick |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
