TD-23945 (regression 7.0.4): incorrect context row 0 after calling SalTblDeleteRow()

Post by **Uwe van der Horst** » 15 Feb 2018, 14:10

We have found a mayor problem with 7.0.4. In some cases we are filling Grids in the follwing way (columns as bind variables):

Call SqlPrepareAndExecute( hSql, 'select x, y into :col1, :col2 from z' )
Call SalTblSetContext( hWndForm, SalTblInsertRow( hWndForm, TBL_MaxRow ) )
While SqlFetchNext( hSql, nDummy )
...Call SalTblSetContext( hWndForm, SalTblInsertRow( hWndForm, TBL_MaxRow ) )
Call SalTblDeleteRow( hWndForm, SalTblQueryContext( hWndForm ), TBL_MaxRow )

Logically after processing the While SqlFetchNext... we have to delete the last row because it is empty. Here is the regression:

With TD 7.0.3 and all previous versions after calling SalTblDeleteRow() the context row is "TBL_Error". This is the expected behaviour.
With TD 7.0.4 after calling SalTblDeleteRow() the context row is "row 0". This can cause some heavy unwanted effects.

I have attached a test case that shows the probem. Extract the .zip and run the .exe (not the .apt). With the cdlli70.dll (version 7.0.4) the context row is 0 (wrong). With the cdlli70.dll (version 7.0.3) the context row is TBL_Error (ok).

I will make a support case.

SalTblDeleteRowGivesWrongContextRow.zip

TDWiki YouTube Channel · Post by **Dave Rabelink** » 16 Feb 2018, 06:18

I can confirm this, Uwe.

Post by **Uwe van der Horst** » 22 Feb 2018, 10:16

The bug number is TD-23945.

Post by **Uwe van der Horst** » 12 Jul 2018, 18:32

This bug is fixed in TD 7.05 and 7.1.

Team Developer SQLWindows Community Forum