Jump to content
uniGUI Discussion Forums

Search the Community

Showing results for tags 'DBgrid'.

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

  1. Is it possible to tell when the popup menu below appears and when it closes via events:
  2. 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;
  3. 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]); },
  4. 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?
  5. 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
  6. 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!
  7. NDzubiel

    DBGrid keyboard navigation ...

    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) };
  8. gerhardhziegler

    Mouse Over Row Color (Background) - DBGrid

    Dear Forum, I wanted to change the color of the Row, where the mouse is just over. Usually in Triton, it has a light blue. I tried: .customSG .x-grid-row-focused .x-grid-td { background-color: #DDAA66 !important; } but it seems not to work. Does anyone have a better idea? Regards Gerhard
  9. piyawatd

    DBGrid not display data some device

    Hello. I use dbgrid for display data from rest.Now it have problem not display data for some device.Iphone some version display and some version not display.How to reslove this problem? iphone xs max ios 13 iphone x ios 13 android
  10. How do I get the selected value of combobox when I edit a value in the grid, I need to get the moment I select, already tried by combobox OnSelect and change more did not work.
  11. =GGG=

    DBGrid DrawRow

    Возможно ли в DBGrid закрасить конкретную строку? на данный момент нашел только возможность закрасить ячейку
  12. hi, how to change grouping header font name unidbgrid?
  13. =GGG=

    траблы с DBGrid

    При разворачивании строки, срабатывает событие CellClick. При этом Column.FieldName возвращает столбец, который был последний раз нажат. Это нормальное поведение грида? Grid - RowWidget.zip
  14. Phxtecno

    UniDbGrid images property

    Hi, can you tell me the usage of "Images" property and "imageIndex" in DbGrid ? I have a table column with integers representing the index of the icon I want show from a UniImageList (Info,Warning,Error); can you explain how-to ? Regards
  15. 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?
  16. 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
  17. Возможно ли использовать в uniGUI вложенные таблицы в TuniDBGrid на примере cxGrid Devexpress??? . Примерная реализация в ExtJS https://fiddle.sencha.com/#fiddle/nii&view/editor
  18. Jean-Marc Kiener

    Bind TuniDBLookupCombobox to DBGrid column

    Hi folks, i have a dbgrid with a column which the DataField behind holding a integer value. This integer value is a key to another table dataset. I set up a TuniDBLookupCombobox showing a string field in the dropdown and as Keyfield the integer value. Now i configured the column to show the LookupCombobox as the editor. My problem: The integer value is shown in de column, not the String field configured in the LookupCombobox. Can anybody help me with this?
  19. Hi all, I wonder if it's possible to specify the TITLE for an image cell in a DBGrid. It would be useful to show the hint/tooltip for the image/icon. The righe place should be OnDrtawColumnCell, but there as far as I can see there is only the possibility to specify the font, the color and the style. Something like that: <div unselectable="on" class="x-grid-cell-inner " title="my title"> <img src="/cache/medreferti_exe/res/__D5E09C51619AD97C38D717BA.png" width="24" height="24"> </div> thanks Andrea
  20. 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
  21. arilotta

    DbGrid editing - limit column focus

    Hi all, I have a DbGrid with dgEditing=true. I would like to limit the columns that can be selected, because some contains icons and some other are text read-only. I am struggling with ClientEvents and CellModel, but I not so familiar with JS and I am wasting too much time. So, how can I limit my grid to only focus on the third column for example ? Thanks you all Andrea
  22. nandrianakis

    Clear Lookup field value in DBGrid

    Good morning Is this possible? Rgds
  23. 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?
  24. Hi, I think that UniDbGrid filtering features are really powerful. In certain cases, however, there is the need to filter multiple values from a list (DBLookup combo), as can be done in MS Excel (see attachment). Currently, with a DBLookupComboBox filter editor, there is the possibility to filter just one value. Is there the possibility to develop such an enhancement ? Thanks for your work. Andrea
  25. Hi, in VCL DbGrid there is the possibility for a column to pick up a customized editor (a dialog), by setting the column ButtonStyle to cbsEllipsis and managing the OnEditButtonClick event. UniGUI already implements various DbGrid editors (UniEdit, UniCombo, UniDBLoockUpComboBox, NumEdit, etc.). In some cases, especially when there are many values to choose from, I think that the ellipsis button that could open a specialized dialog is the best solution. (and maybe it is not too difficult to implement...) Thanks Andrea