Subject | Re: Cannot Prepare a blank statement error |
---|---|
Author | acathelp |
Post date | 2009-03-11T20:18:18Z |
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
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
>