Hello,



yes, I use the ems interbase/firebird-manager.



Even I've test it and it works, despite that error.



Probably the tool is too old and doesn't know this functionality.



Thank you.



Olaf

_____

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von Martijn Tonies
Gesendet: Donnerstag, 16. Oktober 2008 09:52
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] execute statement and in(variable)



Hello Olaf,

>I've a little problem with this:
>
>CREATE PROCEDURE P_TEST(
>INPUTPARAM1 varchar(50))
>returns(
>menge double precision)
>AS /**/
>declare variable statement1 varchar(100);
>BEGIN
> statement1 = 'Select Menge from auftraege where auftrag_pos in('||
>inputparam1 || ')';
> for execute statement :statement1 into :menge do suspend;
>END
>
>The result is: Precompiler Error: parsing error - execute.
>Any ideas?

This isn't a Firebird error, are you using a tool that doesn't know
about [FOR] EXECUTE STATEMENT?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene. <http://www.upscene.com> com
My thoughts:
http://blog. <http://blog.upscene.com/martijn/> upscene.com/martijn/
Database development questions? Check the forum!
http://www.database <http://www.databasedevelopmentforum.com>
developmentforum.com



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.173 / Virus Database: 270.8.1/1727 - Release Date: 15.10.2008
20:02




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