As a follow up to my question, trying both suggestions, I get the following:
TEST 1 C_TEXT($fname) $fname:="JT_070" Begin SQL ALTER TABLE JotForm ADD :$fname TEXT NOT NULL; End SQL This produces a parsing error at the ":$fname" It doesn't seem to like the : or the << using the alternate memtion in the manual. This is in ver 15.2 TEST 2 For ($count;1;72) $sql:="alter table jotform add JT_"+String($count;"000")+" text not null" Begin SQL execute immediate :$sql; End SQL end for This works well! Thanks! > On 25 Aug 2016, at 9:43 AM, Pierre Coulombe > <pierrecoulo...@day2daysolutions.com> wrote: > > Thanks, Lutz and Koen! > > >> On 25 Aug 2016, at 9:23 AM, Epperlein, Lutz (agendo) >> <lutz.epperl...@agendo.de> wrote: >> >> Look here: >> http://doc.4d.com/4Dv15/4D/15.1/Overview-of-SQL-Commands.300-2686189.en.html >> and then especially there: >> "Referencing 4D expressions in SQL requests" >> >> That means, use : vfname >> >> HTH >> Lutz >> ********************************************************************** >> 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************
