Wilton Ergon Posted February 23, 2022 Share Posted February 23, 2022 9 minutes ago, picyka said: Você usa grid para manipular dados? only in low-access forms, such as editing auxiliary tables, which are rarely changed. in all others when I use the grid and only for data visualization. Quote Link to comment Share on other sites More sharing options...
picyka Posted February 23, 2022 Share Posted February 23, 2022 Right, I use grid only to visualize data, I think that in the web world, it would be the most appropriate, just my opinion. Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted February 23, 2022 Share Posted February 23, 2022 3 hours ago, Wilton Ergon said: em algumas telas de uso intenso, simplesmente abandonei o uso do grid, crio listas em html puro, onde o resultado visual é bem mais bonito, mais rápido, e não dá todos esses problemas, podemos nos contentar com o que ter.. If you can give me an example, I'd appreciate it, when you have the native option to mark the record, that's where the error happens Quote Link to comment Share on other sites More sharing options...
Mossy Posted February 23, 2022 Share Posted February 23, 2022 4 hours ago, Wilton Ergon said: in some screens of intense use, I simply abandoned the use of the grid, I create lists in pure html, where the visual result is much prettier, faster, and it doesn't give all these problems, we can make do with what we have.. Hi Is it possible to share this code? Regards Quote Link to comment Share on other sites More sharing options...
lcolombo Posted March 23, 2022 Share Posted March 23, 2022 Hi, We use Advantage Database Server and had the same error continuously. We fixed it by changing the following option of the TAdsTable component: Sequenced := true; SequencedLevel := slExact; Regards, Quote Link to comment Share on other sites More sharing options...
Denton Posted October 9, 2022 Share Posted October 9, 2022 Hi, For me, it happens when I have an event in UniDBGrid and ActionColumn: And the events execute this code: And this happens(it only happens the first time u delete a row): but when u remove the OnCellClick event, the bug wont show. Any idea how to resolve it ? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 10, 2022 Share Posted October 10, 2022 On 10/9/2022 at 6:44 AM, Denton said: but when u remove the OnCellClick event, the bug wont show. Any idea how to resolve it ? Hello, Can you please make a simple testcase to reproduce? Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 Hi 15 hours ago, Sherzod said: Can you please make a simple testcase to reproduce? Here.. if u remove the OnCellClick event the bug wont show... GridCheckBox.rar Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 11, 2022 Share Posted October 11, 2022 @Denton Yes, I see the issue... Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 11, 2022 Share Posted October 11, 2022 @Denton If this suits you, you may need confirmation, which gives you a workaround: procedure TMainForm.UniDBGrid1ColumnActionClick(Column: TUniDBGridColumn; ButtonId: Integer); begin MessageDlg('Are you sure..?', mtConfirmation, [mbYes, mbNo], procedure (AComponent: TComponent; ARes: Integer) begin if ARes = mrYes then UniMainModule.ClientDataSet1.Delete; end ) end; Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 Hi @Sherzod 1 hour ago, Sherzod said: If this suits you, you may need confirmation, which gives you a workaround: in my case i dont use delete ActionColumn.. I use add Action Column which when clicked, the data goes to another grid.. so it doesnt need confirmation.. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 11, 2022 Share Posted October 11, 2022 1 hour ago, Denton said: in my case i dont use delete ActionColumn.. I use add Action Column which when clicked, the data goes to another grid.. so it doesnt need confirmation.. Okay. But it seems to me that the error is related to the deletion of the record!? Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 25 minutes ago, Sherzod said: Okay. But it seems to me that the error is related to the deletion of the record!? Sorry.. i forgot to mention.. when i click add, the row gets deleted from UniDBGrid1 and added to UniDBGrid2.. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 11, 2022 Share Posted October 11, 2022 3 minutes ago, Denton said: Sorry.. i forgot to mention.. when i click add, the row gets deleted from UniDBGrid1 and added to UniDBGrid2.. Well, as a workaround, can you add first and then delete? Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 12 minutes ago, Sherzod said: Well, as a workaround, can you add first and then delete? did not work.. bug still shows.. my code: Quote Link to comment Share on other sites More sharing options...
lcolombo Posted October 11, 2022 Share Posted October 11, 2022 What database do you use? We use ADS by SAP and we had to check the Sequenced option in the dataset to avoid this problem. Regards Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 8 minutes ago, lcolombo said: What database do you use? We use MariaDB.. 10 minutes ago, lcolombo said: we had to check the Sequenced option where can i find this option? Quote Link to comment Share on other sites More sharing options...
lcolombo Posted October 11, 2022 Share Posted October 11, 2022 https://docwiki.embarcadero.com/Libraries/Alexandria/en/Data.DB.TDataSet.IsSequenced Quote Link to comment Share on other sites More sharing options...
Denton Posted October 11, 2022 Share Posted October 11, 2022 17 minutes ago, lcolombo said: https://docwiki.embarcadero.com/Libraries/Alexandria/en/Data.DB.TDataSet.IsSequenced thanks.. will try this.. Quote Link to comment Share on other sites More sharing options...
zhyhero Posted October 14, 2022 Share Posted October 14, 2022 On 10/11/2022 at 1:36 PM, Denton said: Hi Here.. if u remove the OnCellClick event the bug wont show... GridCheckBox.rar 7.64 kB · 4 downloads I am not sure this is helpful , something (procedure or function) delayed untill OnCellClick. So i changed your source code. type TMainForm = class(TUniForm) UniDBGrid1: TUniDBGrid; UniDBNavigator1: TUniDBNavigator; DataSource1: TDataSource; procedure UniFormCreate(Sender: TObject); procedure UniDBGrid1ColumnActionClick(Column: TUniDBGridColumn; ButtonId: Integer); procedure UniDBGrid1CellClick(Column: TUniDBGridColumn); private { Private declarations } DeleteJobReady: boolean; public { Public declarations } end; function MainForm: TMainForm; implementation {$R *.dfm} uses uniGUIVars, MainModule, uniGUIApplication, StrUtils; function MainForm: TMainForm; begin Result := TMainForm(UniMainModule.GetFormInstance(TMainForm)); end; procedure TMainForm.UniDBGrid1CellClick(Column: TUniDBGridColumn); begin if DeleteJobReady then begin UniMainModule.ClientDataSet1.Delete; DeleteJobReady := false; end; end; procedure TMainForm.UniDBGrid1ColumnActionClick(Column: TUniDBGridColumn; ButtonId: Integer); begin DeleteJobReady := true; end; procedure TMainForm.UniFormCreate(Sender: TObject); var I: Integer; begin DeleteJobReady := false; with UniMainModule.ClientDataSet1 do begin for I := 1 to 100 do begin Append; FieldByName('EmpNo').AsInteger := I; FieldByName('Lastname').AsString := Char(65 + Random(28)); FieldByName('Firstname').AsString := Char(65 + Random(28)); FieldByName('shift').AsBoolean := Random(2) = 1; FieldByName('BoolInt').AsInteger := Random(2); FieldByName('Boolstring').AsString := IfThen(Random(2) = 0, 'set', 'unset'); Post; end; First; end; end; Quote Link to comment Share on other sites More sharing options...
FFREDIANELLI Posted December 10, 2022 Share Posted December 10, 2022 I had this erros in version 1561, but magicaly enabling buffered store the error disapeeared ! Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted December 12, 2022 Share Posted December 12, 2022 On 10/12/2022 at 20:59, FFREDIANELLI said: Eu tive esses erros na versão 1561, mas ativando magicamente o armazenamento em buffer, o erro desapareceu! I've been living with this error for a long time and nobody found out what it was Quote Link to comment Share on other sites More sharing options...
FFREDIANELLI Posted December 14, 2022 Share Posted December 14, 2022 Hi Eduardo, and enabling buffer do not solved the problem ? Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted December 14, 2022 Share Posted December 14, 2022 1 hour ago, FFREDIANELLI said: Oi Eduardo, e habilitar buffer não resolveu o problema ? I can't enable buffering, clients want to see all records in a single screen Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted January 3, 2023 Share Posted January 3, 2023 If this helps the Unigui people, the eurekalog errors are attached. SigefWeb_SERVIDORUNIGUI_20221229113625.el SigefWeb_SERVIDORUNIGUI_20221229113601.el SigefWeb_SERVIDORUNIGUI_20221229113607.el SigefWeb_SERVIDORUNIGUI_20221229113611.el SigefWeb_SERVIDORUNIGUI_20221229113616.el SigefWeb_SERVIDORUNIGUI_20221229113621.el 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.