Dynamic query and field not found

rbuser

I have a query and RB report that I'm using to produce several reports. I
change the query as necessary, then load the rtm into the report and print.
I'm having trouble between 2 of these. If I run a particular one first I
get a "field not found" error when I run the 2nd one. How do I force the
IBOQuery and DBPipeline to refresh all field names, etc, between reports?
I've tried clearing the fielddefs on the query and FreeFields on the
pipeline.

Delphi 6 pro, RB 7.03 Pro, IBObjects 4.3.Aa.

Thanks.

--

_________________________________________
Don Gollahon
dlgllhn@InHisStepsSoftware.com
ICQ#: 115831669
"What in Eternity does it matter?"
_________________________________________

nicocizik

Hi Don,

The easiest way around this issue would be to create the query using DADE
("data" tab of the designer) so the query is local to each template you
load. There is an IBO plugin available to allow you to access your data at
design time located in the RBuilder\Demos\4. EndUser Databases\InterBase\4.
IB Objects\ directory. Otherwise you could create a new pipeline in code
for each template and connect them manually to the query object after you
change the sql code.

--

rbuser