DBKit - Accessing table fields not in the window layout

[Keith_Culotta]

@Michelle_Parker

Using 2023.4 and DBKit.SearchResultsListBox (Web) how do I get the selected record from a listbox? I want to insert other table records based on the selected record and the insert sql is complex. I would really prefer to get a RowSet or DatabaseRow.

Do I have to get the id of the record at the selected row and fetch records again? I see currentRow in the Connector but that is private.

I think this post from 2024.01 is another way of asking the same question. I cannot find where a RowSet is associated with a DBKit query. There is this, “listbox.CellTextAt(listbox.SelectedRowIndex, column_num)”, but it only accesses columns contained in the listbox.

Would the best workaround be to create RowSets from queries on a primary key in a hidden listbox column, testing for selected rows with ListBox1.RowSelectedAt(i) or ListBox1.SelectedRowIndex?

(Sorry, I see there is a “Getting Started” category where I should have originally posted this thread.)