Jump to content

JarekZ

uniGUI Subscriber
  • Posts

    44
  • Joined

  • Last visited

Posts posted by JarekZ

  1. I am attaching the project. I apologize for its quality but I wrote at lunch;) you need to set up a database in MSSQL, set up a table and create a procedure. There is table.sql for that Connecting to the database in the config.ini file I have a test database with about 10 million records, I can send it.

    Mormot v1.18 is required for json support

     

    DemoUni.zip

  2. the basis is a procedure in the database simple example for MSSQL:

    create procedure Orders.Listaproduktow (@userid int, @ startindex int, @ countindex int, @ filter varchar (50))

    as

    begin

    Select * from Orders.products where name like @filter

    offset @startindec rows fetch next @countindex rows only;

    end

    Support for the @startindex variable in the application - increases or decreases by @countindex

    Bootstrap - added Ajax support which returns which page it wants to display.

    the example of the procedure is trivial but it is the key to speed.

    Well indexed table, proper SQL query, and it works very well.

    Of course, if you set @countindex to 100000, it doesn't make sense. I have @countindex set from 50 to 200

  3. Hello

    I solved it on the SQL server side. Procedures return only the data package that is to be displayed. DBGRID has been replaced with HTMLFrame + bootstrap-table. The size of the tables is about 30 million records. it works very well in my applications.

  4. Example
    loads the HTML file into unihtmlframe
    on button onclick adds a function that has to return JSON based on data from the database and display it in alert ()
    JSON is created e.g. by ADOQuery

  5. hello

    I'm using unihtmlframe on which I have a button. The button starts a JS function. How to make this function retrieve data from another function in the application ??

  6.         <video autoplay muted loop id="myVideo"  >

              <source src="files/video/my.mp4" type="video/mp4" />
        
            </video>

    this works in unihtmlframe and uniurlframe

  7. in CSS

    ._menugrupytwr .x-treelist-row-over, ._menugrupytwr .x-treelist-nav .x-treelist-item-selected > .x-treelist-row{
      background-color: rgb(50,64,78) !important;
    }

    ._menugrupytwr .x-treelist-item-text, ._menugrupytwr .x-treelist-item-icon, ._menugrupytwr .x-treelist-item-expander {
      color: black;
      font-size: 12px;
      font-family: helvetica, arial, verdana, sans-serif;
    }

    ._menugrupytwr .x-treelist-nav .x-treelist-item-text {
         line-height: 20px;
         font-size:12px;
         font-family: helvetica, arial, verdana, sans-serif;

    }

     

    ._menugrupytwr  .x-treelist-nav .x-treelist-item-icon:before,._menugrupytwr .x-treelist-nav .x-treelist-item-tool:before,._menugrupytwr .x-treelist-nav .x-treelist-item-expander {
         line-height: 20px;
         font-size:12px;
        font-family: helvetica, arial, verdana, sans-serif;

    }

     

  8. Hello

    I am writing an application for several companies. Loads css files in servermodule (as customfiles)
    The problem is that each of the companies wants to have slightly different colors etc.
    How to do it best ??

  9. hello

    I have a container panel at the FORM  - align=alTop and uniAlignmentClient

    In Containerpanel uniimage align=alLeft and unilabel align=alRight

    when launched in a browser uniimage ok in left but unilabel not left container

    how should the properties of the components be?

     

×
×
  • Create New...