Updating SQL from property grid edit

Unknown

Updating SQL from property grid edit

Unknown

I thought this would be easy to achieve – but I can’t make it work regardless of how I structure it.

I have a query to pull a selected set of data from SQL. That data is then displayed on a form with a data grid and property grid edit. I’ve been attempting to follow these instructions (among others):

[url=https://documentation.decisions.com/editing-data-grid-items-with-the-property-grid/]https://documentation.decisions.com/editing-data-grid-items-with-the-property-grid/[/url]

However, the result from the form is never an array. It is always a single record.

Unknown

On your form and on the data grid properties, is it set to “multi select” or “output all”?
[i]edited by elise@decisions.com on 4/4/2019[/i]

Unknown

You will want the Grid Mode to be set to “Property Grid Edit” which means you can select a row and edit it in a pop up. This should output all the rows including your edits!