top of page
"All truths are easy to understand once they are discovered; the point is to discover them."
Galileo Galilei
RMAXOneNote covers a wide range of programming languages and technologies (Oracle PL/SQL, C#, Java, etc.), code examples, and solutions related to IFS ERP. The purpose of this blog is to share knowledge among developers about the problems they encounter daily.
IFS Tips & Tricks
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
Fnd Dynamic Tab Page in IEE Client
[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...
4 views0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
LISTAGG in PLSQL
Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...
2 views0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
Get Foundation Error from ORA Error
FUNCTION Strip_Ora_Error ( sqlerrm_Â Â Â Â Â Â Â IN VARCHAR2, Â Â sqlcode_Â Â Â Â Â Â Â IN NUMBER DEFAULT NULL, Â Â strip_ora_only_ IN BOOLEAN DEFAULT...
1 view0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
Global Values in IFS Clients [UserGlobalValueGet]
APP75 SalString sTempCompany = ApplicationForms.Const.strNULL; UserGlobalValueGet("COMPANY", ref sTempCompany); APP9...
1 view0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
How to get a Child Form from a Parent Form in IEE IFS10
Example 1: frmCmpcfgCUTemplateContainer_Cust frmCmpcfgCUTemplateContainerCust = ((frmCmpcfgCUTemplateContainer_Cust)SalWindow.FromHandle(...
2 views0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
How to use DataSourcePopulate in a Child Form in IFS IEE
In child form Override vrtDataSourcePopulateIt #region Methods public new SalBoolean DataSourcePopulateIt(SalNumber nParam) { #region...
0 views0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
Access Private Controls/Variables from Child From to Parent From
We could encapsulate the control variables / define and use the Get Set methods. #region Methods public SalNumber GetExecutionTmplSq() {...
0 views0 comments
Rumesh Aponso (RMAX)
Dec 10, 20241 min read
Find Database Objects in Oracle
SELECT DISTINCT object_type FROM all_objects; SELECT t.* FROM all_objects t WHERE t.object_type IN ('VIEW', 'TABLE', 'INDEX',...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
DBPLSQL Bind Variable in IFS10
Example 1: private void TestFunction() { #region Local Variables SalString sFullName = ":i_hWndFrame." + Ifs.Fnd.ApplicationForms.Int.Q...
2 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
Object Property in IFS
BEGIN Â Â Object_Property_API.Add_Value('LU_NAME', 'OBJECT_KEY', 'PROPERTY_NAME', 'VALUE1;VALUE2;'); END; / IFS APP10 IFS APP7.5
3 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
How to get Parent Form in Master Detail Form in IFS10
How to get parent form in Master Detail Form WAY 1 Â ((frmYvvdaCustomerPriceList)SalWindow.FromHandle(this.i_hWndParent,...
5 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
How to get the Child Form in a Master Detail Form Pic Tab in IFS10
tbwCustomerOrderLine tte = ((tbwCustomerOrderLine)SalWindow.FromHandle(TabAttachedWindowHandleGet(picTab.FindName(Const.TAB_CustOrdLines)...
3 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
Enable a New Language in IFS10
Enable language from the "Used Language" Add Translations Refresh Language Cache Run the below select statement to check that everything...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
Unpack Values from LOV in IFS
// Unpacks additional values from LOV public virtual SalBoolean UnpackAttribute(SalString sLovValues, SalString sAttributeName, ref...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
PM Data Item LOV Done in IFS10 [PM_DataItemLovDone]
#region Methods public SalString GetFieldValueFromLovStr(SalString lsLOV, SalString sSearchField) { #region Local Variables...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 27, 20241 min read
PM Data Item Lov User Where in IFS10 [PM_DataItemLovUserWhere]
Example 1: private void tableWindow_colsBucketId_WindowActions(object sender, WindowActionsEventArgs e) { #region Actions switch...
0 views0 comments
Rumesh Aponso (RMAX)
Nov 26, 20241 min read
PM Data Item Zoom in IFS10 [PM_DataItemZoom]
Example 1: private void dfsCWarehouse_WindowActions(object sender, WindowActionsEventArgs e) { #region Actions switch (e.ActionType) {...
1 view0 comments
Rumesh Aponso (RMAX)
Nov 26, 20241 min read
Select multiple values in LOV in IFS [PM_LovQueryMultipleSelection]
Select multiple values in LOV via PM_LovQueryMultipleSelection private void tableWindow_colsPayTermId_WindowActions(object sender,...
4 views0 comments
Rumesh Aponso (RMAX)
Nov 26, 20241 min read
How to Read BLOB in PLSQL
Below code examples shows how to read a file in Oracle Directory into a BLOB in PLSQL. Example 1: DECLARE dir_ VARCHAR2(100)...
11 views0 comments
Rumesh Aponso (RMAX)
Nov 25, 20241 min read
Menu Item Rearrange/Reorder in IFS IEE
protected override void OnRearrangeMergedMenuItems(Ifs.Fnd.Windows.Forms.FndContextMenuStrip contextMenu) { base.OnRearrangeMergedMenuIt...
0 views0 comments
bottom of page