You must complete the data builder” Message

Original post by Mike Vaughan

Hi,I'm using the following method to return a string value from an extended data table.

Code:

public string defaultSchemeCommMethod()
{
    string schemeID = Convert.ToString (CurrentFile.ExtendedData["udInsurance"].GetExtendedData("schemeID"));
    string type = "Default";
    FWBS.OMS.EnquiryEngine.DataLists ds = new FWBS.OMS.EnquiryEngine.DataLists("udClientSchemes");
    FWBS.Common.KeyValueCollection dsparams = new FWBS.Common.KeyValueCollection();
    dsparams.Add("schemeID", schemeID);
    ds.ChangeParameters(dsparams);
    System.Data.DataTable dt = ds.Run(false) as System.Data.DataTable;
    foreach (System.Data.DataRow dr in dt.Rows)
    {
        type = Convert.ToString(dr["schemeDefPrec"]);
    }
    
    return type;
}

I ran the Taskflow action relating to the method and got the following error message

You must complete the data builder

Using message boxes I discovered that the error happens on this line: System.Data.DataTable dt = ds.Run(false) as System.Data.DataTable;

anyone have any idea why this is happening? cheers

Original post by Richard Annison

It sounds like the datalist you are calling doesn't have the databuilder correctly configured. 

If you open the datalist and alter the databuilder and pass the same parameter values as your code is calling as the test values and use the Test button does it work?

Original post by Mike Vaughan

Thanks for your replies. I just checked and the extended data table had been created but the Data List had not! 

Once that was created and the Data Builder configured correctly the error message disappeared. cheers