firedac memTable syncronize IWjQDBGrid

[guarasemini]

Hello everyone.

I use iw 15.5.9 and changed my grids to IWjQDBGrid but, i cant syncronize the selected row with my firedac memtable. I cant navegate like iwDBGrid. On iwDBGrid, i used the event onclick on the collumn to move my dataset with locate but i dont know how to do that with IWjQDBGrid.

I need that because i show some info and made some updates.

anyone can help me to syncronize firedac memTable with IWjQDBGrid ?

[guarasemini]

Hello everyone.

I use iw 15.5.9 and changed my grids to IWjQDBGrid but, i cant syncronize the selected row with my firedac memtable. I cant navegate like iwDBGrid. On iwDBGrid, i used the event onclick on the collumn to move my dataset with locate but i dont know how to do that with IWjQDBGrid.

I need that because i show some info and made some updates.

anyone can help me to syncronize firedac memTable with IWjQDBGrid ?

well, i dindt search or looked enough. its really simple. kkk Just use the parameters rowID do locate. my bad

[DarrenAmola]

Hi. With IWjQDBGrid the behavior is a bit different compared to IWDBGrid, as most interaction is handled on the client side and not every click automatically moves the dataset cursor. Instead of relying on an OnClick on the column, you should look at the grid’s row selection events, like the row click casino Betblast or selection change callbacks, and then trigger a server event from there. In that server event, you can manually sync your FireDAC MemTable by using the selected row’s key field and calling Locate or setting the RecNo. It takes a bit more wiring than IWDBGrid, but once you pass the selected row value back to the server, synchronization works reliably.