TIWjQDBGrid erratic behaviour

[alex.trejo@tttnet.com.mx]

Hello, IW16.1.5 (just migrated from pre15!) D12.2

Have been using TMS DBAdvWebGrid for several years and want to replace it with TIWjQDBGrid.
Trying to make most of the *very few* properties accesible via IDE (am not versed in javascript) compared to TMS.

Have an IWForm with IWTabControl, each page of it with one or more TIWjQDBGrids, its datasources are ADOqueries or ADOstoredprocs.

In main Tab (grid shows Orders), user selects a row and pressing buttons moves to other tabs that show detail information pertinent to selected Order in other TIWjQDBGrids.  

TIWjQDBGrid in "home" tab displays as expected [goAutoGridWith, goAutoColumnWidth].
User selects order 5.
When moving to other tab, TIWjQDBGrid there _never_ shows Grid full width, but always show correct information for order 5 THE FIRST TIME. In these other tabs, GRIDS are connected to other datasets.

Prior to returning home, inspecting main dataset shows its correct position (order 5).  
When returning, home TIWjQDBGrid still shows selected row OK (order 5).
None of the other Tabs have to do with dataset of home grid.

*However*, when inspecting main dataset, it isn't positioned in row 5 anymore, but at dataset.eof!!
So even though Order 5 is highligthed, when going again to other tab, info shown is for last Order.

Have tried many things, forcing dataset.locate when returning to home Tab. But it always goes to last record, even if highlighted row is still order 5. No explanation.

So my problems:
1- Even when Options [goAutoGridWith, goAutoColumnWidth], more often than not when entering new tab Grid shows design width. Must resize browser window or do a sync action (buttonclick) to occupy full width.
2-  TIWjQDBGrid from main Tab seems detached from its dataset, showing a selected row but actualy positioned at the end.
3.  Need to have Pager in spanish, how to do it?

Would be nice to
- be able to control row height, fonts, colors, etc. 
- be able to define non-dataset related columns (as in TMS, where you can have images, buttons, etc.)
 
We tried to migrate to IW 16.2, but broken rendering of TMS TIWGradButtons which are widely used made us stay at IW16.5.
PLease help.

[alex.trejo@tttnet.com.mx]

Hello, IW16.1.5 (just migrated from pre15!) D12.2

Have been using TMS DBAdvWebGrid for several years and want to replace it with TIWjQDBGrid.
Trying to make most of the *very few* properties accesible via IDE (am not versed in javascript) compared to TMS.

Have an IWForm with IWTabControl, each page of it with one or more TIWjQDBGrids, its datasources are ADOqueries or ADOstoredprocs.

In main Tab (grid shows Orders), user selects a row and pressing buttons moves to other tabs that show detail information pertinent to selected Order in other TIWjQDBGrids.  

TIWjQDBGrid in "home" tab displays as expected [goAutoGridWith, goAutoColumnWidth].
User selects order 5.
When moving to other tab, TIWjQDBGrid there _never_ shows Grid full width, but always show correct information for order 5 THE FIRST TIME. In these other tabs, GRIDS are connected to other datasets.

Prior to returning home, inspecting main dataset shows its correct position (order 5).  
When returning, home TIWjQDBGrid still shows selected row OK (order 5).
None of the other Tabs have to do with dataset of home grid.

*However*, when inspecting main dataset, it isn't positioned in row 5 anymore, but at dataset.eof!!
So even though Order 5 is highligthed, when going again to other tab, info shown is for last Order.

Have tried many things, forcing dataset.locate when returning to home Tab. But it always goes to last record, even if highlighted row is still order 5. No explanation.

So my problems:
1- Even when Options [goAutoGridWith, goAutoColumnWidth], more often than not when entering new tab Grid shows design width. Must resize browser window or do a sync action (buttonclick) to occupy full width.
2-  TIWjQDBGrid from main Tab seems detached from its dataset, showing a selected row but actualy positioned at the end.
3.  Need to have Pager in spanish, how to do it?

Would be nice to
- be able to control row height, fonts, colors, etc. 
- be able to define non-dataset related columns (as in TMS, where you can have images, buttons, etc.)
 
We tried to migrate to IW 16.2, but broken rendering of TMS TIWGradButtons which are widely used made us stay at IW16.5.
PLease help.

In TMS's DBAdvWebGrid there is an ID, which HAS to be different in each Grid if more than one grid is on the same form, for them to work ok. That maybe  TIWjQDBGrid has same issue? I don't see this ID property.

Sorry, misspelled IW version, IW 16.1.5.

As a work-around, declared global variable laOrdenSelec, and in every button or action that leaves this tab I do:

if not OrdenesGrid.RowSelectedStatus then
WebApplication.ShowNotification('seleccione Orden')
else
with UserSession do
begin
if LaOrdenSelec<>spOrdenesIdOrden.Value then
begin
spOrdenes.locate('IdOrden',laOrdenSelec,[]);
laOrdenSelec:= spOrdenesidOrden.Value; //just to check if working ok
end;

{leave main tab and do stuff}
end;