Subject RE: [firebird-support] Dynamic Query in Firebird
Author Tomy Handaka
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: on behalf of Martijn Tonies
Sent: Wed 5/23/2007 3:37 PM
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 <>
My thoughts: <>
Database development questions? Check the forum! <>

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