| Subject | Re: [ib-support] Build a SQL string in a SP execute it? |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-12-27T11:37:22Z |
At 05:15 PM 27-12-01 +0500, you wrote:
You can't do this in InterBase. Unlike SQL Server, InterBase pre-validates and pre-compiles its triggers and stored procedures. You can't create SQL objects in SPs at all, be they statements, tables, indexes, whatever.
Can you describe an example of what you want to do and someone will show you the IB way to do it...
regards,
Helen
>Hello,Govindra,
>I am moving over to Interbase from SQL server.
>
>In many of my stored proceedure.
>I build up a select statement ( a string) and the SP return the results of the execution of this string.
>
>How do I do this in Interbase. I was going through the manuals and I landed up somewhere in gpre etc.
>This seemed very complicated. Is there a simpler way.
You can't do this in InterBase. Unlike SQL Server, InterBase pre-validates and pre-compiles its triggers and stored procedures. You can't create SQL objects in SPs at all, be they statements, tables, indexes, whatever.
Can you describe an example of what you want to do and someone will show you the IB way to do it...
regards,
Helen