Using a View

Classic Servoy
1

I have a view which IS updateable (I can open it with MS Access and update it fine).

I know I can create a dataset on this view in Servoy using getDataSetByQuery(“Select * from myView”), but can I base a form on this dataset?

2

Hi,

SQL views are not supported under Servoy.

However, Servoy will still allow you to run your query to return the dataset and then you can parse and format this data to be returned as HTML and display it inside an HTML formatted field.

Cheers
Harry