Subject Re: [firebird-support] Re: Execute Statement Problem
Author Wei Yu
Hi, Adam

I post all of my DDLs, since I was using copy/paste so the order of DDLs may not be correct. and the test I gave to you should be "select * from report_tariffjournal(-1)", there was a typo. but I just can NOT make it work.



Adam <s3057043@...> wrote: --- In, Wei Yu <william_yuwei@y...>
> Hi, Adam
> Yes. I'm using FB 1.5 higher, I'm thinking it could be a bug in
FB1.5, since I'm using the following generated SQL without problem,
but as long as I assign it to a string, and calling for execute
statement thisstring into then got the error.

I doubt this because I do not have the problem.

Your DDL you posted was incorrect (the domain would have to be
declared before the table and the procedure you execute in your test
is not defined).

I made some assumptions to try and get your problem on 1.5.2, and it
works fine for me.

Perhaps you can generate a SQL script (you must test it before
posting) that creates a database with this structure, then executes
the stored procedure. If you can get it to give you the error, then
post it back to the list and I will be able to duplicate it here.



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Technical support services


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


William, Yu

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

[Non-text portions of this message have been removed]