Hi Anna,

>>I assume what you are saying is that I need to use the ADOCommand class and create a DataReader rather than a Dataset ?

Well, I'm no pro with ADO and I understand the term to be RecordSet rather than DataSet, but the something like the following should work.

DIM oConn AS ADODB.Connection
SET oConn AS New ADODB.Connection
oConn.ConnectionString = "Provider=VFPOLEDB;DataSource=FULLPATH(MyData.DBC)"
oConn.Open

DIM oRS AS ADODB.RecordSet
SET oRS AS New ADODB.RecordSet
oRS.ActiveConnection = oConn
oRS.Open("Select * From Customer where CustID = ")

HTH
Pamela