Ok, now I've got a second question. Is there a limit to either the # of characters or parameters that can be sent with an sqlexec command? Here's what I've got so far.

vtest=sqlconnect('TESTSPAN','SPANFM','SPANFM')
dtoday=DATETIME()
vtest3=sqlexec(vtest,;
"insert into pmwrkord (pmwrkord_code,spbldinf_code,spbldrom_code,;
pmshop_code,pmpricd_code,pmactv_code,pmbldsys_code,pmfacprj_code,;
its_current_date,status,wo_type) ;
values (9200014,'ALKICC','101','SSS','2','EVEN',;
'SERV','WP31401',?dtoday,'O','D')")
vtest4=sqldisconnect(vtest)

If I add another field/value combination it fails by saying I have a syntax error and I've swapped the field/value so I know it's not a spelling issue. Is there something else I'm missing?
TIA
Laurisa Watkins
Seattle Parks Dept.