Stemon63

Hi Fred, any news on your Printer server with latest releases and features? (Websocket, etc...) I need it for "automate" client printers. But I need also the same, but for SCANNING service (Twain, etc..) from client to server.

Hi Fred, I'm clearly interested in your work on this topic. Can you provide me with details?

Hi Sherzod, I talk about a NO persistent data, but only for "temporary" cached operation (invoices, billing, etc.) Use of IndexedDB (or other technologies) is welcome.

Great! But I knew that. What I'm trying to suggest is creating a Delphi component (HyperDataset, for example) that encapsulates the Extjs DataStore (which HyperGrid and UniDbgrid already do) and makes it available to us at design time, to which we can connect the visual DB components (UniDbedit, etc.) and grids. Exactly as we do now with an FdQuery or any dataset. At that point, however, the dataset management is entirely client-side, with only the LoadData and ApplyUpdates events handled on the server. It goes without saying that I want a Unigui component 🙂 (By the way, I've already published a demo using the ExtJs Store for lookups) This completes the work already done for Hypergrid, but extends it to the dataset and therefore makes it accessible to DB components. Clearly, the control and calculation logic for individual records is handled in the client code, not managed by the server except when ApplyUpdate is performed (after the fact).

Hello Hayri, great news! But I talk also about a "HyperDataset", a kind of CLIENT dataset e datasource clones with DBeditor attached! Imagine a form with a grid and DB editors for CRUD, all client-side and with no interaction with the server during any operation (other than Load). Ultimately, the delta generated in the dataset can be sent to the server (ApplyUpdates) or deleted if the operation is rejected. This is exactly what HyperGrid already does, but performed by the dataset client. Essentially, all CRUD operations are entirely client-side, on a Store hidden into a HyperDataset. 🙂

Hi Sherzod, OK. But I need an "editing" scenario, a (comfortable) multirows data entry! 🙂 Any demo on this is welcomed

Okay Sherzod, let's analyze your different solutions: RowWidget in TUniDBGrid You can embed a custom container inside each row. Useful for displaying editable fields directly per record. Very interesting. Can I show only the container and not the "original" grid's row? Can we have a little example how to obtain this? (Can we obtain this also with Hyergrid?) Dynamic TUniContainerPanel per record In my opinion, this is the closest to TDBCtrlGrid. You can loop through the dataset and create a panel for each record. Use Bookmark for simple read-only data, or CloneCursor for full per-record data binding. Yes, but is very important to have a DB component which does all the databinding work for us! 🙂 Manual (non-data-aware) controls For lightweight displays, create TUniEdit, TUniLabel, etc., and assign values manually. This is the worst solution, especially in our case which has a lot of "DBware" fields For option 1 & 2, a working demo is necessary to verify the feasibility. Thanks

Hi, Any comments, suggestions, opinions, or anything else about my request? 🙂

Hi, Any comments, suggestions, opinions, or anything else about my request? 🙂

Hi, In a complex application, I need a tabular Data Entry, used also as Data Display instead Grids. For several reasons, this system is preferable to the traditional grid when dealing with fairly complex data entry: 1) It is fully responsive, so it can also be used on tablets and phones, without losing its functionality for the operator (with the grid, data entry becomes difficult, if not impossible, when switching between devices). 2) It is fully programmable: Editors and labels can be enabled/disabled, visible/invisible on a record-by-record basis depending on the logic of the data entered, with visible/invisible buttons or the display of other components depending on the displayed record. 3) The layout of the data displayed is free, allowing you to add text, diagnostics, change the color, or programmatically manage the logic of the individual selected record. 4) Input is managed by various Dbedits and DBTexts. It is essentially the web version of the Delphi component TDBCtrlGrid, with a panel for each record, a free-form layout, and the ability to edit the selected record. What you see in the photo is an example created with TMS Web Core in the testing phase. My question is simple: Is it possible to achieve the same in UNIGUI projects? Is it possible to create an advanced component that does the same thing? Basically, it's the component that eliminates the need for a DBgrid + separate form or panel required for editing, solving editing and displaying at the same time in an elegant way (and can be responsive). Any comments are welcome 🙂

Wow! Thanks!

Hi Sherzod, I tried it and it actually works with dgDontShowSelect=true. You were right! 😃 I take this opportunity to make my request: But how can I clear the selection list at runtime? (Or even assign the selection at runtime)? Thanks a lot.

Hello Sherzod, UniGUIVersion: 1.95.0.1595 ExtJSVersion: 7.8.0 But this is a problem already present from Years 🙂 Good Job

Hi, there are news on this problem? (First row is always checked on select column) Thanks

What I would like for Christmas in Unigui: After the first steps towards "stateless" in the management of HyperGrid, what is really missing to consider it a product for "Enterprise" applications is the complete management of the Crud only on the client (as an option). Keeping the "deferred" update approach (cached updates) I miss the management of the Dataset directly on the client side, to which to connect both the Dbgrid (or better Hypergrid, in this case) and ALSO ALL the DB editors. This option would allow us to move the entire CRUD cycle to the client, including data input and validation, before sending, all in one, all the changes to the server. What Hypergrid is now able to do, the "HyperDataset" should do 🙂 In this way, by managing the events of the dataset (unfortunately with Javascript code) we can have complete data management without "chatting" continuously with the server. (I discovered some users who enjoyed scrolling up and down the grids continuously to saturate the server 🥺 ). In practice, in a totally "stateful" system like Unigui we lack a data management part via dataset that is instead "stateless" until the operations are confirmed or abandoned. So I could manage thousands of users instead of hundreds, where most of the time only some specific CRUD functions are involved (invoices, inventory, registers, tax returns, billings, etc.). I hope Santa Claus listens to me... 🙂

In documented properties, events and methods there is no trace of Hypergrid 🙂 And a good documentation is necessary for an advanced component like Hypergrid, I believe. I will try your demos in the meantime. Thanks

I am looking for documentation on how to best use Hypergrid powered with standard datasets (Fdquery, Fdmemtable) and from Json (in the case of read-only lists, very fast to consult). In the case of datasets, how to use the batch update (one shot on confirmation/Apply update), but that does not talk to the server during the entire CRUD process. Clearly, the problem of calculations on the client in real time on rows (total=quantity*price) and the management of summary/totals remains (all client). Always the same problems, in short. 😄 I can do all this perfectly (all client side) in TMS Web Core projects, thanks to the totally client management of the datasets and obviously of the grids connected to them. But I can't with Unigui. The creation of a UniDataset component, totally client, and to which to attach Grids and free editors, would be a miracle, thanks to the Batch update operations. It would be like moving the bulk of the work to the client, especially in heavy Cruds (invoices, etc.) and obtaining spectacular performances, with many connected users. But I always say this, I'm repetitive. 🙂😄

no response?

Hi, where I can find "exaustive" documentation about HyperGrid? Thanks

Hi Fred, we are on the same wavelength. I'm not looking for a "persistent" dataset offline, which would still be very convenient using solutions like IndexedDB or Localstorage. Instead, I'm looking for the "cached updates" solution totally on the client. This allows you to carry out all CRUD operations on the client side (Insert, update, delete) and then transport them to the server when the job is finished. All with the aim of avoiding continuous chatting between client and server. Imagine 1000 users inserting continuously invoices with many rows. This is already ALMOST ready to work with HyperGrid, but there are some things wrong. It would take some javascript code to do checks and calculations in javascript directly on the client (there are no examples on this), and Hypergrid would not have to call the server on insert or delete records. But this only affects Hypergrid. Instead, what is missing is a totally client dataset to which to hook not only Hypergrid, but also all the other DB controls. Only in this way can I scroll the grid and manage the individual fields in DBedits, without loading them every time from the server. I hope I was clear, sorry for my english. In this way I would be able to manage thousands of users, as the interaction between client and server is very small. Ideally the clientdataset should load from a json (or from a dataset on the server, but directly json would be much more performant if the json comes from another source, such as a remote service DB) and return the json updates via a ServerApplyUpdates. In a distributed application, in this way, one would even avoid using the datasets in the Unigui server, which take up a lot of resources and remain open as long as necessary.

Thanks a lot!

Hi Fred, please update me on Json ClientTable. But an "adapter" with client components (better if DB Components) is very useful.

Hi Fred, I follow the topic with interest (but I don't know Node.JS). I want to see what good things you can come up with 🙂 Good job!

Hi Fred, "But there are lots of solutions coming up to Delphi/Rad." Do you have knowledge about new products or technologies that are coming out in the Delphi world? For the web, I use Unigui and Tms WebCore (which is improving gradually). Besides these, I don't know of any other system for producing truly professional Web applications of a certain level, and for a high number of users. (I also used Intraweb years ago for small projects, still works)

Sherzod, I'll explain it to you: he's looking for a single exe that contains both a web browser and the UNIGUI server itself. So that in a single .exe there is an autonomous webapp (localhost). Practically a simulation of a VCL app, but which instead contains a web client and the relative UNIGUI server.