RE: Committing data without assigning to a variable in SQL

Brian,

Is SQLMlist a variable length field?  If not, then that might be your 
problem.  If it is not a variable length field then...
  SQLMlist = 'insert into sswdppp (';
   // SQLMlist is equal to 'insert into sswdppp(               ' Notice, 
lots of spaces???
  SQLMlist = SQLMlist + 'select pskdl1, pskdl2, pskdl3, psyear, psmdl,';
   // SQLMlist is still equal to the 'insert into sswdppp(               '

Fix,
1 - Make SQLMlist a varying length field, or
2 - Change to
  SQLMlist = 'insert into sswdppp (';
  SQLMlist = %trim(SQLMlist) + 'select pskdl1, pskdl2, pskdl3, psyear, 
psmdl,';

Rob Berendt