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.

Thanks.

William

Adam <s3057043@...> wrote: --- In firebird-support@yahoogroups.com, Wei Yu <william_yuwei@y...>
wrote:

>
> 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.

Adam






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




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

---------------------------------
YAHOO! GROUPS LINKS


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

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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
http://mail.yahoo.com

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