Run a SQL Query from a Lawson Form

 2 Replies
 1 Subscribed to this topic
 78 Subscribed to this forum
Sort:
Author
Messages
agersh
Veteran Member
Posts: 81
Veteran Member

    Using Design Studio once the HR11 form is displayed I would like to execute a custom Javascript function call that runs an SQL query to retrieve a value from the HRHISTORY table. Is this possible? What syntax would I use to run an SQL query from a for Lawson form, using Design Studio?

    Ragu Raghavan
    Veteran Member
    Posts: 473
    Veteran Member
      Can't you just run a DME query on HRHISTORY?
      agersh
      Veteran Member
      Posts: 81
      Veteran Member
        The SQL query that I am looking to run also includes a sub-Select statement within the main Select clause.