String concatination

(0) Share

Report

Posted on by Community Member

hi all,

in table i have two fields: fname ,lname.

form data source as table but i want to display "name " in form , how to concatenate two fields (fname,lname) using display method.

thanks&regards

j.lalitha

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Community Member on at

Like (0)

Report

In Display method you can write like this

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Hi,

Take a look here,

Try this this code :

Display str FullNam() { TestFieldLocking testFieldLocking; select * from testFieldLocking where testFieldLocking.CustAcc == this.CustAcc; return(testFieldLocking.FirstName + " " + testFieldLocking.LastName); }

I think this is your solution, Please mark if it helps you!

Thanks

Suresh

Was this reply helpful? Yes No
Martin Dráb 237,978 Most Valuable Professional on at

Like (0)

Report
The first suggestion is better, because:

It doesn't make a query to database for each value to display. Putting select statements to display methods is the main reason why they're so often a performance killer.

Support for localization (e.g. different sequence of names) can be achieved simply by replacing "%1 %2" with a label, which can then be defined differently in different languages.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Hi,

I respect Martin Suggestion, As he said please follow some best practices for display method like,



select FisrtName, LastName from testFieldLocking where testFieldLocking.CustAcc == testFieldLocking.CustAcc; return(testFieldLocking.FirstName + " " + testFieldLocking.LastName);

And Also please find below links,

    https://msdn.microsoft.com/en-us/library/aa602944.aspx

    https://msdn.microsoft.com/en-us/library/aa641216.aspx

    Example scenario :

Bad solution:

Private boolean validateSalesOrder(SalesId _salesId) { SalesTable salesTable; SalesLine salesLine; SalesLineType_Sales salesLineType; boolean ret = true ; while select salesTable where salesTable.SalesId == _salesId 76 BEST PRACTICES FOR D EVELOPING CUSTOMIZAT IONS join salesLine where salesLine.SalesId == salesTable.SalesId { if (salesTable.CashDiscPercent < 0 ) { ret = ret && checkFailed( "<Error message>" ); } if (salesTable.SalesDiscAmount < 0 ) { ret = ret && checkFailed( "<Error message>" ); } if (!salesTable.DeliveryDate) { ret = ret && checkFailed( "<Error message>" ); } salesLineType = SalesLineType_Sales::construct(salesLine); // //salesLineType... //.. // } return ret; }

Good solution:

Private boolean validateSalesOrder(SalesId _salesId) { SalesTable salesTable; SalesLine salesLine; SalesLineType_Sales salesLineType; boolean ret = true ; while select CashDiscPercent, SalesDiscAmount, DeliveryDate, SalesId from salesTable where salesTable.SalesId == _salesId join salesLine where salesLine.SalesId == salesTable.SalesId { if (salesTable.CashDiscPercent < 0 ) { ret = ret && checkFailed( "<Error message>" ); } if (salesTable.SalesDiscAmount < 0 ) { ret = ret && checkFailed( "<Error message>" ); } if (!salesTable.DeliveryDate) { ret = ret && checkFailed( "<Error message>" ); } 77 BEST PRACTICES FOR D EVELOPING CUSTOMIZAT IONS salesLineType = SalesLineType_Sales::construct(salesLine); // //salesLineType... //.. // } return ret; }

Thanks

Suresh

Was this reply helpful? Yes No