Yes,,, not compatible like mysql...
my case... same like this.. i have Table name Monthly ( MytblMMYY). and i have idea.. every create Table Mytblmmyy, I create New procedure/Trigger to. and Name Of StoredProctrigger Monthly to.
 
Thanks

--- On Fri, 4/24/09, Martijn Tonies <m.tonies@...> wrote:

From: Martijn Tonies <m.tonies@...>
Subject: Re: [firebird-support] FOR EXECUTE STATEMENT (Error when trying to runt a stored procedure)
To: firebird-support@yahoogroups.com
Date: Friday, April 24, 2009, 2:29 AM









>> Can anyone look at this and tell me why I receive an error (Column
> Unknown
>> V_CLT_ID) when trying to execute this procedure? V_CLT_ID is defined
> in
>> the
>> input parameters.
>>
>> FOR EXECUTE STATEMENT 'SELECT DISTINCT ATD.ACCT_TRAN_ ID,
>> ATD.ACCT_TRAN_ DETAIL_ID,
>> ATDT.ACCT_TASK_ ID,
>> CAST(ATDT.CREATE_ DATE AS
> DATE) AS
>
> Are you sure that you can pass parameters to EXECUTE STATEMENT?

You can't, the string to be executed needs to have the values inside it.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.database developmentforum .com



















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