>>1. In GetRecordSet - DataAccessAPI module when a sql statement is passed oRecordSet.Open gives an error. However on testing it is further determined that
>
>I downloaded the sample again and took a look at it. It works fine on my machine, including the executable that came with the package. Make sure you have the right version of ADO installed. I suspect that is the problem.
>
>>2. Could someone explain the Err.Raise lErrNo, OBJECT, sErrDesc statement in the above function! I beleive it is faulty!
>
>That statement appears correct. That statement reraises an error that occurs earlier in the procedure (if there is an error). The OBJECT name is a constant they defined at the top of the module. They reraise the error because their error handler closes the data connection first.
>
>Best,
>
>jody

I have MDAC version 1.5 installed. I 've tried the above i.e.
ORecordSet.Open SQLStatement, oConn
in VFP 5.0, and everything works fine. So I can't really understand why the app shouldn't work.