Die Holländer

I was just wondering why you use a cache list. I use a DBGrid in one of my projects and added the calculated fields as extra columns in the DBGrid and to the FieldDefs of the query. Also in my case there is a file read calculated field and I hardly see any speed difference while displaying the resultset of the databse including the calculated fields. So, I never have used a cache list and I was just wondering why you need one, but as Uwe explained that sometime you need a cache list if the process is too slow and probably if you don't use a DBGrid.

But a dataset like DBGrid or client dataset is caching the calculated field values, right?

And... why do you use a Dictionary and not the calculated field?

Just for interest.. >>Dictionary<ID, FileSize> How did you fill this Dictionary and why are you using it during the OnCalcFields and not using the extra calculated field from the resultset itself for displaying?

When creating a GUI for applications with database and business logic, using tab menus, like Ribbon component, with many buttons can lead to a lot of code in your form. Create at least objects with you database logic..

Edge also..

👍 Very nice place. Also quick bus to Amsterdam center nearby. Plenty of herring and smoked eel availble.

Is it always on specific SQL statements/queries, like the Select you showed? You can try not to lock those Selects by: 'select * from "myTable" where ..... with(NOLOCK)'; Just to see if the locking READ COMMITTED is the problem. See if the database drivers your users using are still the same.

Can you tell what your problem is?

Maybe because in design time you copied the toolbar from dmSharedImages module on your form. While pasting the toolbar on your form the IDE knows where the images are located. That's why you see on the form: Images = dmSharedImages.Images In Runtime your form has no connection to the dmSharedImages, so the images are ignored and they disappear.

python4delphi

Also for FireDac you need at least Delphi Enterprise. (Professional only FireDac local/embedded databases)

There are too much components to add them in a book. There are visual, non-visual and thirth party components. Are you talking about components native delivered in Delphi? (Which version of Delphi?) You have to explain what programming problem you want to solve before you know what components you need to use.

Right-Click on the webpage and "Translate to .....". (or where your browser has this option)

No, we are in the desktop application business and Delphi is by far the best using databases, reporting and whatever you think of to do. But if you want to step in the AI business and want to automate your calendar appointments, sort your e-mail and let AI book a flight for you then yes.