SQLSETPROP( nconn,"Transactions",2)  && this increases upsize speed a lot
adir( failid, '.dbf')
for i=1 to alen(failid,1)
  SQLEXEC( nconn, "CREATE TABLE "+juststem(failid[m.i,1])+ ;
  " ( id serial primary key, test numeric(10))")  && note: table field creation skipped
  SQLPREPARE(nconn,"INSERT INTO "+juststem(failid[m.i,1])+" VALUES (?test)")
  select 0
  use (juststem(failid[m.i,1]))
  * because you have a rollback, you have to do a preventive check
  COUNT FOR abs(test)<=9999999999 AND SQLEXEC(nconn)>0
endfor
SQLCOMMIT( nconn )