Disclaimer:INLIST() may not be compatible with your data source.
:)
>I would think this would work:
>
>
>=SQLEexec(nHandle, "select ContHist.RecID from ContHist where INLIST(ContHist.ResultCode,'EXP','BXP')", "ThisCursor")
>
>Are you getting an error message?
>Mark
>
>
>>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)
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.