Updating SQL from property grid edit

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.

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!