when caching or prefetching is being done by the SDBC driver to fetch the latest value of a row from the database.
The SDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.
The value returned depends on whether or not the result set can detect deletions.A Result Set cursor is initially positioned before the first row; the first call to next makes the first row the current row; the second call makes the second row the current row, and so on.So we need to create a Stored Procedure on which we pass all parameters that are updateable along with the primary key value, in other words the row data's key value that is being updated.We use the Row Updating event of Grid View to update the record in the database table.The Edit Index property of a Grid View determines the index of a row in edit mode. Update record and get updated state of the Grid View.
When a Grid View row is in edit mode then we can update the row's record in the relational database table.I have attached a picture to illustrate what I am trying to do.Create a Property Node for the Table Indicator and select the Row Hdrs and Col Hdrs properties.You can wire an array of strings to each of these to give the headers whatever info you'd like.I've built a simple VI that builds a 2D aray of strings of random sizes, then builds arrays of strings for the column and row headers.So first we need to move to an updateable row record in the Text Box.