ExecuteSQL to retrieve the data to show in the layout
We need some help to sort it out ExecuteSQL function to display returned list of values on to the layout. We are struck while getting the result when we execute the query from one or many tables.
ExecuteSQL ( "select m.state, m.title, me.page_count from magazine m, magazine_edition me where m.mag_pub_code=me.mag_pub_code"; ""; "")
We need to show it in a layout below manner.
How we can achieve this? We tried many ways but couldnt achieve the target.
Thanks in advance.