Assign local variable through "Code Activity"

Harry Mayeux

My end result is a bit more complex than this (that is why I am doing this in a code activity), but I am trying to pull data into a string variable and then assign the results to a local variable (see below).  I have this running when a button is pressed.

 

string FunctionList = SelectSql(new MetastormDefault(), "Select rtrim(f_id), rtrim(sy_code), rtrim(s_code), rtrim(f_desc), s_route, s_nbr, p_flag,s_type from vw_map where rtrim(F_ID) = 'XYZ' and (A_CODE+' - '+A_Desc) = 'X - YZ'").ToString();

 

Local.listoption = FunctionList.ToString(); 

 

When I click the button, these are the results that are returned:

Metastorm.Runtime.Core.DataContainer

 

I am not sure I understand why this is happening or what that "Error" is referring to.

 

Thanks,

Harry

 

Rob Vignerot

This issue is with you using ToString() at the end.  This is returning the full name of the datatype not a string representation of the value. Since, SelectSQL() can be used in many situations, it returns a type of "Metastorm.Runtime.Core.DataContainer".  To return a Text representation, you should be able to use SelectSQL().Text.  Similarly, you could use SelectSQL().Memo, SelectSQL().Real, etc.