SwiftExpat

Sounds like it is not finding the database file, do it is starting with an empty database. Is the Drivers.db in the same directory as the EXE? If yes, then you need to set the working directory. Test it by going to a command line and running the Exe, and make sure in dir *.db your file shows.

Default in Firedac is to static link. To change it you add a TFDPhysSQLiteDriverLink component and then set the option. Valid point, depending on the data layer it is something to consider.

You just need to adjust the path on the db connection to allow for the path on the new machine. Options: TPath to build the path --preferred fdcsqlite.Params.Database := TPath.Combine(TPath.GetHomePath, 'RTTKCaddie.db'); adjust the file name to mydbfile.db with no directory and put it in the same directory as the exe fdcsqlite.Params.Database := 'RTTKCaddie.db';

Thank you for taking the time to write all of that up and identify each part. It is always nice to have a real world sample to reference

I created a plugin to terminate orphaned processes left behind by the IDE during development. You can see the demo here: Source and a release build are available here: https://github.com/SwiftExpat/Deputy Install it manually using these instructions: https://swiftexpat.com/docs/doku.php?id=rttk:deputy:install There is a gentle nag for you to download my compiled demo, which you can decline. The expert is built using TOTAL as a framework: https://github.com/DelphiWorlds/TOTAL If you want to build your own, a step by step to setup your project is here: https://github.com/SwiftExpat/Deputy/wiki/Step-by-Step---Create-Total-plugin-project Enjoy, SwiftExpat

Hello Ian, The etch-a-sketch lines were caused by Deputy having a line break in the license information for the splash screen. It was visible on my machine in 10.4, but not in 11.1 . A new version is available. 2.4.2. Currently it is manual update via a menu option in the IDE, instructions here: https://swiftexpat.com/docs/doku.php?id=rttk:deputy:update When you have a chance I would appreciate you trying the update and reporting back if the etch-a-sketch lines are fixed. Thank you in advance

Hello Matthias, I submitted https://github.com/DelphiWorlds/Kastri/pull/98 and https://github.com/DelphiWorlds/TOTAL/pull/6 to have the WizardFileName function exposed. I will track the PR's, until then you can use my forks to get the WizardFileName. https://github.com/SwiftExpat/TOTAL https://github.com/SwiftExpat/Kastri

Thank you for reporting the error. I will try to replicate and let you know if I need more information. At first glance I do not know what would conflict, but I will load it in the debug session and try to reproduce. This is the feedback I need, Thank you Ian

To make installation easier, Deputy is now available in GetIt for versions 10.3, 10.4 and 11.0.

Have you tried maskfpuexceptions: https://github.com/pyscripter/python4delphi/wiki/MaskFPUExceptions

Thanks for the good explanation above and taking the time to write it up.

Thanks for that, I was confused because i did not see a RTLVersion110 I can see what they did in 10.4. RTLVersion = 34.00; RTLVersion1041 = True; RTLVersion1042 = True;

Where is this defined, in the compiler?

Have you tried to finalize the variable? You have to call finalize before free. In my constructor: constructor TSERTCPythonEngine.Create; begin inherited Create(true); PE := TPythonEngine.Create(nil); PythonIO := TPythonInputOutput.Create(nil); PythonResultVar := TPythonDelphiVar.Create(nil); end In my destructor destructor TSERTCPythonEngine.Destroy; begin PythonIO.Free; PyMod.Free; PythonResultVar.Finalize; // prevent memory leak PythonResultVar.Free; PE.Free; inherited; end;

It all just depends on how secure that network really is, you just need to justify the open ports in the event of an audit. I have been on the network side and the developer side before. You should really start a discussion with the network team and have them tell you what requests the firewall / proxy are denying. I realize the network team can be rigid at the start of this conversation but from my experience with Oracle and MS products, it all depends on what features you use. Do not give up and prepare your manager for a slight uphill battle. You will need to determine what features in IDE need to work, lets take the welcome page for an example, do you need the youtube feed to populate? likely not. Do you use logging that connects out? Wireshark will get you the answer, but your firewall team already has that information in logs based on denials. Another option might be to investigate the GSA build and what is disabled in that. likely you will need to sign a NDA with your sales rep or the sales rep who services contracts that belong under GSA.

Can you send the number in QP? I am curious to see the detail.

That day was many years ago in various forms, your actions keep you recognized as a technical MVP. You @Uwe Raabe , and several (many) others here, demonstrate, by your actions and responses, that MVP can still be more than a marketing position. You will always get recognition as an MVP in my view, and I am sure by many others.

Check your unit scope names, it is under project, options.

I would agree with not much useful here. What is the threshold you are willing to allow for that memtable? What level of precision are you looking for? Task Manager / Perfmon will get you close enough.

I can reproduce using the Kastri demos and other projects & project groups. Seems like onclick has a different path than on keypress. I think it is reproduce-able enough to file it, Ill give it a vote. Even if it does not get fixed it is nice to have an explaination Great job on documenting the steps to reproduce.

Did you modify the layout, using the edit layout? You have likely found a bug and need to file it in QP. I would isolate it by starting without the Welcome page and choose file open project. If you do not get the exception, you know it is a bug.

It still works with 11.0, you can always click on "View" --> Welcome page. I used it yesterday to cut some time when I was debugging an IDE expert. The IDE loads a little faster, the welcome page really stumbles ( gittery to size the panes and the youtube video list takes a long time to load) on my system.

Have you tried running the IDE without the welcome page? The option is -np cd "c:\Program Files (x86)\Embarcadero\Studio\22.0"\bin c:\Program Files (x86)\Embarcadero\Studio\22.0\bin>bds -np

You should use the SQLite backup to copy that locked database to a clean file. That allows the SQLite apis to handle the recovery if there was a pending write transaction. Firedac has a component, so not much code to write. https://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteBackup

And samples if you go back to 10.3 offline help files.