Hi,

I am using firebird 1.03.
I would like to select data from a table / stored procedure into another
table that does not exist.

The syntax that I am used to with other database does not seem to work
in firebird. this is

select * from season_pass_remind_world(50000,'01-01-2005',0) into
tblTemp

or even
(select * Table1 into tblTemp)

tblTemp is a table that does not exists, I am just trying to create it
from the result set of the select into statement.

is this possible iin fiebird??? do I have to create the other table
first ( tblTemp)?? if so what is the syntax for doing this.

any help is appreciated

cheers

martin.



=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server


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