I'm using ORM framework that have been built based on SQLServer database. It works well with SQLServer and then I'm using it for another project with Firebird as its DBMS.

Apparently, I have to modify the framework :)

Thanks for your assisstance

________________________________

From: firebird-support@yahoogroups.com on behalf of Martijn Tonies
Sent: Wed 5/23/2007 3:37 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Dynamic Query in Firebird

> Yeah, that is the main problem. I have to define [an exact number of]

output variables in stored procedure, but it have to be dynamic since the
stored procedure can receive ANY sql query.

>
> How to make this 'return values' dinamic, based on SQL query in its input?
>
> Any suggestions?

Don't use a Stored Procedure... :-)

Why do you want to use one in this case?

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






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