Firebird, reports, views and select procedures

Classic Servoy
1

Thanks in advance to those who may answer my question. I am reviewing Servoy at the moment and I have one question. How can I create a report form based on a database sql query where the query maybe a Firebird stored procedure.

Firebird select procedures return data sets just as if it were an SQL query. I in my ignorance of the product cannot see a way to create a display only form from a query. This will be for reporting purposes only and I don’t neccesarily want my output to be HTML.

I hope I am making sense with this question.

2

I don’t want to waste anyone’s time. I have found in other posts the method to create HTML output to a global variable (getDataSetByQuery) as well as the data can be written to a valuelist. It would be nice to have some form of a display only grid (not updateable) to display results from queries to users.

Thomas Clarke

3

I in my ignorance of the product…

Considered this, you make pretty smart feature requests :lol:. I have also requested this in the past (especially to allow users to select the columns they would like to use in a table view) and put my vote again on this!

Patrick

4

I have not yet used direct queries to display data yet, but am soon approaching this for reports. So if I understand this correctly, you can not load a dataset into form or list from direct Query to the backend, with out using html formatting?

5

toonkii:
I don’t want to waste anyone’s time. I have found in other posts the method to create HTML output to a global variable (getDataSetByQuery) as well as the data can be written to a valuelist. It would be nice to have some form of a display only grid (not updateable) to display results from queries to users.

Thomas Clarke

Hi Thomas,

a) you could use getDataSetByQuery to return pks from the database and then use a servoy form to display fields of information for these records

b) or use

//assuming the variable dataset contains a dataset, you can create csv or tab delimited results
var csv = dataset.getAsText(‘,’,‘\n’,‘"’,true)
var tab = dataset.getAsText(‘\t’,‘\n’,‘"’,true)

See JSDataSet under the Database Manager…

Hope this helps,

Christian