Update: I'm now getting this same error with *one* customer, out of 50 at
least. I'm using FastReports, and the same reports work in my environment
without any problems. Most annoying...


Antti Kurenniemi

----- Original Message -----
From: "acathelp" <acathelp@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 11, 2009 10:18 PM
Subject: [IBO] Re: Cannot Prepare a blank statement error


>I went through and deleted or renamed all duplicate Rave Data Source
>components which are used to tie the data to the reports (there were about
>3 which were duplicated), but I'm still getting the same result. The
>SysPrepareSQL code executes and I can get it to show me that SQL.Text is
>not blank, but then the report.execute runs which, for some reason, invokes
>the SysPrepareSQL function again, and this time the SQL.Text value is
>blank/empty. Is there any code within IBObjects which may be running
>prematurely to close the data connection or clear our the SQL component?
>If not, I'm going to start hounding the Rave reports people more
>aggressively. At this point, I can't make any software updates or fix
>existing problems for people because if I recompile and publish the app,
>half of the reports exibit this error. Thanks for all your help!
>
> Nick
>
> --- In IBObjects@yahoogroups.com, "Antti Kurenniemi" <Antti@...> wrote:
>>
>> I have a similar problem occurring every now and then (and never in
>> debugging of course), with FastReports. I think my problem might be
>> because
>> there are query components of the same name on different forms
>> (qryHeader),
>> and the report system identifies it's queries just by name, not "full
>> path"
>> of name like form.component, but I am not sure yet. Could you have some
>> similar situation?
>>
>>
>> Antti Kurenniemi
>>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>