Run a SQL Query from a Lawson Form

 2 Replies
 1 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
agersh
Veteran Member
Posts: 81
Veteran Member
New Poster
New Poster
Congrats on posting!

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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Can't you just run a DME query on HRHISTORY?
agersh
Veteran Member
Posts: 81
Veteran Member
New Poster
New Poster
Congrats on posting!
The SQL query that I am looking to run also includes a sub-Select statement within the main Select clause.