Subject | Re: AW: [firebird-support] not EM goal, but question about firebird statement |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-06-13T06:36:02Z |
> … How can I commit the DDL-Procedure that the oter find my table?You can't COMMIT in PSQL. What you could try is to encapsulate your
stuff in an AUTONOMOUS TRANSACTION (available in Firebird 2.5), but I
haven't tried if this works in a scenario where you create a table and
insert into that table in a single PSQL block.
Regards,
Thomas
> Hello,
>
> I created the following stored procedure:
>
> create procedure P_DB_MOVE_RECORDS (
>
> TOID integer)
>
> as
>
> declare variable STR_J char(4);
>
> declare variable STMTXT varchar(300);
>
> declare variable CHKPROZ integer;
>
> begin
>
> for select substring(ts from 1 for 4) as tsz from t_dt where lnr< :toid
> group by tsz into :str_j
>
> do
>
> begin
>
> if(str_j is not null) then
>
> begin
>
> if (not exists(select 1 from rdb$relations where rdb$relation_name =
> 'B_' || :str_j)) then
>
> begin
>
> select proz_status from p_db_add_new_btable(:str_j) into :chkproz;
>
> end
>
> stmtxt = 'insert into B_' || :str_j ||(…..) ' select * from t_dt;';
>
> execute statement :stmtxt;
>
> end
>
> end
>
> end
>
> The first question: If I call the stored procedure p_db_add_new_btable
> before with the parameter “2012”, it works and the statement knows this
> table. If I call the stored procedure p_db_move_records (calls too this
> procedure), then the statement don’t know this table, it don’t exists. Why
> this?
>
> The second question, I have many table columns. Is there a trick to get all
> columns like: insert into table(*) select * from othertable where condition…
>
> Thank you.
>
> Best regards.
>
> Olaf
>
> Mit freundlichen Grüßen / with best regards
>
> Olaf Kluge
>
> S A T R O N Sachsen
> Steuerungstechnik GmbH
> Johann-Gottlob-Pfaff Straße 7
> D-09405 Zschopau
>
> Tel: +49 (0) 3725 / 3506-31
> Fax: +49 (0) 3725 / 3506-12
> Mobil: +49 (0) 170 / 9292375
> E-Mail:<blocked::mailto:olaf.kluge@...
> <mailto:olaf.kluge%40satron.de> > olaf.kluge@...
> <mailto:olaf.kluge%40satron.de>
> Internet:<blocked::http://www.satron.de/> http://www.satron.de/
>
> ............................................................................
> ................
> Geschäftsführer: Bernd Grötzschel, Gerd Kaden
> Amtsgericht: Chemnitz HRB1218
> Ust-ID-Nr: DE141294791
>
> ............................................................................
> ................
> Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
> sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
> diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
> mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
> danach diese E-Mail.
> This email is confidential. If you are not the intended recipient, you must
> not disclose or use the information contained in it.
> If you have received this mail in error, please tell us immediately by
> return email and delete the document.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>