Populating a solution table based on a List

Katie Stewart

Hi all,

 

I want to implement this in a solution I've been working on:

 

Basically in a form, we have a List (obviously allowing user's to select more than one option).

 

Basically what we need, is that the optinons selected (Option1, Option2,Option3) is stored in an additional solution table basically containg FolderId, ListSelection. For example:

 

Folder Id         ListField

09......0001     Option1

09......0001     Option3

09......0001     Option4

09......0003     Option 1

.

.

.

 

Any ideas on how to build this and what would be the best approach to this.

 

Thanks in advance,

 

 

Lindsay_Iain

Hi Katie

 

The selected items in your List control will be stored in the Memo variable bound to that field as a tab delimited string. You would just need to split the values out and then insert them into your solution table.

 

There are a number of ways to achieve this.

For example, I have an extension method that converts a Memo field to a Metastorm List object defined as follows

 

public static List GetMetastormList( this Memo m, string delimiter )
{
    if( m.Length <=0 )
    {
        return List.Empty;
    }

    return new List( m.ToString().Split(new string[] { delimiter }, StringSplitOptions.RemoveEmptyEntries));
}

 

So, all I would need to do is the following (e.g. on a button click or when the user submits the form)

 

foreach( var listItem in Local.MyMemoVariable.GetMetastormList("\t").AsEnumerable<string>())
{
    // perform inserts here...
        Mstm.SelectSql(
            null, 
            "INSERT INTO MySolutionTable( eFolderId, ListField) VALUES (@folder, @listItem)",
            Mstm.SQLArg("@folder", ProcessContext.FolderId),
            Mstm.SQLArg("@listItem", listItem ) );
}

 

Cheers

 

Iain