I have narrowed down when the error is occuring, but I'm not sure what to do to fix it. The code for TIB_BDataset.SysPrepareSQL executes without issue when I first click the button to build the SQL for the report (I use SQL.Append by the way), then the Rave component executes its code for the report, followed by another call to TIB_BDataset.SysPrepareSQL which fails with the Empty dataset error message.

I have put Showmessage statements in the IB_Components code to determine that the SQL.Text is indeed completely empty upon the 2nd time through, but I've never seen this happen before. I reinstalled my IBO components again just in case, but didn't help.

At this point I can't be sure if this is an IBO issue or an issue with Rave reports. The strange thing is that the underlying Delphi project code hasn't changed, only the reinstallation of the software. Any ideas are welcome, as this is now happening to several reports, so it rules out a single "report file" issue.

Thanks again,

Nick

--- In IBObjects@yahoogroups.com, "Roger Vellacott" <rvellacott@...> wrote:
>
> Helen,
>
>
>
> I have never had any trouble assigning a string to the SQL.Text property
> of any kind of dataset component, or indeed to any kind of string list.
> SQL.Count seems to be completely reliable, even if the string contains
> CRs. Lines can immediately be referred to by their line number, as
> though the lines of the string had been entered using "Add".
>
>
>
> Roger Vellacott
>
> Passfield Data Systems Ltd
>
> +44 (0) 1404 514402
>
> +44 (0) 7831 156839
>