Hi Pierre, I think this should work (from the top of my head):
for($count;1;68) $sql:="alter table jotform add jt_"+string($counter;"000")+" text not null" begin sql execute immediate :$sql; end sql end for You could do it in one sql using this syntax (being built into a $sql and run with execute immediate): alter table jotform add (jt_001 text not null, jt_002 text not null,...) HTH Koen Op 25-aug.-2016, om 15:15 heeft Pierre Coulombe <pierrecoulo...@day2daysolutions.com> het volgende geschreven: > Begin SQL > ALTER TABLE JotForm ADD JT_001 TEXT NOT NULL; > ALTER TABLE JotForm ADD JT_002 TEXT NOT NULL; > ALTER TABLE JotForm ADD JT_003 TEXT NOT NULL > End SQL ********************************************************************** 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 **********************************************************************