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:[email protected] **********************************************************************
