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

  1. A.Soltani

    Merge two rows in UniDbGrid

    Hi How can merge two records (rows) in unidBGrid by use Drag & Drop. Best Regards.
  2. Para mudar a cor do fundo da barra de progresso do unidbgrid com o (UniProgressbarWidget) use o css abaixo .x-progress-default .x-progress-bar-default { background-image: none; background-color: #e74c3c; }
  3. 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 }) } }
  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. 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
  6. 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
  7. markokas

    UniDbGrid columns, change index

    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.
  8. thiagopedro

    Toolbar center grid...

    I am looking to automatically center the grid toolbar.
  9. 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.
  10. codeb

    Progress indicator in UniDBGrid

    Hi! Is there some solution to put progress indicator in UniDBGrid. I have one"percent" field (10%,20%,30%....100%) and I try to show visualy percents in UniDBGrid with progress indicator. Any solution for that?
  11. Gabriel

    Refresh UniDbGrid

    Hi, I'm using an AdsQuery to populate a data from and Advantage Database, wich works great. But I'm Having problem filtering the data (I'm trying to make the same thing as the GridFilter example, but with an AdsQuery). I Just can't refresh the query. This is my code on the UniDbGridColumnFilter event procedure TMainForm.UniDBGrid1ColumnFilter(Sender: TUniDBGrid; const Column: TUniDBGridColumn; const Value: Variant); begin if UniMainModule.AdsQuery.Active then begin UniMainModule.ADsQuery.Params.ParamByName(Column.FieldName).Value := '%'+Value+'%'; UniMainModule.AdsQuery.Open; end end; I also try Closing, and Opening the Query, Refreshing it. But nothing seems to work. Regards Gabriel
  12. 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
  13. Артем

    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?
  14. jeans_larghi

    uniCombobox event on uniDbGrid

    Hi, I want to know how to read the text in a uniedit or unicombobox during editing when used in a column in unidbgrid. Using extEvent don't give me text except for the event "data" useful for remote queries. I need to manage and change edit text when data is no present in remote query, but ther is no possibility in dbgrid's unicombobox..... There are ways for manage events in controls embedded in grids? jeans_larghi (Sesamo Software collaborator)
  15. 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
  16. 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
  17. is there any sample on how to create columns in unidbgrid during runtime ?
  18. Добрый день! Меня интересует как управлять размером шрифта в подвале UniDBGrid? Я имею ввиду, когда включен постраничный просмотр данных, то в основании UniDBGrid есть поле с номером страницы. Мне нужно как-то увеличить размер текста в этом поле. Как? И второй вопрос по теме: как выполнить свое действие, при нажатии на кнопку "Обновить", которая находится в основании UniDBGrid? Я хочу сам сделать обработчик этой кнопки.
  19. hi, how to change grouping header font name unidbgrid?
  20. Hi, Let's say i have 3 columns in UniDBGrid Row No | ColA | ColB 1 111 + 2 222 + 3 333 - ........ if cursor point on row that ColA Value = '222', i need to disable UniDBGrid key press I Think ExtJS Event can handle this, but not sure how do i call js function function keypress(e, t, eOpts) { var me = MainForm.UniDBGrid1; // not sure how to get dbgrid value in JS // ex. if Dataset.fieldByName('ColA').AsString = '222' then // Key := #0 } Thank you
  21. Hi every One Merry Christmas I start to convert very big project from VCL to UniGui bat I find some problems to convert VCL DBgrid and StringGrid . In uniGuui there is no Rowcount property for both component also there is no selected Row proprieties. So if thre is some one how had implmente those proprieties can only show how to do this . Also i remarque that until now UniGui don't implement VCL Listview ? Thanks
  22. 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
  23. 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
  24. 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?
  25. 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 and test demo dbgridretest.zip