Subject | Re: [firebird-support] stored procedure: MSSQL -> firebird |
---|---|
Author | Carlos H. Cantu |
Post date | 2008-11-06T20:00:38Z |
Fabio, you need to use "execute statement" to run DDLs statements
(ie: create table, etc).
BTW, GTT metadata is stored with the DB, so you don't need to create
it each time the procedure is run. The structure is not temporary, only the
data is ;)
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
CFPS> I'm transalting a stored procedure that we made in MSSQL.
CFPS> but during conversion I have some problem....
CFPS> exactly I can create a GTT into a SP?
CFPS> some one can give me some idea what I have to change ?
(ie: create table, etc).
BTW, GTT metadata is stored with the DB, so you don't need to create
it each time the procedure is run. The structure is not temporary, only the
data is ;)
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
CFPS> I'm transalting a stored procedure that we made in MSSQL.
CFPS> but during conversion I have some problem....
CFPS> exactly I can create a GTT into a SP?
CFPS> some one can give me some idea what I have to change ?