What VFP version you're using? The delete syntax should work in VFP8.
>hi,
>i get error message 'sql:Queries of this type are not supported '
>at this statment under..
>
> delete from table1 where recno() in (select RecNum from crsRand)
>
>
>for report
>i put the report form rpt1 preview as
>
> endscan
>REPORT FORM rpt1 preview
>use in curPercentage
>
>
>and i compute the number of record before mutiply in side myreport
>it works.
>thanks
If it's not broken, fix it until it is.
My Blog