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