How to avoid clashing between local variable and table column name?

By | January 6, 2016

In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table.

Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable and table column name.

To make difference or to avoid clashing between local variable and table column name. use “[L]” syntax while assigning local variable as shown follow.

difference between local variable and table column name

Hope this helps!

About Us

Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix have some unique solutions of Sage X3’s integration with Sage CRMSalesforce.com and Magento eCommerce. It also offers best-in-class Sage X3 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com .We will be glad to assist you.

Other Related Blogs:

How to set folder currency to GCUR global variable

http://www.greytrix.com/blogs/sagex3/2015/11/25/how-to-set-folder-currency-to-gcur-global-variable/

How to assign value to variable at runtime for which you do not know the name beforehand?

http://www.greytrix.com/blogs/sagex3/2015/10/20/how-to-assign-value-to-variable-at-runtime-for-which-you-do-not-know-the-name-beforehand/

How to differentiate the Local and Variable?

http://www.greytrix.com/blogs/sagex3/2015/09/29/how-to-differentiate-the-local-and-variable/

How to add months to your date variable in Sage X3 version 7

http://www.greytrix.com/blogs/sagex3/2015/07/29/how-to-add-months-to-your-date-variable-in-sage-x3-version-7/

How to determine if a mask variable can be entered or is displayed?

http://www.greytrix.com/blogs/sagex3/2014/11/27/how-to-determine-if-a-mask-variable-can-be-entered-or-is-displayed