Microsoft Dynamics AX (Archived)

How to get Space between ComputedColumn

(0) Share

Report

Posted on by Community Member

Hai all,

I have Two Fields Name ,Surname i want to combined both fields as single field and sapce.

i did like that .

public static server str add()
{

return

" select top 1 cast(fname as varchar(15)) + ' ' + cast(lname as varchar(15)) as fullname";

}

suggest another way..

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Hi,

You can see this code, and the below code is suggest by Microsoft in MSDN.

computed column is not specially mean for spacing. Please look into the below code, you will come to know on spacing.

private static server str compColSubsegAcctMethod() { #define.ViewName(TestCompColView) #define.DataSourceName("CustTable_1") #define.FieldSubsegmentId("SubsegmentId") #define.FieldAccountNum("AccountNum") str sReturn, sAccountNum, sSubsegmentId; DictView dictView2; // Construct a DictView object for the present view. dictView2 = new DictView(tableNum(#ViewName)); // Get a string that has the target field name // propertly qualified with an alias (such // as "A." or "B."). sAccountNum = dictView2.computedColumnString (#DataSourceName, #FieldAccountNum, FieldNameGenerationMode::FieldList, true); sSubsegmentId = dictView2.computedColumnString (#DataSourceName, #FieldSubsegmentId, FieldNameGenerationMode::FieldList, true); sReturn = "substring(" + sSubsegmentId + ",1,1) + ' - ' + " + sAccountNum; // Helpful confirming or diagnostic information. info(sAccountNum); info(sSubsegmentId); info(sReturn); return sReturn; }

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (1)

Report

Hi,

Display str add()

{

str output;

;

output = strfmt("%1 %2", this.fname,this.lname);

return output

}

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

since that's SQL syntax that will be transformed to view so you can also use SPACE function of SQL Server

+SPACE(5)+

--You can reduce or increase 5 , depending upon as many chars as you may want.

Was this reply helpful? Yes No