I'd like to clear params after running a query but can not find the correct property method. There's no Clear method or something like that. How can I clear the params?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: I'd like to clear params after running a query but can not find the correct property method. There's no Clear method or something like that. How can I clear the params?
Answer: Use ParamByName('aaa').Clear; In FIBPlus version 4.8.1 and downwards this feature did not exist. So users had to write ParamByName('aaa').IsNull:=True. And if you want to clear all the parameters, write a loop:
for i := 0 to Params.count-1 do
Params[i].Clear
Using FIBPlus, I did everything I could only dream of with other data connectors and InterBase in 2 weeks. I am very happy with your work. Together we are successful. >>Mark McFarlane
