>VFP 6.0
>
>SQLEexec(nHandle, [select ContHist.RecID from ContHist where (((ContHist.ResultCode)="EXP" .or. (ContHist.ResultCode)="BXP"))], 'ThisCursor')
>
>Anyone have any clue how to do this?
>
>TIA
>
>DJ :o)
There's no need for all the parens... this should work -
SQLEexec(nHandle, 'select ContHist.RecID from ContHist where ContHist.ResultCode="EXP" .or. ContHist.ResultCode="BXP"','thiscursor')
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown