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.

public Constructor Create(aOwner: TComponent; aQty:Integer; aFileName:string; aQuery:String; aTitle:string);reintroduce; end; procedure TStatsGridForm.Create(aOwner:TComponent; aQty:Integer ;aFileName:string; aQuery:String; aTitle:string); begin FsQuery:=aQuery; FiQty:=aQty; FsFileName:=aFileName; FsTitle:=aTitl; Caption := FsTitle + ' - Total records..' + IntToStr(FiQty); JobTickets.SQL.Clear; JobTickets.SQL.Add(FsQuery); JobTickets.Prepare; JobTickets.Open; ... end;

In this situation I would pass the parameters to the onFormCreate procedure. procedure TStatsGridForm.FormCreate(Sender: TObject,..,..,aQuery); begin fQuery:=aQuery .... JobTickets.SQL.Clear; JobTickets.SQL.Add(fQuery); JobTickets.Prepare; JobTickets.Open; ... end;

Always take care to put things in onShow. That can be called more often than you wish, unlike onCreate.

I like this one very much : All comments must be written in haiku format

Yes, must be. Just look how much time it takes on the server a 10+GB file (movie or such) is copying from one directory to another.. Here a few GB database backup costs about 20 seconds.

Instead of COBOL, I highly recommend to GExperts the IBM RPG Programming Language RPG is a high-level programming language for business applications, introduced in 1959 for the IBM 1401. It was one of my first professional programming language before using Delphi and it was a delight to program in columns.

So, if the message is because of a Windows update does that mean Rad studio has always asked for your location without the notification of Windows beforte the update?

Maybe you can read the clipboard with a timer and everytime the clipboard has a new "https://www.youtube.com" string you parse, add (see Remy) and start the video.

Which version of Comment-AI are you using?

No, you can start the implementation.