Datagrid Issue

[Scriptonite]

I hit a weird issue with the datagrid. I am saving the data to a MySQL database (with Ulrich's fantastic plugin). I am getting the grid data and saving it to the database with

sCurrentRows = Grid.GetRowCount("Grid1");
sCurrentRows = sCurrentRows-1;
local sSelTable = ComboBox.GetItemData("ComboBox1", ComboBox.GetSelected("ComboBox1"));
      
MySQL.Query("DROP TABLE  "..sSelTable);
MySQL.Query("DROP FROM settings WHERE ID = '"..sSelTable.."'");
      
MySQL.Query("CREATE TABLE "..sSelTable.."(title VARCHAR( 100 ) NOT NULL ,weight VARCHAR( 30 ) NOT NULL ,buy VARCHAR( 100 ) NOT NULL ,sell VARCHAR( 100 ) NOT NULL )");
      
                         for t=1,sCurrentRows do
                         
                         rowTitle=Grid.GetCellText("Grid1", t, 0)
                         rowWeight=Grid.GetCellText("Grid1", t, 1)
                         rowBuy=Grid.GetCellText("Grid1", t, 2)
                         rowSell=Grid.GetCellText("Grid1", t, 3)
                       
                          
MySQL.Query("INSERT INTO "..sSelTable.." VALUES('"..rowTitle.."','"..rowWeight.."','"..rowBuy.."','"..rowSell.."')");
                    
                         end
      
      LoadGrid();
      
Dialog.Message("Done", "Settings Saved", MB_OK)

My issue is if the last cell in the last row of the grid is selected the data won't save to the database. I have tried to change the focus, set the text, reload the grid and none of it has worked. Unless I manually select a different cell or add a new row the value will not save. What am I missing?

[Dermot]

The grid row index is zero based but you are starting at 1. Perhaps that is the problem.

[Scriptonite]

I started it at 1 because 0 is a fixed row. I also just discovered the cell data won't save from anywhere on the grid if I don't click off of it before I try to save. It can be in the middle of a row or the end. It's like the grid wants a SetUpdateCell function. How can I tell the grid the cell is updated and the cell data should be set. I've tried the set text and refresh with no luck.

[Scriptonite]

Solved the issue. It seems that the grid needs to lose focus entirely to update the data. It started working correctly after I added the status dialog before the save function.