[firebird-support] Re: Insert into Select
dmil...@amfes.com [firebird-support] a écrit : > That's just an "anonymous" procedure. I suppose it is technically something a > client can run without having to define it in the database first - but I was > hoping for something using just insert & select. I do not understand English enough to feel the finesse of your question. but, if execute block does not suit you, there is always the possibility with merge when matched .. / when not matched then insert ... -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Insert into Select
That's just an "anonymous" procedure. I suppose it is technically something a client can run without having to define it in the database first - but I was hoping for something using just insert & select. I didn't think it was possible but had to ask. -- Daniel On Sat, Nov 30, 2019 at 22:17, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: dmil...@amfes.com (mailto:dmil...@amfes.com) [firebird-support] a écrit : As I said - I can do this via stored procedures - but is there a way to do it without? execute block -- Norbert Saint Georges http://tetrasys.fi (http://tetrasys.fi)
[firebird-support] Re: Insert into Select
dmil...@amfes.com [firebird-support] a écrit : > As I said - I can do this via stored procedures - but is there a way to do it > without? execute block -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/