erich.wanker Posted November 14, 2018 Share Posted November 14, 2018 Hello .. Used Version: 1.50.0.1480 first of all a video ;-) of the ramdom Error "TUniCustomDBGrid.MoveToRow(): Unexpected Row number:" i dont find a reason or a solution ... ThanX for help or support unexpected_row_number.webm i have this problem which comes randomly ( i found no reason)... right unidbgrid = connected dataSource is "dliste" with dataset "liste" left unidbgrid = connected dataSource is "dstruktur1" with dataset "struktur1" procedure Tkunden_fakturieren.DSTRUKTUR1DataChange(Sender: TObject; Field: TField); var s:string; begin s:= STRUKTUR1.FieldByName('INR').asstring; if s='' then s:='-1'; liste.SQL.Clear; liste.SQL.Append('SELECT * FROM ANTEILE WHERE GUNST_INR = '+s+' AND MANDANT_INR = '+inttostr(unimainmodule.aktueller_mandant_nummer)+' AND FAKTURIERUNG_MONAT = '+#39+fakturierungsmonat+#39+' ORDER BY VERTRAG_NR desc '); liste.Open; the right uniDBGrid has following settings .. nothing special: object UniDBGrid1: TUniDBGrid AlignWithMargins = True Left = 11 Top = 128 Width = 458 Height = 407 Hint = '' Margins.Left = 10 Margins.Top = 10 Margins.Right = 10 Margins.Bottom = 10 ShowHint = True DataSource = Dliste Options = [dgTitles, dgRowSelect, dgCheckSelect, dgAlwaysShowSelection, dgConfirmDelete, dgMultiSelect, dgTabs, dgCancelOnExit] WebOptions.Paged = False WebOptions.PageSize = 50 Grouping.FieldName = 'BENUTZERGRUPPE' Grouping.FieldCaption = #220'bersicht' LoadMask.Enabled = False LoadMask.Message = 'Loading data...' BorderStyle = ubsNone StripeRows = False Align = alClient TabOrder = 4 Columns = < item FieldName = 'EINTRAG' Title.Caption = 'Entsch'#228'digung' Width = 150 Sortable = True end item FieldName = 'SUMME_NETTO' Title.Caption = 'Summe Netto' Width = 70 Sortable = True end item FieldName = 'VERTRAG_NAME' Title.Caption = 'Vertragsname' Width = 150 Sortable = True ImageOptions.Visible = True ImageOptions.Width = 16 ImageOptions.Height = 16 end item FieldName = 'INDEXNAME' Title.Caption = 'Index' Width = 150 Sortable = True end item FieldName = 'ZULETZT_FAKTURIERT' Title.Caption = 'Zuletzt fakturiert' Width = 100 Sortable = True end item FieldName = 'VERRECHNEN' Title.Caption = 'Verrechnen' Width = 100 Sortable = True end item FieldName = 'LEISTUNG_BEGINN' Title.Caption = 'Leistungsbeginn' Width = 100 Sortable = True end item FieldName = 'LEISTUNG_ENDE' Title.Caption = 'Leistungsende' Width = 150 Sortable = True end item FieldName = 'KATEGORIE' Title.Caption = 'Kategorie' Width = 64 Sortable = True end> end end end Quote Link to comment Share on other sites More sharing options...
delagoutte Posted November 14, 2018 Share Posted November 14, 2018 i have a similar problem but i can reproduce in all case. In my grid, i apply many filter on datasource that reload data in grid and as for erich.wanker, the issue seem to be displayed randomly when we use the selectall checkbox i am using 1472 version Quote Link to comment Share on other sites More sharing options...
vlkc Posted December 3, 2018 Share Posted December 3, 2018 Hello, I have the same issue. Farshad, take a look at the bug report. I think it should help to find the solution. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 3, 2018 Share Posted December 3, 2018 Hello, Which build are you using ?! Quote Link to comment Share on other sites More sharing options...
vlkc Posted December 3, 2018 Share Posted December 3, 2018 uni - 1.50.0.1481 ext - 6.6.0 Quote Link to comment Share on other sites More sharing options...
vlkc Posted December 6, 2018 Share Posted December 6, 2018 1482 version is update for this problem? Quote Link to comment Share on other sites More sharing options...
vlkc Posted December 12, 2018 Share Posted December 12, 2018 Hi, did not get any answer. Can somebody confirm? Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted December 12, 2018 Administrators Share Posted December 12, 2018 On 12/6/2018 at 9:19 PM, vlkc said: 1482 version is update for this problem? No, there is no specific change for grid. 1 Quote Link to comment Share on other sites More sharing options...
vlkc Posted December 12, 2018 Share Posted December 12, 2018 When we could expect update? Quote Link to comment Share on other sites More sharing options...
thiagopedro Posted January 12, 2019 Share Posted January 12, 2019 I'm also having the same problem. When using "Filter" / "Filtered = True" in FDQuery. Error in function TUniCustomDBGrid.MoveToRow. "UniDBGrid" is not automatically filtering. After filtering and clicking the manually refresh uniDBGrid button, it updates the data, but the page count goes wrong. Anyway, you're in trouble! As I had already been informed by other colleagues, I figured that an update would soon come out. My Version: ext-6.6.0 / uni-1.70.0.1485 Quote Link to comment Share on other sites More sharing options...
thiagopedro Posted January 12, 2019 Share Posted January 12, 2019 Also tested with version ext-6.6.0 / uni-1.70.0.1484. Same problem! Quote Link to comment Share on other sites More sharing options...
Hayri ASLAN Posted January 13, 2019 Share Posted January 13, 2019 Can you please create a test case? Quote Link to comment Share on other sites More sharing options...
arilotta Posted March 1, 2019 Share Posted March 1, 2019 Me too I'm experiencing this error, in not reproduceable situations. Build 1485. Quote Link to comment Share on other sites More sharing options...
molla2005b Posted July 20, 2019 Share Posted July 20, 2019 Me too I'm experiencing this error, if select some rows by checkSelect and then type in column filter. get this error : TUniCustomDBGrid.MoveToRow(): Unexpected Row number Build : 1.90.0.1504 Quote Link to comment Share on other sites More sharing options...
Sherzod Posted July 20, 2019 Share Posted July 20, 2019 Can you check with latest build? Quote Link to comment Share on other sites More sharing options...
Ronbral Posted July 20, 2019 Share Posted July 20, 2019 Also occurs in 1.50.0.1482. But it's actually pretty random and hard to fake. I thought I was related to the Dataset.Locate that I use in a quick launch location window; but I've never been able to confirm this. Quote Link to comment Share on other sites More sharing options...
molla2005b Posted July 21, 2019 Share Posted July 21, 2019 21 hours ago, Sherzod said: Can you check with latest build? yes.still exists in Build 1505 I haven't this error in uni-1.0.0.1425 Quote Link to comment Share on other sites More sharing options...
molla2005b Posted July 22, 2019 Share Posted July 22, 2019 I have disable AllwaysShowSelected and error disappeared . Quote Link to comment Share on other sites More sharing options...
donlego Posted September 15, 2019 Share Posted September 15, 2019 still exist on 1506 random error Quote Link to comment Share on other sites More sharing options...
d.bernaert Posted September 15, 2019 Share Posted September 15, 2019 Hi, I also had this error once this morning, never had it before. I cannot simulate it. Dominique Quote Link to comment Share on other sites More sharing options...
donlego Posted September 25, 2019 Share Posted September 25, 2019 any news about this , exception ? Quote Link to comment Share on other sites More sharing options...
vlkc Posted April 28, 2020 Share Posted April 28, 2020 Hello, the exeption is in UniDBgrid.pas if (not Silent) and (DD.RecordCount > 0) then if Result <> ARecNo then ShowMessageN('TUniCustomDBGrid.MoveToRow(): Unexpected Row number: '+Format('%d, %d',[Result, ARecNo])); raise Exception.Create('TUniCustomDBGrid.MoveToRow(): Unexpected Row number: '+Format('%d, %d',[Result, ARecNo])); In my case it rises in... procedure TF_Muitine.UniDBGrid3AfterLoad(Sender: TUniDBGrid); var DBGridJSName: string; _RecNo: Integer; begin if UP_Aiksteleje.Visible = True then begin Try if UniMainModule.Mui_TR.RecordCount > 0 then begin DBGridJSName := UniDBGrid3.JSName; UniMainModule.Mui_Puspr.First; UniMainModule.Parinkta_Puspr:= 0; for _RecNo:= 0 to UniMainModule.Mui_Puspr.RecordCount - 1 do begin if UniMainModule.Mui_TR.FieldByName('Bendra_ter_Id').AsString = UniMainModule.Mui_Puspr.FieldByName('Bendra_ter_Id').AsString then begin UniSession.AddJS('setTimeout(function(){'+DBGridJSName + '.getSelectionModel().select('+ DBGridJSName +'.getStore().data.indexOfKey('+ IntToStr(_RecNo) +'), true)}, 50)'); Inc(UniMainModule.Parinkta_Puspr); Break; end else begin UniSession.AddJS('setTimeout(function(){'+DBGridJSName + '.getSelectionModel().select(-1)}, 50)'); end; UniMainModule.Mui_Puspr.Next; end; if UniMainModule.Parinkta_Puspr = 0 then UniSession.AddJS('setTimeout(function(){'+DBGridJSName + '.getSelectionModel().deselectAll()}, 50)'); <<<<<----- Here end; Except End; end; end; I guess after there is nothing to deselect or select. Temporary I disabled an exception place, but it's not correct. Can you please fix that? Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted May 28, 2020 Share Posted May 28, 2020 I'm having the same error and I still don't know why: Error: TUniCustomDBGrid.MoveToRow (): Unexpected Row number: 21, 24 1 Quote Link to comment Share on other sites More sharing options...
Sherzod Posted May 28, 2020 Share Posted May 28, 2020 2 hours ago, eduardosuruagy said: I'm having the same error and I still don't know why: Error: TUniCustomDBGrid.MoveToRow (): Unexpected Row number: 21, 24 Hello, Which build are you using? Do you use a custom JS? Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted May 29, 2020 Share Posted May 29, 2020 15 hours ago, Sherzod said: Olá, Qual build você está usando? Você usa um JS personalizado? Unigui - 1.90.0.1526 Do I use JS in dbgrids? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.