display adhoc recordset

Classic Servoy
1

Is it possible to execute a sql select statement which pulls data from various tables and display the (non-editable) recordset for the user?

2

You could execute the sql statement and then display the results as HTML in a global_html field.

======
Function getAsHTML
Description Returns the result of SQL query as an HTML table.
Example
//assuming the variable dataset contains a dataset
//puts the contents of the dataset into the variable dataHtml formatted as
an html table
var dataHtml = dataset.getAsHTML;
//assigns the dataset to a field and sets the display type to HTML_AREA:
//Assuming html_field is a global text variable:
globals.html_field = ‘’+dataset.getAsHTML+‘’

TIP: To display an HTML_AREA field as an HTML page, add HTML tags at
the beginning ‘’ and at the end ‘’

HTH

Edward

3

ok. thanks!