Jump to content

Search the Community

Showing results for tags 'UniDBGrid'.

  • 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
    • General Development
    • uniGUI Releases & Roadmaps
    • Utilities
  • Mobile Platform
    • uniGUI Mobile
    • Mobile Browsers
  • Users Area
    • Sample Projects
    • Components and Code Samples
    • Third Party Components
  • 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







  1. Good afternoon! How can I make it so that when you set the UniDBGrid.Enabled property:=False, then the component would not turn gray, but would remain as with the UniDBGrid.Enabled property:=True, but was not available for any actions on the part of users? Otherwise, the information in it is less visible:
  2. Hi: I need to delete from the OnClick event of a TUniButton filters the columns of a UniDbGrid. I'm using Tokyo 10.2. The grid with data I can restore it without filters but I can't delete the texts entered in the filters of the columns. Thank you in advance for your help.
  3. Hi All, I am using unidbgrid and i connect it to datasource and connect the datasource to fdquery with MySQL Cloud Database, some times it works ok and sometimes it gives me this error message: operation not allowed on a unidirectional dataset. so does anybody know the reason? Osama Ghazal
  4. 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
  5. Hi, is there a way to let a Column to accept the Input from a third Party Component? UniDBGrid.Columns[2].Editor := ThirdPartyComponent ; // UniSFComboMultiple Regards
  6. In this topic , I try to share some css for you . For dear novices I will explain, you have this code in UniServerModule -- > CustomCSS Copy and assign the object to the CLS section in Layoutconfig when designing, or use this command when executing bitbtn1.JSCall('addCls', [' ...... ']); you can do if you like first, this sites can help to build css runtime https://htmlcheatsheet.com/css/
  7. Hello, How to prevent editing of some rows in UniDBGrid by checking the field value of the current record? Something like: if UniDBGrid1.DataSource.DataSet.FieldByName('id').AsInteger=100 then begin //prevent editing end; Where to implement that code? Thanks
  8. 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.
  9. Как перевести на другой язык пункты Lock и UnLock? Спасибо.
  10. I have a UniDBGrid attached to a datasource. I also have a UiDBNavigator attached to the same datasource. As expected, I can navigate the datasource either by pressing the Next / Previous button in the navigator or by using the grid itself (eg. up / down arrow key or clicking on desired row using the mouse - all good, so far. Note: Moving to a different record in the datasource can potentially take a couple seconds. This happens because the Dataset.OnScroll event of the datasource applies a filter to a couple of other datasets (i.e. achieving a master detail relationship) and these other datasets themselves are bound to some visual components, many of which are displaying images from the dataset. That's mostly for a background of what's causing the delay and I will refer to this lengthy period as "THE DELAY" After enabling the ScreenMask property for the navigator... when I press a navigator button (Next or Previous) it works as I hoped it would. That is, a) press next b) Mask is displayed c) THE DELAY occurs d) finally the mask is hidden immediately after THE DELAY is complete. However, if I navigate the datasource using the UniDBGrid itself (with LoadMask enabled)... a) no mask is ever displayed b) I can navigate the records immediately back-to-back without THE DELAY c) however, if I quickly move to 3 different records THE DELAY gets "queued" up and does in fact happen 3 times asynchronously. How can I make navigation using the grid work the same as via the navigator? That is, display a ScreenMask, thereby not allowing me to make another move, until THE DELAY is completed. PS I have tried setting UniDBGrid.LoadMask with & without WaitData. And the LoadMask appears to work correctly (it appears when I change pages via the grid). Your thoughts, please.
  11. Hi, I'm trying to put the Filtering.Editor option on dynamically created columns in a UniDBGrid, but it doesn't work at all, in all the ways I try, I get the message "Argument out of range" when running. Here is the code I used to apply the filter: dbGridSQL_Resultado.Columns.Clear; if optControl = 1 then begin with dbGridSQL_Resultado do begin DataSource := dsFDMemTable; Columns.Items[0].Filtering.Editor := TUniEdit(Self.FindComponent('UniEdit1').Name); Columns.Items[0].Filtering.Enabled := True; end; end; Image Error:
  12. 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?
  13. Hi I use UniDbGrid in right to left mode. When all scroll active,the UniDbGrid Gets irregular. Best Regards.
  14. Подскажите, пожалуйста, как и что сделать, чтобы сетка отображала чекбоксы нормально, красиво. Своство Readonly у столбцов и у сетки отключено. Спасибо.
  15. Dear all, I am using unidbgrid for my project. I am manage to set for 1 group in my dbgrid with summary, but my project need multi group and summary with grand total of the parent group. what we want is like this table A AB W1 500 TOTAL QTY :500 A AB W2 400 TOTAL QTY :400 TOTAL QTY : 900 A AC W1 100 TOTAL QTY :100 A AC W2 200 TOTAL QTY :200 TOTAL QTY : 300 TOTAL QTY : 1200 Can give me advise ?
  16. Hi all, Is it possible to change column index in the UniGrid runtime? Or How to change order of columns in the grid? example: grid.Columns[1].index:=5; br,mk.
  17. Hi, When dataset is readonly, it is not possible to select/copy cell text in the grid. Ir would be nice to have property true/false workaround for this is: ClientEvents -> UniEvents -> function beforeInit: { config.viewConfig.enableTextSelection = true; } Br, Marko
  18. Merhabalar, unidbgrid'de UniDBGrid1SetCellValue olayi ile ilgili sutuna girilen degeri almaya calisiyorum. Normalde tablonun kusuratli deger formati "," olmasina karşın griden Value degerini aldigimda kusurati "." olarak gösteriyor. 12,3 sayisini 123 olarak algiliyor.
  19. In dbgrid, I display the solar calendar with a datetimepicker based on the tutorial at this link(1). But after selecting the date, the date is displayed in dbgrid as a Gregorian date. The codes of this link(2) are also not executed. What should I do to display the solar date in dbgrid cell? (1) : http://forums.unigui.com/index.php?/topic/1202-jalali-calendar/&do=findComment&comment=72928 (2) : http://forums.unigui.com/index.php?/topic/6709-jalali-farsi-db-date-picker-calendar/&do=findComment&comment=34122 TestUniDBGridEditorDatePicker.rar
  20. Hi How to get the double-click event of the UniDbGrid column header(only header and not cell or body)? Regards.
  21. Hi, How can I make some of my unidbgrid column title to vertical oriented like the picture shown ? Steve
  22. Hi all any idea how we can have this Grid filter bar like below https://fiddle.sencha.com/#fiddle/2fon&view/editor
  23. Hi Farshad, Since 2016 I have followed you and I have followed the ascending progression of UniGui, today your Framework has reached maturity and has become a global benchmark. We have just acquired our first license to start the switchover Our only request if this is possible is to integrate Filter Bar as above https://fiddle.sencha.com/#fiddle/2fon&view/editor
  24. Hello, I try to lock all columns in group but not success (may be Javascript can help In this situation ?) Step to test: 1. open Demos\Desktop\GridColumnLocking 2. in Column Editor set GroupHeader = "test group" for 3 Columns (these columns already locked) - CustNo - Company - Contact when running, the column does not locked tested Environment Delphi XE7 UniGui Trial Google Chrome 45.0.2454.85
  25. In an uniDbGrid I need to change the default sort order on some of the columns when a user first clicks on the column header. The default sort order is Ascending, but on column 3, 4, 5, 6, 7, 8 I need to instead have the sort order Descending when user do first click on column (and then if click again Ascending). How can the following Sencha js-code be applied to reconfigure the uniDbGrid toggleSortState function on columns[2..7]? columns: [{ dataIndex: 'id', text: 'ID', width: 50, toggleSortState: function() { if (this.isSortable()) { var me = this, grid = me.up('tablepanel'), store = grid.store, sortParam = me.getSortParam(), direction = undefined; if(!store.getSorters().get(sortParam)) { direction = 'DESC'; } this.sort(direction); } }, } Sencha fiddle sample: https://fiddle.sencha.com/#fiddle/17u2&view/editor UniGui Professional
  • Create New...