Below is an example custom menu we use
Customer menus action type: SAL code Parameter: frmInventoryPart.DbPLSQLTransaction(frmInventoryPart.c_hSql, "&AO.up_parts_api.ur_clone_part( 'CA', 'US', :i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue )")
&AO.up_parts_api.ur_clone_part is my procedure( mine is actually in a package ) 'CA', 'US' – two static values being passed to my procedure :i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue – value from the form being passed to my procedure. i_sMyValue – if you are passing a value that is in a drop down box you need to add i_sMyValue to the end o the statement. |