Explains why Koen’s method works as well as his followup thoughts. It makes sense- so variables for data, and concatenation along with EXECUTE for structure work.
Again thanks to both of you! Pierre > On 25 Aug 2016, at 1:05 PM, Timothy Penner <tpen...@4d.com> wrote: > > It is my understanding that variables should only be used for the Data parts > of a SQL expression, not for the Structural parts. > > I took a quick look at our examples for dynamically altering tables and it > seems that the examples use concatenation along with EXECUTE IMMEDIATE like > in this Tech Tip: Preparing for 4D v14 Journaling Code Samples - > http://kb.4d.com/assetid=76991 > > -Tim > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************