Just make sure the SQL.Text doesn't contain just some Blanks, LF's , LF
/CR's or cobination of the same, else
you get the same error. SQL.Text = Trim(Sql.Text)
cures it.

----- Original Message -----
From: "acathelp" <acathelp@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 06, 2009 1:16 PM
Subject: [IBO] Cannot Prepare a blank statement error


> The error seems to come from IB_Components, TIB_BDataset.SysPrepareSQL
> Procedure. It gets to the "if SQL.Count=0 then" statement and executes
> the error message there.
>
> This occurs on several of my Rave Reports projects when they attempt to
> execute. It doesn't do it for all the reports, only a few, all of which
> worked before my hard drive crashed.
>
> I am running a fresh install of Delphi 2006, Rave BEX 7.0.5, Interbase
> 7.5, and IBO 4.8.7. I have copied the SQL statements in question into
> IBConsole and run them without any problemto ensure they have resulting
> data sets.
>
> I don't know if there is some patch/update I might be missing, or if
> anyone has any ideas. Thank you for your help.
>
> Nick
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>