Jump to content
uniGUI Discussion Forums

Search the Community

Showing results for tags 'UniDbGrid'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • uniGUI Public
    • Announcements
    • General
    • Feature Requests
    • Installation
    • Deployment
    • Other Platforms
  • Licensing
    • Licensing
    • Ordering uniGUI
  • Bug Reports
    • Active Reports
    • Closed Reports
    • Old Bug Reports
  • uniGUI Development
    • uniGUI 1.x
    • Beta Releases
    • Utilities
  • Mobile Platform
    • uniGUI Mobile
    • Mobile Browsers
  • Users Area
    • Sample Projects
    • Components and Code Samples
  • Non-English
    • Non-English
  • Miscellaneous
    • Hosting
    • Server Security
    • Jobs

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 103 results

  1. Hello! Simple implementation... UniDBGrid.ClientEvents.ExtEvents -> 1. function beforeedit(editor, context, eOpts) { editor.grid.needToClear ? context.value = "" : {}; } 2. function beforeitemkeydown(sender, record, item, index, e, eOpts) { var me=sender.grid; me.needToClear = (e.getKey() !== 13 && e.getKey() !== 9); } 3. function beforeitemkeypress(sender, record, item, index, e, eOpts) { var me=sender.grid; if (!me.editingPlugin.editing) { me.editingPlugin.startEditByPosition({ column: me.uniCol, row: me.uniRow }) } }
  2. Hello, I have a grouped uniDBGrid. (uniDBGrid.Grouping = Enabled) I can Collapse or Expand all groups at runtime, but can't find a way to do it individually. For example. I want the Grid to show me the groups collapsed to a record, and from there on the rest expanded and do it at runtime, by code. Can someone help me to achieve this? Thank you so much. This is an image of the grid as an example: https://drive.google.com/file/d/1O-D4ngD3RAW0yZ3203-Pi0P2MjjvEhYM/view?usp=sharing
  3. thiagopedro

    Toolbar center grid...

    I am looking to automatically center the grid toolbar.
  4. I have a TUniDBGrid linked to TDataSource linked to TFDQuery linked to TFDConnection using Postgress (PG) driver with default options. I have two browser instances open with the TUniDBGrid. When I make changes in the TUniDBGrid in one browser instance, it goes all the way through to the Posgress DB. I confirmed this on the server using PGAdmin. However clicking on the TUniDBGrid refresh icon in the second browser instance does not refresh the changes. Only a whole browser refresh (CTRL-F5), loads the changes. What also works is to add a dedicated button that closes and then opens the TFDQuery. I suspect some caching in the TFDQuery or TFDConnection? Any advice what to change to the TUniDBGrid refresh icon works correctly? Using Delphi 10.3 Update 2 & UniGui Version:1.90.0 build 1517
  5. Артем

    Selected column in UniDBGrid

    Hello! Need get field name of selected column in UniDBGrid at just moment, uses mouse. I mean, for example, in UniDBGrid exist Column='MyField' and when I making double click colomn, I must get name of select column. May be, exist something property as UniDBGrid.SelectedField (as in DBGridEh, from Ehlib components). Is it possible?
  6. Hi, When I want to use RowEditor in a UniDbGrid and insert a new record, it doesn't show information in the columns with Lookup fields. I need to configure some property or this type of field can't be displayed until I confirm the registration? Thanks
  7. is there any sample on how to create columns in unidbgrid during runtime ?
  8. Добрый день! Меня интересует как управлять размером шрифта в подвале UniDBGrid? Я имею ввиду, когда включен постраничный просмотр данных, то в основании UniDBGrid есть поле с номером страницы. Мне нужно как-то увеличить размер текста в этом поле. Как? И второй вопрос по теме: как выполнить свое действие, при нажатии на кнопку "Обновить", которая находится в основании UniDBGrid? Я хочу сам сделать обработчик этой кнопки.
  9. hi, how to change grouping header font name unidbgrid?
  10. Hi I need to apply run time unidbgrid1.LayoutConfig.Width:='100%'. I searched a few in web, and I find something similar to wich I'm thinking, but I'm not able to recustomize the code, I only produce ajax error. UniPanel2.layoutconfig.Flex:=1; UniPanel2.JSInterface.JSAssign('flex', [1]); UniPanel1.JSInterface.JSCall('doLayout', []); Can someone help me? Is the right way? If possible i would like to have a link to sencha documentation to understand where i can find usefull information for this tipical situation. Tnks a lot
  11. arilotta

    UniDbGrid scroll with dgEditing

    Hi all, I would like to scroll with key arrows up and down the grid, even when the grid is in editing mode. I already enabled KeyNavigation in WebOptions, but the grid is navigable using the keys only when not in editing mode. When in editing mode, pressing arrow down, it is the same as pressing key END, that is it moves the cursor to the end of the text; while pressing arrow up, it moves the cursor to the beginning of the text. I would like that pressing arrow down, the current record is posted, and the dataset moves to the next record, while when pressing arrow up, the current record is posted, and the dataset moves to the previous record. Could that be achieved in some way ? Thanks to all the contributors, Andrea
  12. Hi, When I use a UniDBGrid and feed it with data from an external MySQL server, cell text gets limited i.e. truncated after 30 characters (as shown in the figure below). Is there any property which controls this behavior?
  13. Merhabalar, unidbgridde kullanicilar istedikleri sutunlarin lock degerlerini ayarlayabiliyor. Ekranı kapattıklarında bu degerleri ini dosyasına yazdırıp sonraki açılışlarda bıraktıkları gibi gelsin istiyorum. Locked yapilmis alanları if grid.Columns[6].Locked= true then bu kodla alamiyorum. Nasıl bir yol izlemeliyim ? Teşekkürler. Kullandığım unigui:
  14. mehmet07

    unidbgrid satir numarasi verme

    Merhabalar, UnidbGrid 'e satır numarası nasil ekleriz? Teşekkürler.
  15. Hi, i created insert and delete buttons on pagingBar of uniDBGrid, but buttons not working OnAjaxEvent in uniDBGrid, how to call new event name from ajaxRequest script ? my script like this below: function pagingBar.afterCreate(sender) { sender.items.items[0].hide(); sender.items.items[8].hide(); sender.items.items[10].hide(); sender.add( [ { xtype: 'label', text: '0', cls: 'grdfooter', padding: '0 0 1 5' }, '->', { xtype: 'button', icon: 'files/images/delete.png', tooltip: 'Delete Registry', handler: function() { ajaxRequest(UniDBKZM, 'delRow', ["slctd="+UniDBKZM.getSelectionModel().getCount()]); } }, {xtype: 'tbseparator'}, { xtype: 'button', icon: 'files/images/ok.png', tooltip: 'Insert Registry', handler: function() { ajaxRequest(UniDBKZM, 'insRow', ["slctd="+UniDBKZM.getSelectionModel().getCount()]); } } ] ); } procedure TFFaturaOnaylamaEkrani2.UniDBKZMAjaxEvent(Sender: TComponent; EventName: string; Params: TStrings); var selectedRows:Integer; begin if SameText(EventName, 'delRow') = True then begin selectedRows := StrToIntDef(Params.Values['slctd'],0); ShowMessage(IntToStr(slctdRows)); end; end; ----------------- thanks,
  16. hassan@3log.com

    UniDBGrid Event issue on Change Record

    There is an issue with UniDBGrid when user clicks on first row. First BeforeScroll event of Dataset occurs, then AfterScroll event happens. Again BeforeScroll happens but AfterScroll does not happen. This cause some issues, as I close some dataset on beforescroll and open them afterscroll. Steps to reproduce: Click on a row in grid other than First row Now, Click on first row Before scroll event happens After scroll event happens Before scroll event happens The issue is After scroll event does not happen after second Beforescroll event I analyzed the uniDBGrid.pas code and believe it is related to following two lines. DD.First; DD.MoveBy(ARecNo); Could you please add following if condition? This way, DD.MoveBy(0) is not called. Hence, the extra call for Before scroll does not happen. uni- Thanks.
  17. M477H13U

    UniDBGrid.CurrCol not updated

    Hello everyOnes ! (: I want to highlight the fact that when you have a grid with options [dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgRowSelect, dgConfirmDelete, dgMultiSelect, dgAutoRefreshRow] the property UniDBGrid1.currCol is not update when you navigate with keyboard. I made a testCase to highlight this issue, attached to this post. Nb: Build 1458 here. Regards, testCurrentColumn.7z
  18. M477H13U

    Column move + sorting

    Hello everyones! (: I just noticed what seem to be an issue with column moving and sorting (Has not tested it on recent build; mine is 1458): Just take demo project GridColumnSort and add Grid Option "dgColumnMove". Then apply a sorting on second column. ThereAfter, take column three, and move it to second position. It is still second column that is sorted even though it is suppose to be the third one due to the column movement.. Any workaround ? Regards,
  19. Behavior When moving from one master record to another, the related detail datasets should refresh, obtaining a result set that consists only of records that correspond to the selected master. Thus the detail datasets display only the records that are children of the master dataset. However, the "second" detail dataset does not refresh if the record count of the detail result set is the same for both the prior result set and the new result set. There is a project at GitHub that illustrates this problem. For those with more curiosity, see the README. Here's the URL: https://github.com/Pasquina/uniguimasterdetail.git
  20. thiagopedro

    Remove last border in grid...

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

    Campos da Unigrid Reajustar conforme tamanho da tela

    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?
  22. 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
  23. cristyanlopes

    SetFocus in UniDBGrid column

    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.
  24. A.Soltani

    Check Key in OnColumnSort Event

    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.
  25. 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)