Stephen,

>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;

This SHOULD be pretty straightforward. I recommend setting a breakpoint so you can see your fully concatenated SQL string before it gets passed to the back end to make sure it contains what you think it should.

Regards,