|Subject||Re: [ib-support] Parameter in the Where clause|
|Author||Svein Erling Tysvær|
>How about stored procedure? Will it be possible?I don't think it's quite impossible if you know the structure of your table
and the maximum number of parameters to be passed and are prepared to write
a massive amount of code (with plenty of if's). But I wouldn't say it is
feasible, and you have at least two better options:
1) Get IB Objects (www.ibobjects.com) and do as Helen told you. I don't
know the current quality of IBX, but IBO has won the "Best Database
Connectivity" award from Delphi Informant the last two years. Still, Jason
has made great improvements to it this summer!
2) Create your SQL at runtime in Delphi.
Out of curiousity (and because it might help others to answer how they
solved a similar situation to yours): Why do you want to do this?