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. Hello, I have an issue of UniDBGrid when RTL is True, the data of Column 0 does not appear how it should be, This problem appeared on customer PC's, but not on all PC's, only on some in spite of the same configurations of the PC's same Chrome and Edge versions But in FireFox it worked without problem. Client PC's is Windows 11 and Windows 10 Here am attaching the behavior and a sample project. am using the latest version and Delphi 11.3 Regards to All TestRTLUniDbGrid.rar
  2. 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
  3. Hello there. I have been struggling with this for days and have searched everywhere on the form. I want my enter key to move focus to the cell below it (next row) and immediately start editing it (almost like Excel). At this moment, when I press enter, it goes to the cell below but doesn't open the cell for editing. So I have to tap enter again. I just want to tap enter once, then move down, edit and tap enter again. I am using Delphi 10.2 and UniGUI 1.90.0 build 1566. Thanks for your assistance.
  4. Hola, tengo un problema con 2 UniDbGrid relacionados con Maestro/Detalle. Agrupo los datos por un campo de la UniDbGrid y empieza el problema. El problema es que si me desplazo con el teclado (por ejemplo, presiono y mantengo presionado hacia arriba/abajo, la cuadrícula de detalles no puede mantenerse al día con las actualizaciones y las paradas. Solo funcionan los clics del mouse. Estoy usando el evento afterscroll para actualizar la cuadrícula de detalles, pero si me desplazo hacia arriba y hacia abajo varias veces, el afterscroll simplemente deja de funcionar. procedure TUM.qConPedidoAfterScroll(DataSet: TDataSet); var id:integer; begin id := Dataset.fieldbyname('id').asinteger; qdetalle.Close; qdetalle.ParamByName('IDPEDIDOS').AsInteger:=Id; qdetalle.Open; end; ¿Puede darme una solución con alguna funcionalidad en DBGrid, o quizás pueda recomendar una solución alternativa? Actualizar master-detail no es un problema en el escritorio, pero en la web es completamente diferente. Gracias.
  5. Can anyone explain why (or what would cause) UniDBGrid.RecordCount event to be called several times upon the creation and initial display of a form? In fact, it's called approximately 6 times before the form finishing loading. Even weirder, it appears to be called even before the table has even been opened, based on my logging snippet below: [2 µs][Trace][Value: TframeItem.UniFrameCreate][Type: string] [1040 µs][Trace][Value: TframeItem.UniFrameBeforeReady][Type: string] [25689 µs][Trace][Value: TframeItem.UniFrameReady | begin][Type: string] [29 µs][Trace][Value: TframeItem.tblItem_BeforeOpen][Type: string] [5420560 µs][Trace][Value: TframeItem.UniDBGrid1RecordCount][Type: string] [1876286 µs][Trace][Value: TframeItem.UniDBGrid1RecordCount][Type: string] [18 µs][Trace][Value: TframeItem.UniDBGrid1RecordCount][Type: string] [1196 µs][Trace][Value: TframeItem.tblItem_AfterOpen][Type: string] [2 µs][Trace][Value: TframeItem.tblItem_AfterScroll | begin][Type: string] Thanks in advance.
  6. Hi After ticking each of the selected cells in Test Case, the horizontal scroll will jump. Rtl = True. Regards. GridCheckSelectOnly.zip
  7. Hi, How to reverse the column number with multiselect in unidbgrid. Regards.
  8. Hi, Currently any colour changes in the grid are not reflected on the export. I need to be able to persist either cell colour or text colour when exporting from a grid to make cells visually clear. Like the image below: I can get the cells to change to the respective colour on the grid within the application, what I'm looking for is a way to persist these cell colours when exporting. I am currently using the UniGridExcelExporter component calling grid.Exporter.ExportGrid; to export. Any help would be great. Regards, Wicket
  9. @Sherzod доброе время суток. Заметил странное поведение грида, после того как уничтожаешь объект Edit, который является редактором фильтра в столбце, столбец исчезает. Срабатывает событие "onColumnHide" testGrid.zip Суть в том, что я запоминаю действия над столбцами и записываю в конфиг. При последующем построении грида, настройки столбцов считываются с этого конфига. Получается так, что при каждом перестроении грида, у меня не произвольно пропадают столбцы
  10. Hey guys. Is there any way to add a jpg/png image to the Title of a UniDBGrid column? For this specific case, FontAwesome does not work, it needs to be an image that can be loaded or drawn. I've already researched a lot but I didn't find it (maybe I went the wrong way in the searches). Thanks in advance for any help.
  11. Hello, how are you guys? How do I define a CustomCSS in UniDBGrid.HeaderTitle. I was able to do it in the rest of the UniDBGrid, but the HeaderTitle property does not apply, how could I do it ??
  12. Hi all, how to prevent numeric field in Unidbgrid cell from changing value with navigation keys (up, down). If we press key up current cell value increased by 1 one, if we press key down value decreased by 1. I would like that navigation key go to next/previous row on grid, without changing the value ... similar to Excel. br, Marko
  13. 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:
  14. 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
  15. 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
  16. 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/
  17. 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
  18. 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.
  19. Hi I need help to find why the bigint length more than 15 , UniDbText work correctly but UniDbGrid works wrong
  20. 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:
  21. Подскажите, пожалуйста, как и что сделать, чтобы сетка отображала чекбоксы нормально, красиво. Своство Readonly у столбцов и у сетки отключено. Спасибо.
  22. 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
  23. Как перевести на другой язык пункты Lock и UnLock? Спасибо.
  24. 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.
  25. 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
  • Create New...