Sorry Paul,

That did not work. What do you think is going on? How come a SELECT * without a WHERE clause will produce a dataset with content but a SELECT * statement *with* a WHERE clause produces an empty dataset?

Regards,
Neil

>> // use the full path to the table because there is no dbc
>> 1)//return this.GetDataSet("SELECT * From c:\\gmgwin\\main\\arypat01.dbf WHERE custid = '" + tccustid + "'");
>
>Just a quick guess, but try escaping out the single quotes:
>
>

>return this.GetDataSet("SELECT * From c:\\gmgwin\\main\\arypat01.dbf WHERE custid = \'" + tccustid + "\'");
>