>=SQLEexec(nHandle, "select ContHist.RecID from ContHist where INLIST(ContHist.ResultCode,'EXP','BXP')", "ThisCursor")
>
>What is SQLEExec? is this a VFP6 thing? ODBC thing?
SQLExec() is the SQL Passthrough command that sends a query or operation to a backend for execution. In this case, it won't work because the INLIST() function being passed is not a part o the backend's SQL implementation - it should be converted to a standard TransAct SQL syntax IN clause.
>
>I'm wondering how it's different from SELECT - SQL...
It's a way to have VFP ask another SQL engine to process a query - VFP forms an operation to be performed at the backend and passes the request to the backend server.