Search the Community

Please, How to remove only the last border of the grid? https://imgur.com/a/yel9Xc5

Ola boa tarde, tenho uma Unigrid, e gostaria que os campos dentro desta grid se ajustace de acordo com a tela, sera que isso seria possivel?

Hi, I have an error detected using UniDbGrid (TUniDbGrid) related to an Interbase table. Also I am using Delphi 10.2 Tokyo with Unigui version 10.0.1472. In a column where Integer type values ​​are loaded (the same happens with Float type fields), if I insert the value 0 (zero) when validating the previous record of its insertion in the table, the IsNull function returns the value True. The exact validation done in the BeforePost event of the table is as follows: If TableName.FieldByName ('AmountFrom'). IsNull then ShowMessage ("You must enter an amount greater than or equal to 0") The problem is that if I charge amount = 0 the, when doing the previous validation I get the message that I must enter an amount because of the IsNull function returns TRUE. If 0.01 is reported (or any value other than 0) the IsNull function returns FALSE. I did the same test using DbGrid (TDbGrid) and the "IsNull" function worked correctly returning TRUE if nothing was actually entered in the column and FALSE if 0 (zero) was loaded so the problem is not at the database level. In this case I am not using querys but I use the TIBCTable and TIBCDataSource components of Devart. Thanks in advance

Hello, I'm having a question, I am typing a value in the 1st column of dbgrid and pressing ENTER or TAB, since the cursor goes to the 3rd column, how do I perform the setfocus in the desired column of the UniDBGrid? In DBGrid we use DBGrid1.SelectedIndex: = 2; Thank you very much in advance.

Hi How to I can check Control Key (Ctrl , Alt , Shift ) in OnColumnSort Event? I want do job 1 in OnColumnSort Event and when user press Ctrl and click on column do another job. Best Regards.

Hi !! We have a problem with UniDBGrid --> Columns - Property : Editor and UniDbGrid --> Property: ReadOnly Details: 1. I 've made for you a test case. 2. In a Form: - A UniDbGrid linked Table: ElFormularios. 1.In Property: Columns --> in Columns ' property-->Editor : we put a component, for example: a UniComboBox ( error appears with all components, we 've test them). - A UniRadioGroup1 with : 1 Name:ReadOnly (option): UniDBGrid.ReadOnly:= True; ( option for default) 2 Name:NotReadOnly(option): UniDBGrid.ReadOnly: False; - A UniButton1 ( it contains another process, it works well). 3. When clicking on UniRadioGroup1-->NotReadOnly first time, it works well. Then clicking on UniRadioGroup1-->ReadOnly, it works well For Second Time clicking on UniRadioGroup1-->NotReadOnly, it does not work. Error ( I attach a file with error). We don´t why UniDBGrid.ReadOnly:= False doesn´t work, if we put a component in editor ( Property's Columns). Thanks in advance Angélica ( Arizmendi's team)

Hi, is there a way to lock UniDbgrid column on runtime? For example onbuttonclick I wan't to lock first two columns.

Good afternoon, I have a problem putting my PopUp menu in UnidbGrid. Until version 1398 was working, and now in version 1466 the menu opens in different place from where I click. See the image, where is the red arrow is where I click, and the popup opens higher. How to correct?

Hi, How can I make some of my unidbgrid column title to vertical oriented like the picture shown ? Steve

UniDBGrid nesnesinde verileri grupladım fakat bu gruplarda başlıkların background ve fontları değiştirmek istiyorum. Bu konuda yardımcı olan herkese şimdiden teşekkürler

Hello All, In my grid, some cells cannot be edited if its value is 'EA'. Is it possible disable a cell in UniDBGrid depending its value? Thanks

Hello guys! I have a UniDBGrid with some columns with the "Sortable" property enabled and the "OnColumnSort" event scheduled. Basically, I enter the field in the "IndexFieldName" property of TADQuery. However, I need to clear this order ... Return to the original sort order, which is in the SQL query. Even closing and opening the query and clearing the property "IndexFieldName", prevails the ordering of the column that was clicked. How to clear the ordering of the UniDBGrid columns? Sorry for English. I'm brazilian. Thank you!

Hello everybody, It will be possible in Unigui to modify the behavior of the columns of an unidbgrid associated with fields Lookups?. I need that instead of showing the drop-down list another option is shown (Ex: Ellipsis) so that clicking on that column will open a modal form where I can select the data that I need and return that data to the original Form. Thanks

Hi, As the title says, I converted a library that Mike Heydon made to export a DataSet to old format Excel file (xls) without OLE or Excel installed. This library now converts an UniDBGrid to Excel. Sample of usage. // Add uses UExportExcel procedure TMainForm.UniButton1Click(Sender: TObject); var url, filename, reportname : String; exportExcel: TDataSetToExcel; i: integer; begin reportname := 'ExcelReport'; url := UniServerModule.LocalCacheURL+name+'.xls'; filename := UniServerModule.NewCacheFileUrl(false, 'xls', reportname, '', url); exportExcel := TDataSetToExcel.Create(filename); exportExcel.Grid := UniDBGrid1; exportExcel.WriteFile; FreeAndNil(exportExcel); UniSession.SendFile(filename, reportname+'.xls'); end; Hope it helps everyone. UExportExcel.zip

Hello... I have a uniDBGrid with some selected items. I want to do a routine to execute only the items marked on the Grid. In normal Delphi it has the command: For I to DBGrid1.SelectedRows.Count - 1 then if DBGrid1.SelectedRows.CurrentRowSelected = True then showmessage('ok'); But I did not find similar in uniGui. how do I do? Can anyone help? Thank you Solved... procedure TFm_Form.btSaveClick(Sender: TObject); var I: Integer; B : TBookmark; varAtualiza : boolean; begin varAtualiza := False; if Gr_Grade.SelectedRows.Count > 0 then begin DataSet.DisableControls; B := DataSet.GetBookmark; for I := 0 to Gr_Grade.SelectedRows.Count - 1 do begin (works) varAtualiza := True; end; end; if varAtualiza = True then begin uniMainModule.SQLTempo.Close; uniMainModule.SQLTempo.CommandText := 'update pokayoke a set a.situation = 0 where a.id=:id'; uniMainModule.SQLTempo.params[0].AsInteger := 1; uniMainModule.SQLTempo.ExecSQL; end; DataSet.EnableControls; close; end;

UniDbGrid was setup with null columns ,and roweditor is true. when the 1st time click the button to load data,roweditor showed correct, from the 2nd time load data ,roweditor shows wrong like the picture. and adoquery(with a sql ) shows same effect (2nd time load data). What was i missed? (test with 1.0.0.1424 and 1.0.2.1442) test demo dbgridretest.zip

Hi I use UniDbGrid in right to left mode. When all scroll active,the UniDbGrid Gets irregular. Best Regards.

Hi! How to can i select manually a row in a dbgrid? I'm using dgCheckSelect and dbcheckSelectCheckOnly in options property. I'm using trial edition, version 1.0.0.1424.

Hi all, as far as I have read from the forum the only way to deal with big datasets and uniDbGrids is paging. This works quite well, but I would prefer another option, let me explain better. Without paging, the web server fetches the whole dataset and it gives back it to the client: DB server --> Web server (Unigui) : whole dataset Web Server (UniGUI) --> Browser: whole dataset This is the worst situation, as it implies a lot of overhead for all the actors (DB Server, Web Server, Browser, network, etc.). It should not be used for large datasets. With paging, the web server fetches the whole dataset (this is why the option FetchAll shall be set), and it gives back to the client (browser) just the current page. Therefore: DB server --> Web server (Unigui) : whole dataset Web Server (UniGUI) --> Browser: partial dataset/ curent page This is better, as it minimizes the overhead on the client side (browser), but the Web Server (UniGUI) still has to deal with a large dataset that has to be fetched entirely from the DB server and to be kept in memory. The last option, that I really miss with UniGUI, is the way that VCL DBGrid works, but it is common to find it on many websites. This is the reason why I'm asking about it, I'm confident there should be a way to work it out with UniGUI.I think that it could be called "incremental fetch". Practically, UniGUI should fetch just the first N rows and show them on the UniDbGrid component, letting the user know that there are more rows than the ones actually visible. It could be a button on the paging bar called "Load more rows". If the user clicks on that button, UniGUI should fetch N additional rows from the dataset, and then display N*2 total rows. This approach can be iterated till the whole dataset is fetched. Alternatively, without using the "Load more rows" button, it could be possible to do it in the VCL way: when the user scrolls down the grid and he reaches the last line, the "give me more lines" could be automatically fired. The "incremental fetch" solution would be the best in my opinion, as the user does not really care to know the number of pages in the grid, nor he needs to skip randonly on different pages. Usually he does want quickly the first N rows, and then the possibility to look up another N rows for a fe times. Then, if the data is not found, he would change the actual filter/selection. This would bring the following situation: DB server --> Web server (Unigui) : partial dataset Web Server (UniGUI) --> Browser: partial dataset Sorry for the long post, hoping that I was clear, thank you all. Andrea

Hi How to can remove column selection from UniDbGrid In RunTime? Best Regards.

Merhaba, unidbgrid te mouse sağ tıklayıp popup menü açarak işlem yapıyorum. Fakat seçilen kayıt yerine dataset te aktif olan önceki kaydın bilgisi gelmekte. İşlem adımlarını şöyle açıklayayım. 1 - 2. kaydı Mouse sağ tıklayınca unidbgrid te 2. kayıdı seçilmiş olarak gösteriliyor. 2 - Popup menu açılıyor ve işlem listesin den yapılacak işlem seçiliyor Fakat yapılacak işlem esnasında dataset ten id bilgisini aldığımda 2. kaydın id si yerine önceki seçili kaydın bilgisi gelmekte. yukarıdaki bu işlemi seçmek istediğim kayda önce sol mouse ile tıklayıp sonra sağ tıklayıp tekrarladığımda sorun olmuyor. Anladığım kadarı ile unidbgidte sağmouse tıklanınca satır seçiliyor fakat dataset te seçtiğim kayıt aktıf olmuyor. uniGui Vers :1.0.0.1394 kullanıyorum Delphi XE7 Teşekkürler.

Merhabalar, Unidbgrid bilesenin roweditor özellğini true yapiyorum. Gridin ilk 3 sutunu readonly=true and locked=true. Hersey duzgun calismasina ragmen ekteki resimdeki gibi 3.sutun deger gostermiyor ve "ERROR_1" yaziyor.

Good afternoon: I have the following problem: - UniDBGrid - One of the columns is a UniDBLooKUpComboBox - Different rows can have different items in the UniDBLooKUpComboBox of the same column. How could I do it? Thanks in advance

Hi everyone, Is it possible to set filter values on a TUniDBGrid at run-time using code? If so, could you please give me a simple example? I tried doing this, but it doesn't appear to do anything. I also need to fire the OnColumnFilter event after I set the value. The reason I am doing this is to restrore the state of the grid when a user enters a filter value, it needs to be remembered the next time the user opens the grid. Is this something you can use the ExtJS stateId property with? http://docs.sencha.com/extjs/6.0.1/classic/Ext.grid.Panel.html procedure TIQWebInternalDBGrid.RestoreSavedFilters; var i : integer; begin if not IsDataSetActive then Exit; for i := 0 to Columns.Count - 1 do begin if Columns[i].Filtering.Enabled then begin if IsFilterable(Columns[i].Field, 'A' {Columns[i].Filtering.VarValue}) then begin Columns[i].Filtering.PrevValue := 'triggertheevent'; Columns[i].Filtering.VarValue := 'A'; end; end; end; end; Thanks in advance!

A função abaixo, retirada aqui do forum, tem por finalidade utilizar o enter nas células de um UniDBGrid e funciona bem em grid's com apenas uma linha para os títulos das colunas, mas quando eu mesclo os títulos com GroupHeader's, retorna um erro na execução, gostaria de uma ajuda para resolver essa questão por favor. Esta é a função: function reconfigure(sender, store, columns, oldStore, oldColumns, eOpts) { var grid = sender; for (var i = 0; i < columns.length; i++) { columns.editor = {selectOnFocus: true}; //seleciona o texto if (columns.getEditor()) { columns.getEditor().on('specialkey', function(field, e) { if (e.getKey() == 13) { var store = grid.getStore(); var selModel = grid.getSelectionModel(); var selectedRecord = selModel.getLastSelected(); var recordIndex = store.indexOf(selectedRecord); var nextRecord = store.getAt(recordIndex + 1); if (nextRecord) { selModel.select(nextRecord); if (grid.editingPlugin && grid.uniRow && grid.uniCol){ var _row = grid.uniRow; var _col = grid.uniCol; setTimeout(function(){ grid.editingPlugin.startEdit(_row, _col); }, 10); } } } }) } } } Retorna este erro: columns.getEditor is not a function Se alguém puder me ajudar, agradeço.