Martijn,

Yes, I know I can do this in MS SQL Server. So, I can't do this in Firebird? :(

Ok, here is my problem.
I have a complicated query. I can do this with view. But, I want to insert something. I can't do this in view, right? That's why I think I need something like temporary tables.
I need to insert something to this query/view without affecting the tables itself.
I was thinking to use store procedure but now since you told me that I can't do this in Firebird, so, anybody has any ideas?

Thanks!
Regina


*********** REPLY SEPARATOR ***********

On 13/05/2003 at 11:17 Martijn Tonies wrote:

>Hi,
>
>> I need to create a temporary table inside a store procedure. And once I
>called the store procedure, I want to delete that temporary table
>automatically.
>> How should I do this?
>
>With MS SQL Server.
>
>> Anybody has a good reference?
>
>You cannot do this in Firebird or InterBase.
>
>Perhaps you should explain the problem - it might be better to do it in
>another way
>or maybe we know a work-around.
>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - the developer tool for InterBase & Firebird
>Upscene Productions
>http://www.upscene.com
>
>See you at the First European Firebird Conference in May in Fulda, Germany
>http://www.firebird-conference.com
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/