Kevin, I think I am. This is all code in the BIZ OBJECT and not in the GUI.
//Set string of values to push back.
string lcin = "'"+lcproduct+"' , '" +lcselect+"' , '"+ lcappl +"' , '"+lcposition+"' ,"+lnline.ToString();
this.FillDataSet(this.GetCurrentDataSet(),"insert into newnotes (no_product, no_select, no_appl, no_position, no_line) values ("+lcin+")","newnote", this.DatabaseKey,CommandType.Text,(IDbDataParameter[])null);
return this.GetDataSet("SELECT * from newnotes where no_select= '" + lcselect + "' and no_position = '"+lcposition+"' order by no_line");
>Stephen,
>
>>When I step through in the debugger I tried the line :
>>DataSet newnotes = this.GetCurrentDataSet();
>>
>>It's not an object so I'm going out on a liimb about this.
>
>If you're running FillDataSet first, FillDataSet runs SetCurrentDataSet(), so GetCurrentDataSet() afterwards should return the DataSet you've just filled. I recommend stepping through the code to see what's going on.
>
>Regards,