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 90 results

  1. 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
  2. Gabriel Fabrega

    Change the color of selected row in UniDBGrid

    Hello! Need to change the color of selected row in UniDBGrid . What property CustomCss should be changed ? Best regards
  3. mehmet07

    unidbgrid satir numarasi verme

    Merhabalar, UnidbGrid 'e satır numarası nasil ekleriz? Teşekkürler.

    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?
  5. 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,
  6. Hi All! PageSize Extension for UniDBGrid: How to use? 1. Download the file from here https://github.com/loiane/extjs4-ux-paging-toolbar-resizer/blob/master/ux/PagingToolbarResizer.js and copy to the directory /files/ 2. Add CustomFiles in UniServerModule: files/PagingToolbarResizer.js 3. Add beforerender function in UniDBGrid: function beforerender(sender, eOpts) { if (sender.pagingBar) { sender.pagingBar.hide(); sender.pagingBar.border = "0 none"; sender.pagingBar.destroy(); sender.addDocked( {dock: 'bottom', items: [Ext.create('Ext.PagingToolbar', { pageSize: sender.store.pageSize, store: sender.store, displayInfo: true, plugins: Ext.create('Ext.ux.PagingToolbarResizer',{displayText: 'Records per Page', options : [ 5, 10, 15, 20, 25 ]}) })] }); } } http://loianegroner.com/extjs/examples/extjs4-ux-paging-toolbar-resizer/ Sincerely.
  7. 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.
  8. 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
  9. 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,
  10. 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
  11. thiagopedro

    Remove last border in grid...

    Please, How to remove only the last border of the grid? https://imgur.com/a/yel9Xc5
  12. I would need a solution for drag & drop within a dbTreeGrid. I tried to code something with AjaxEvents but it always fails with "empty row text" at the end. Also I would need to access cells directly (f.e. read value of Cell(Row,Column) as integer or string). A solution for drag & drop would be very much appreciated. I have a quite urgent project, which should be coded with using DBTreeGrid. If someone wants to spend some time on it, I will be ready to pay for your time and effort. pls contact me here or via email: g.ziegler@velio.at Thanks in advance
  13. 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
  14. I know drag&drop using two UniDBGrids are discussed and there are even demo about it but how about dragging and dropping inside one grid? I have data in which rows are ordered by indexed row number and I'd like to add feature where user can drag rows to different positions and when user does that, row numbers are updated in the background accordingly. What is the easiest and more importantly, correct way to achieve this?
  15. 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.
  16. 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.
  17. 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)
  18. 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?
  19. Hi, is there a way to lock UniDbgrid column on runtime? For example onbuttonclick I wan't to lock first two columns.
  20. sample code to resize automaticaly uniDbGrid columns: thanks to Oleg by the model code. function reconfigure(sender, store, columns, oldStore, the, eOpts) { Ext.each(columns, function(column, index) { if (!sender.columnManager) { sender.columns[index].flex=1; /*fit width, comment to disable*/ sender.columns[index].minWidth = 150; /*min.size*/ } else { sender.columnManager.columns[index].flex=1; sender.columnManager.columns[index].minWidth = 150; }; } ) } Demo project Attached. uniDBGrid_Column_AutoSize.rar
  21. 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
  22. Hi, How can I make some of my unidbgrid column title to vertical oriented like the picture shown ? Steve
  23. jpedrosojr

    How can I disable Cell in DBGrid ?

    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
  24. Gabriel Fabrega

    Undo UniDBGrid Sorting

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