There's a limit to how long a VFP command can be and Oracle may have a limit as well, but you don't appear to be anywhere near it (I think the VFP limit is 2k). Can you give an example of an exact line of code that doesn't work?
>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.