>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.
Thanks Kevin. I copy that string to the clipboard and past it into VFP and sure enough it's presenting 1 line in it's output.
Earlier in the form I have passed in "" for the various strings. I then do a ds.Table[2].Clear so I have the proper single line I want.
__Stephen