Jump to content

Search the Community

Showing results for tags 'dbgrid'.

  • 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. DBGrid just decides to scroll the FOCUSED cell into view for a grid with more rows than can be displayed at once. EVEN THOUGH i had scrolled the vertical scroll bar so that the FOCUSED row has been scrolled out of view. Go to your demo on the uniGUI.COM website then pick desktop demo then open up the "Grids" tree section of the demo then pick "Cell Editors". Doesn't really matter which example you pick. I picked cell editors because it has LOTS of rows (more than are visible). That is the key. Now, in order to replicate the problem/bug/annoyance, follow these steps... 1. CLICK/FOCUS a cell on the top row (could be any row) 2. Scroll grid so that that top row scrolls up and out of view. Scroll with mouse wheel OR the VERTICAL scroll bar. BE VERY CAREFUL NOT TO CLICK ANYWHERE ELSE ON THE FORM cause that cell you focused in step 1 will lose focus. We don't want the cell to lose FOCUS. 3. Click once on your desktop(windows) so that the browser loses focus. Don't worry if you click on an icon since you are not double-clicking. If you have many programs running at once, i suppose you could click on NOTEPAD too. Doesn't matter, we just need the browser to LOSE FOCUS. 4. Now be careful to click on the browser (but not inside the displayed web page. If you click in the red area, you will be safe. It's unused space on the title bar of most browsers. You will notice that the cell you FOCUSED on step 1 has now SCROLLED BACK INTO VIEW. NOTE: This auto scrolling occurs in a variety of other ways too. It's not just defocusing the browser and then refocusing the browser. TO me that seems bad and dumb, because I didn't tell the grid to change my vertical positioning. I hope this is an issue with unigui and not the sencha stuff. Thanks DAvie
  2. Hi, everybody. UniDBGrid, with a PageSize:=25 setting in a TDataSet of 50 records Being on the 25th line of the first page and pressing the down button (or scrolling the mouse) I want to get to the next page (the first line). Being on the first line of the 2nd page, pressing the button on the keyboard (or scrolling the mouse) up to get to the last line of the first page. Has anyone done this? (Paging must be enabled - i.e. it's not about infinity scroll)
  3. How can I enable only the field that has the editor enabled? It is enabling all other fields in the edition and allowing to change the same defined fields or readonly = true in each field of the grid And why does the image appear in her html, as shown in the image?
  4. i use Delphi XE8 and the Trail Version from UniGui **************************************** in German: Guten Morgen, ist es möglich die Spaltenbreite der UniDBGrid automatisch anzupassen? Wenn ich zur Laufzeit einen doppelklick auf die jeweilige Spalte setze, wird diese automatisch auf die passende Länge angepasst. Geht dies auch via Quellcode in der UniDBGrid? Einige Beispiele fand ich bereits im Internet, leider bezog sich dies immer nur auf die VCL DBGrid und war irgendwie nicht kompatible mit der UniDBGrid... Ich freue mich auf einen Hilfreichen Tipp Danke Karsten **************************************** I try to translate in Englich googd morning, it is possible to automatically adjust the column width of the UniDBGrid? If I make a double-click on the column, it is automatically adjusted to the appropriate length. Some examples I found this on the Internet, unfortunately, this is always related only to the VCL DBGrid and was somehow not compatible with the UniDBGrid ... your sincerely Karsten
  5. the widgetbutton disappears from the grid and there is no way to make it redraw if the user doesn't click on the grid refresh. when I change the page of the page control it often goes into a generic ajax error and blocks the whole application. Are there any unigui updates that fix this blocking issue? I use: Embarcadero® Delphi 10.3 Version 26.0.33219.4899 uniGUI Professional Edition v1.90.0.1564
  6. I have a text wrap that modifies the dynamic height of the single row of the datagrid at runtime, it's possible to vertically align the contents of any other columns (for example containing widgets or actions) ? I use: Embarcadero® Delphi 10.3 Version 26.0.33219.4899 uniGUI Professional Edition v1.90.0.1564
  7. Sorry for my poor english first. UniDBGRID (unigui professional / FireFox Browser 59.0.3 X64) 0.Locked column still can not dynamic create(add). Roweditor has no build in Property to set button's caption ("confirm" and "cancel") to other words . 1.After dynamic create(add) columns , both scroll bar can not click and drag. 2.Roweditor buttons paint at diffrent position , first time and other time (no column add or delete operation). 3. If roweditor showed once, after dynamic create(add) or delete dbgird columns , roweditor cells paint at wrong postion ,about 5px shift. 4.If roweditor showed once,dynamic create(add) or delete columns may by fire a error "Could not set cell position :row:[x],column:[0]:a is null". And roweditor can not show after the error. Next time create(add) column will be blank cell and the dbgrid missing columns titles(all blank). And dbgrid missing dataset (click the refresh icon). 5.Sometimes roweditor will paint with no cells. And there is a testcase Project1.rar I had used dbgrids much more in my projects. the new ActionColumn is very good for me. Thank you for the easy useful and powerful products ! 谢谢你们的强力高效易于使用的产品!
  8. I need to copy the text that was selected in the UnidbGrid, through the option of a PopUp menu. I am using the following code: var col: Integer; TextCopy: string; begin col: = gridSenhasLiberadas.CurrCol; Clipboard.AsText: = gridSeedLibrary.Columns.Items [col] .Field.AsString; TextCopy: = Clipboard.AsText; If I give a ShowMessage, I see the Clipboard, however I can not paste it anywhere else. Apparently it's not on the clipboard. How do I then get that dbGrid value and actually put it in the clipboard through a popup menu?
  9. Good Evening, how can I translate or change the Caption of these buttons that are loaded when using the RowEditor function in the DBGrid?
  10. I have a lookup db field among different others in my connected TxxQuery and I want to clear some of them on DBGrid right after choosing the value from dropdown, when it is already collapsed. Assigning nulls on "data" level doesn't work IsMinMax := SameText(qDemandSettingsMETHOD_TYPE.Value, 'MM'); if IsMinMax then qDemandSettingsLOOKUP_DEPTH.AsVariant := null else qDemandSettingsLEFTOVER_MIN.AsVariant := null; [METHOD_TYPE is that "lookup" field, LOOKUP_DEPTH and LEFTOVER_MIN - those I need to clear in DBGrid] Do I need to do something on client side or somehow force to refresh the grid?
  11. Hello, I have a dbgrid and put a label next to the buttons with the number of grid records, but this information will change every time the user performs one, to put a label I managed to do it like this function pagingBar.boxready(sender, width, height, eOpts) { this.add({ xtype:'label', html: '10.358' }); this.add({ text: 'Pedido', handler: function() { top.ajaxRequest(sender,'novopedido', []) } }); } But how can I make it dynamic? because in this same function I use it to include buttons
  12. Hi! My problem is in demo as well. dbgridParent.rowwidget:=enabled: (does not matter) dbgridchild.options ... dgCheckSelect=true (--problem is here) In dbgridParent dgCheckSelect works OK. icon is on/off (check/uncheck) but in widgetframe "dbgridchild" select checkbox icon alway checked. (showing checked icon, even if it's false, not selected actual row) Do you have any solution? Thanks Csaszko
  13. Возможно ли использовать в uniGUI вложенные таблицы в TuniDBGrid на примере cxGrid Devexpress??? . Примерная реализация в ExtJS https://fiddle.sencha.com/#fiddle/nii&view/editor
  14. Hello, I have a case where I need to select certain rows according to the value of a column in a unidbgrid. Do you have a demo or functionality for these cases? Obs. I looked at this topic http://forums.unigui.com/index.php?/topic/6309-multiselect-unidbgrid-select-rows-programmatically/&_fromLogin=1, but I couldn't solve my case.
  15. I have created a pagingbar button using the following code: function pagingBar.boxready(sender, width, height, eOpts) { this.add([ '-', { xtype: "button", text: 'More Records', width: 100, id: "moreRecsBtn", listeners: { click: function() { ajaxRequest(sender, "_moreRecs", []); } } } ]); } In the OnAjaxEvent of the DBGrid I have the following code which is suppose to change the text color of the button when it's clicked but it doesn't: if EventName = '_moreRecs' then UniSession.AddJS('Ext.getCmp("moreRecsBtn").setStyle(' + '''' + 'color' + '''' + ',' + '''' + 'red' + '''' + ');'); How can I change the text color of the button?
  16. I have added a new ComboBox to a DbGrid PagingBar and I want to in code at runtime to be able to:- 1) Clear ComboBox Items 2) Add Multiple ComboBox New Items 3) Read Selected item in Items(ComboBox) via AjaxEvent (_PurchaserItems_) The problem is referencing and adjusting the ComboBox ? My code fragments:- ... ' {'#13#10 + ' xtype: '#39'tbseparator'#39#13#10 + ' },'#13#10 + ' {'#13#10 + ' xtype: '#39'combobox'#39','#13#10 + ' name: '#39'Items'#39','#13#10 + // guess, compiles, no crash ' width: 300,'#13#10 + ' height: 24,'#13#10 + ' tooltip: '#39'Items'#39','#13#10 + ' handler: function() '#13#10 + ' {'#13#10 + ' ajaxRequest(sender, '#39'_PurchaserItems_'#39', []); '#13#10 + ' } '#13#10 + ' },'#13#10 + ' {'#13#10 + ' xtype: '#39'tbseparator'#39#13#10 + ' },'#13#10 + ... procedure TfInvoice.dbGridInvoiceAjaxEvent(Sender: TComponent; EventName: string; Params: TUniStrings); begin ////////////////////////////////////////////////////////////////////////////// if EventName = '_PurchaserItems_' then begin // Do My Thing end; ... Thanks in advance
  17. Hello! I need a DBGrid in which some cells in each row are available for editing When user presses Tab to go to the next cell - this cell gets focus and cursor is positioned at the end of the cell value So before filling cell with a new value, user have to erase old value by press Backspace or to select old value manually and then clear it Is there any way to autoselect value when user enters the cell? Thanks for any help!
  18. as the topic, pls help. i don't want user to click the button
  19. Hello! My DBGrid contains columns with positive and negative values. I need to calculate 3 summary grand total values for every column - positive, negative and common summary (positive + negative). For this separate calculation I use Column.AuxValues[1], Column.AuxValues[2] and Column.AuxValues[3] in OnColumnSummary and OnColumnSummaryTotal events. OnColumnSummary: //positive if Column.Field.Value > 0 then Column.AuxValues[1] := Column.AuxValues[1] + Column.Field.Value; //negative if Column.Field.Value < 0 then Column.AuxValues[2] := Column.AuxValues[2] + Column.Field.Value; //total Column.AuxValues[3] := Column.AuxValues[1] + Column.AuxValues[2]; It works fine. In OnColumnSummaryTotal event I would like to display this grand total values in 3 lines for every column: Result := FormatFloat('##0.00', Column.AuxValues[1]) + #13#10 + FormatFloat('##0.00', Column.AuxValues[2]) + #13#10 + FormatFloat('##0.00', Column.AuxValues[3]); But it doesn't work, grand total row doesn't support text wrap and auto height. I can't place this values in 1 line because column will be too wide. Is there any way to solve this problem or I should use additional components to display multi line grand total? Thank you in advance for any advice!
  20. Is it possible to tell when the popup menu below appears and when it closes via events:
  21. I have a DBGrid with a TUniNumberEdit Editor for Floating Numbers set to 2 Decimal places that fails to paint only 2 decimal places, please advise - thanks. // GST nmInvEdit2.Alignment:= taRightJustify; nmInvEdit2.AllowBlank:= False; nmInvEdit2.DecimalSeparator:= '.'; nmInvEdit2.DecimalPrecision:= 2; // GST Columns.Add; Columns.Items[i].FieldName:= 'GST'; Columns.Items[i].Visible:= True; Columns.Items[i].Title.Alignment:= taRightJustify; Columns.Items[i].Title.Caption:= '$GST'; Columns.Items[i].Width:= 100; Columns.Items[i].Editor:= nmInvEdit2; //Columns.Items[i].Flex:= 1; Columns.Items[i].Font.Color:= clBlack; Columns.Items[i].Sortable:= True; Columns.Items[i].ShowSummary:= False;
  22. Without using an Editor can we round float columns to 2 decimal places ? If we have to use an Editor then I still need to round float value to 2 decimal places - Please show how to implement ? Do we use something like this and how do we apply it in code:- applyValue: function(value) { value = parseFloat(value); if (isNaN(value) || value === null) { value = this.getDefaultValue(); } //round the value to 1 decimal value = Math.round(value * 100) / 100; return this.callParent([value]); },
  23. I am using Locked columns in a DBGrid. In the DBGrid there is a column with DisplayMemo = True, and Editor = UniMemo1. When the DBGrid is shown, at first time, the locked columns appear with default height. After (at right) the locked columns, the height of the lines vary depending on the text on Memo Column. It is show in the image below. The only way I have found to correct the heights is when the form is resized. The result is that all lines in all columns are with the correct height. See the image below. How can the DBGrid appears correctly when the frame is shown at first time? Please, I appreciate any help. Thanks Americo
  24. Hi! I have a TUniDBGrid control with Grouping.enabled = True and Grouping.Collapsible = False. I need to make some actions with record user double clicked on, but I need to do this only with "data" records, not with groups. How can I do this? Thanks in advance for help!
  25. Well, I would like to use the keyboard to navigate in the grid - something like this here: https://fiddle.sencha.com/#fiddle/ron&view/editor Can this be done without changing the source code ? If not - I found the place where to modify the DBGrid - I just need to find the please to inject the following code into the "Ext.application({" Can you give me a tipp on how to do this ? Thanks Nils ----- functions I would like to inject ---- function getDirection(e) { if (e.getKey() == e.LEFT) return 'left' else if (e.getKey() == e.RIGHT) return 'right' else if (e.getKey() == e.UP) return 'up' else if (e.getKey() == e.DOWN || e.getKey() == e.ENTER) return 'down' } function specialKeyFunction(field, e) { console.log(field); var grid = field.up('grid') var pos, newPos, cellMod; cellMod = grid.selModel; pos = grid.selModel.getCurrentPosition(); var dir = getDirection(e); if (pos) { newPos = pos.view.walkCells(pos, dir, e, cellMod.preventWrap); if (newPos) { newPos.view = pos.view; cellMod.setCurrentPosition(newPos); } } Ext.defer(function() { grid.editingPlugin.startEdit(newPos.row, newPos.column); }, 100) };
  • Create New...