Steven,

This is a place where macro expansion is just not needed and appears to be causing your problem. I think one of your nf memvars is greater than 254 characters. I'd rewrite the code like this instead:

testthissd = "INSERT INTO drawmstrp" + ;
   "(dm_drawing_number,dm_drawing_title,dm_pending_change," + ;
   "dm_date_issued,dm_requester_name1,dm_requester_name2," + ;
   "dm_job_order,dm_project,dm_customer,dm_size,dm_sheets)" + ;
   [ Values ("] + ;
   nfn + [","] + ;
   nf2 + [","] + ;
   nf3 + [","] + ;
   nf4 + [","] + ;
   nf5 + [","] + ;
   nf6 + [","] + ;
   nf7 + [","] + ;
   nf8 + [","] + ;
   nf9 + [",'E',1)]

>How can I get this SQL string to work. It is too long but I need all the info
>
>testthissd = "INSERT INTO drawmstrp"+;
>"(dm_drawing_number,dm_drawing_title,dm_pending_change,"+;
>"dm_date_issued,dm_requester_name1,dm_requester_name2,"+;
>"dm_job_order,dm_project,dm_customer,dm_size,dm_sheets)"+;
>"Values"+;
>"(&nfn,"+"&nf2,"+"&nf3,"+"&nf4,"+"&nf5,"+"&nf6,"+"&nf7,"+"&nf8,"+"&nf9,"+"'E'"+",1)"