I have to extract odd aspects of a part from a table after a user has selected the part. I call GetPart() which will clean house in the ds for me, pull the data, and then add it with additional text in another table in the same ds.

The business object for the table gives data in other areas. When I attempt this request, my data (single row) is not populated in the DS!!!!

I have a string statement just to allow me to copy the statement and run it in VFP which gathers 1 record.

string sear = "SELECT * from appl where ap_applpg = '"+lcPage +"' and ap_open ='"+lcOpen+"' and ap_part ='"+lcPart+"'";

this.FillDataSet(ds,"SELECT * from appl where ap_applpg = '"+lcPage +"' and ap_open ='"+lcOpen+"' and ap_part ='"+lcPart+"'", "Adapter" );

return ds;


Any idea on why this is failing?

TIa