>>The following code produces an error in VFP6, but not in VFP5:
>>
>>SELECT submits.specno+"-"+submits.submno AS Index, LEFT(submits.descript,50) AS Description,;
>> 0 AS statusno, {} AS datercvd;
>> FROM submits ;
>> WHERE Submits.ProjNo = mbhProjNo;
>> AND Submits.ProjNo+Submits.SpecNo+'-'+Submits.Submno
NOT IN ;
>> (SELECT History.ProjectNo + History.SubmitNo FROM History) ;>> ORDER BY 1, 4;
>> GROUP BY 1;
>> INTO CURSOR step1
>>
>>It appears to be coming from the 'NOT IN' section which should be highlighted above. Is there something new in SQL which is tripping me up?
>>
>>TIA
>
>Michael,
>
>What error does it produce?
(record 3): Syntax error. upon compilation (build).
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site