peeryog

On your all Tabs UnipageControl 1. Set your UniDbGrid paged property : True Already set this way 2. Limit all your queries to 100 records by SQL Previously limited to 50 3. DataSet.FetchAll : False Already Set 4. Dataset.autoPrepared : True Already Set 5 DataSet.usingBlob : False Blob already false; 6. Try to close your DataSet on each changing Tabs This I can try BTW : • what are your DB access Components (FireDac, IbDac,....?) FireDac • RDBM ? SQL Server Standard 2019 • Are you using BLOBs ? No • Size if your Tables ? Max is 23,000 rows , most are less than 1000 Thanks !

Just resurrecting an old thread. This process works great ! Only question I have is how can I determine the state of the checkbox when iterating through each row on the grid? The end user can check and uncheck each box or this can be done programatically by setting the cell contents. However having the user check or uncheck doesn't appear to be linked to the cell contents. While they appear just fine on the screen ,the cell contents are blank. So probably a client-side process?

Thanks . I did try that but the results are the same. I am sure I changed some setting by accident. As mentioned I have used these before with no problem . It works great as long as none of the queries are active but as soon as they are, some pages randomly generate blankly. The other odd thing is I have form that is shown modal It does not have an active query attached. The button to open the form is situated on the first tab page . I can click that button many times and the modal form is rendered just fine. However if I click on one of the other tab pages and then come back to the first page and click on the button, the modal form now just renders blank.

OK I am 99% sure this is related to the opening of various tables and queries that populate the grids. If I don't open the tables initially upon the application launch , all the various pages display fine. I think opening the queries is affecting the display of the pages/components. Where is the best place to launch the queries that don't affect the display? Thanks

Unfortunately no. I have used the UNIGUI page control in a number of other apps and it has always worked fine. So there is something specific I have added to this version that is causing the issue and I have not been able to isolate it to the point of making a simple testcase. In fact this was working fine until just a few days ago. I can reproduce it in the test environment but its random on which page is blank. There are no errors in the logs or indication of stress. The only difference I can think compared to the other apps is that this is database intensive in loading all the grids so perhaps there is some simple timeout that is occurring. I have tried the screenmask on or off and with various settings but it has made no difference .

So add to this, the problem occurs in both design time and run time. No errors are recorded. The app will also , occasionally appear to hang on startup. The data grid is populated but the screen suddenly assumes a slight opacity and a blue horizontal bar appears across the screen. I don't think the app is stopped but there is no further interaction with the browser possible.

This is a very broad ask, so I am hoping someone might have experienced it before. I have a UNIGui application with a UNIPageControl with 5 tabs on it. Each of the pages can appear blank at random times. The default page always displays. However switching to another tab shows it completely blank. I can switch back to the original and content is there or to one of the other tabs and it contains content. I can refresh my page then the blank page is restored but one of the other pages is blank. Sometimes they all work, but more often than not 1 or 2 of the 5 tabs show blank. Each page has a UNIDBGrid on it. The grids are activated when the application starts. This was not an issue for weeks but it suddenly started happening. Any suggestions would be helpful.

It may be an old topic now but I have the exact same problem. The first non-fixed row of my UNIStringGrid is blue. Its always blue, no matter which row you select or which row your are focused on. Its such a dark blue that is difficult to read any text in that row. Its easy to reproduce. Add a UNIStringGrid. Set rowcout to anything greater than 0. Run the application. Look at the grid. This does not appear at design time , so it seems almost a theme issue. I have triton.modified as the theme but it happens with any theme, Did anyone come to a solution?

I guess I am new to this. I did set up a calculated field and assigned it to the column and it displays fine but setting the state of the checkbox causes an attempt to update the attached dataset which fails on a calculated field.

Is it possible to have a CheckBoxColumn in a UNIDBGrid NOT connected to a field but still have it react to client input? In my case I want to display data from a table in rows. I want a checkbox column that by default are all unchecked. The user can then check some of these boxes without changing any background fields data. Later the user can click a button that iterates through the rows in the grid, finds the checked items and performs some action without altering any of the underlying data. Thanks Peter

Thank you both very much for the response. The test case is pretty simple. I drop a TUniLabel on the project, insert '12345678' in the caption field and select font "Code 128" from the drop down list. The label displays as a barcode in the IDE . However when I run it , the font changes to an alternate font. Inspecting the element within the browser displays "font-family : Code 128; " with a warning and the message "invalid property" I am showing my inexperience here. I modified the addition to reflect the correct font as below @font-face{ font-family: "Code 128"; src: url("../fonts/code128.ttf") format("truetype"); } When you say add to css(customcss) I am assuming you mean the CustomCSS property in the ServerModule? Within the style tags? You say font files must be included in the root. Since this is running in Server mode I think you mean in the projects exe root, for example c:\my barcode project files\Win32\Debug\ would be my root in this case? I have created a 'fonts' folder in this root folder and added the Code128.tff files. I have done as you suggested using the information you provided, but I am still not seeing the barcode and am getting the same invalid property warning. Does the TUnilabel need to be linked to the CustomCSS using LayoutConfig>CSS property or should it automatically find it based on the common font name? Thanks Peter

I need to display a TUniDBText as a barcode. I have a Code 128 ttf font installed on the server. At design time the font displays correctly but in local debug mode it reverts to the default font, probably Tahoma. This in on the same desktop where development is occurring. What am I doing wrong? Thanks Peter