>Hi,
>I'd like to add columns to table with the help of FOR loop but I'm stuck with the column name.
>How can the table's name be updated within the loop not to be dulicated.
>Thanks
>Tamas

try
for i = 100 to fcount()+100
   alter table myTable add column ('fld' + transform(i))
next
catch to loError
   ** Display error info
endtry