Skip to main content
Question

Custom menu illegal SQL error

  • January 14, 2020
  • 5 replies
  • 575 views
J
Sidekick (Customer)
Forum|alt.badge.img+9

I am trying to create a custom menu RMB on the Sales Part screen in IFS Apps 8.
I want it to go to the Purchase Order Lines screen and pass in a part number as a parameter.
I am using the code below which looks OK. If I paste "ifsapf:tbwPurchaseOrderLine?COMPANY=100" into the address bar of IFS it goes to that screen.

SalSendMsg(hWndMDI, PM_Navigate, METHOD_Execute, SalHStringToNumber('ifsapf://tbwPurchaseOrderLine?COMPANY=100?PART_NO=' ||hWndForm.frmSalesPart.dfsPartNo))

I have a screen cap of the custom event here:https://ibb.co/94wyd5R

I am getting the error below when I execute it. I definitely have the permissions under the profile I am logged in to IFS. Can anyone help? Thank you.

Illegal SQL rejected: ifs.fnd.services.plsqlserver.service.security.RejectedSqlException: ILLEGALFUNC:Illegal function: HWNDMDI

 

    5 replies

    H
    Hero (Partner)
    Forum|alt.badge.img+14
    • Hans Andersen
    • Hero (Partner)
    • 241 replies
    • January 14, 2020

    @jdoherty 

    I dont know about app 8, but in app 9 you do it like this

     

    Binura Dodangoda
    Himasha Abeywickrama
    2 people like this
    • Binura Dodangoda
      Binura Dodangoda
    • Himasha Abeywickrama
      Himasha Abeywickrama
    J
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • jdoherty
    • Author
    • Sidekick (Customer)
    • 96 replies
    • January 14, 2020

    Thank you for your reply Hans. I know how to open a window from a custom menu (like you have shown) but I need to use a plsql block to do it because I want the Purchase order Line form to open and show me lines that have the part number I have passed in as a parameter but in descending order.

    This is not possible with an action type of Create Window with transfer, it has to be a PLSQL block.

    For a start I just want it to display the part number I pass in as a parameter and then add the descending condition. I think I know why my code doesn’t work anyway; it is because I don’t have Centura TeamDeveloper installed. I believe I need this software installed on the server in order for the function SalHStringToNumber to work? Can someone confirm this please?

    Thank you.

    JULIAN
    1 person likes this
    • JULIAN
      JULIAN
    Binura Dodangoda
    Hero (Partner)
    Forum|alt.badge.img+11

    Hi @jdoherty,

    SalSendMsg is not a SQL method. It is a method used in the PPJ framework and it used in the client development. So, you won’t be able to use that method in the plsql block as plsql block expects only sql statements.

    --- Binura Dodangoda ---
    Sandun Madola
    H
    2 people like this
    • Sandun Madola
      Sandun Madola
    • H
      Hans Andersen
    J
    Sidekick (Partner)
    Forum|alt.badge.img+3
    • Jagan
    • Sidekick (Partner)
    • 10 replies
    • May 15, 2023

    Hi @jdoherty ,

     

    Are you able to fix this issue?

     

    Thanks,

    Jagan.

     

    J
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • jdoherty
    • Author
    • Sidekick (Customer)
    • 96 replies
    • May 16, 2023
    Jagan wrote:

    Hi @jdoherty ,

     

    Are you able to fix this issue?

     

    Thanks,

    Jagan.

     

    No I was not unfortunately 

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings