>>How to skip such rows when upsizing data using VFP code?
>
>Which code ?

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 (?m.test)")
  select 0
  use (juststem(failid[m.i,1]))
  scan 
    SCATTER MEMVAR memo 
    * error in this line discards all inserted rows:
    SQLEXEC(nconn)
    endscan
endfor
SQLCOMMIT( nconn )

>Do you want to discard these records ?

Yes.