Sonjli

Thank you very much. I try.

I use a multi database framework that need to do its queries using the schema name. It supposes that I can have many dbs and that I can mix tables in SQL, like all schema-based db does (SQLServer, Oracle, etc.) example: select dbusers.dbo.users.name, dbauth.dbo.athentications.read, etc.

How do you make it work with FireDAC? Do you use two connections? Can you better explain with examples? Thanks

Hi, Embarcadero will probably no more support the .net formatter, so the GExperts one is the best on the market. I am studying it and looks very good, with some small lacks. Method params Is it possible for the formatter to format method parameters one per line? The Delphi default formatter can do this. Example: // not formatted procedure myproc(const a: string; b: integer); // formatted one per line procedure myproc( const a: string; b: integer); Blank lines Is it possible to remove these lines? // not formatted procedure myproc(const a: string; b: integer) var a: integer; begin end; // formatted, the blank line remains procedure myproc(const a: string; b: integer) !!! <---- var a: integer; begin end; Thanks (more to come... )

Hello, I have a Firebird table with hundred millions of record as time series. For example: DateTime: 01-01-2023-10:00 Data: Some fields with amazing data 🙂 Now I have to made some analysis on them and I am looking for a good system to extract data and build some "datamart" or snapshots or whatever you want. I was looking for Apache Hadhoop that looks great for my scope, but I have not experience and I'd prefer some Delphi-istic solution. Great ideas appreciated, Thanks

Premise: this is a question on "how to" and not specifically about the IDE. I see that IDE runs some separated processes of the LSP server. - How is this made? - How can IDE "talk" with these sub-processes? - I can also kill these processes and the system continues and also re-run them, how can it be? Thanks in advance

Thank you. My question is more stupid and generic. I am not specifically interested with LSP... How can I run my Process with "children" processes as the IDE does with LSP? I am usual to run tasks or threads but I don't see them in Windows "Task manager"

Hello, I hope not to be out of topic... I have a COM client (developed as NTService) that every 5 minutes need to reconnect to server (don't ask me why... the COM server kick out clients for "security" every 5 minutes). In every "connect" I do this: OleCheck(CoInitializeEx(nil, COINIT_MULTITHREADED)) Can this be a problem? I see that sometimes, after 30/40 reconnections, the COM server seems "locked". No other clients can connect correctly to the server until I kill my NTService. It is not fault of the "security" system, because I still tested that. Any ideas? Ask me for infos if you need. Thanks in advance, Eddy

Hi, I search for this topic all along the forum without success, so I ask here hoping someone answer me... I make a simple one form application in FMX (HD form, not 3D) I add TStyleBook Set the UseStyleManager := True Download a style from GetIt (for me "Stellar") Double click on SB Open the style editor Load the (Android) stellar style First question: The stellar style has a file .style for every platform, why? I want one style for all platforms I copy and paste the Android platform style to the default style and delete the android one Here for many times, when I close and reopen the project the IDE says "Android style not found"... why? I start the app in Win32: every form is perfectly styled I start the app in Android: all messed up No controls at all or, sometimes, default android style, why? If I re-add the android platform to style then Android goes well Windows platform uses the "windows" style if present, else the "default" style Android platform uses the "android" style if present or nothing. The default style is not taken at all I have D11.3, Android 11/12/13 on some oppo phones. That is. This is a stackoverflow thread from the well known Dalija Prasnikar mvp: https://stackoverflow.com/questions/61534033/what-is-the-purpose-of-the-default-platform-marker-in-the-list-of-tstylebook-s Thanks for any help Eddy

I understand. I opened a .style (thanks, I didn't know now they are text...) and found the "target". It is clear. So this means that is always better to keep separated TStyleBook for different platforms or maybe always to have separated platforms in a TStyleBook. This also means that "default" platform is pretty useless... do you agree with me?

Hello, I need to override the constructor of the main form of my FMX application. The problem is that the mechanism that fmx uses to select the main form is very strange and the constructor of the main form is never called. Anyone knows why this behaviour? Thanks! Eddy

I am very sorry. I will close this post. I found my horrible mistake... shame on me

Hello, I have a strange behaviour when I add a new parameter in a method. My method has 2 params like this procedure TForm1.Test( const par1: Integer; const par2: string ); begin // ... end; I add the new param with The result is a wrong formatted code: procedure TForm1.Test(const Par1: Integer; const Par2: string; const NewParam: Integer); begin // end; The more params there are, the worst is the formatting... I would like to maintain the same formatting for my params. Any hint? Thanks, Eddy

Hello, I attach a stupid D11.2 project with FD on MySQL compiled in 32 and 64 bit windows. Simple connection to mysql using libmysql.dll 32 and 64. With 32 everything is ok, with 64 it is not working. Before you ask: - FDDrivers.ini is located only in one place with nothing inside (it is the base embarcadero file) - In the source you can see my connection params - I don't use TFDPhys... because I want my exe to use local (same exe path) DLLs - I followed Embarcadero guidelines (vs2015 runtime, etc.) - I tryed with libmysql.dll from 8.x and 5.x (also the 5.7.29 as Embarcadero says), but same bad results Link to archive: https://we.tl/t-8ydNpkhi5u (If link is gone, tell me!) Any idea? Thanks

Hi, Thanks. Did you try to download the 7z archive and run the executable at Win64? It is not running on any machine. I did the VC2015 setup and set the VendorLib, too, but nothing changes. Win32 is ok, Win64 give the error: [FireDAC][Phys][MySQL]-314. Cannot load vendor library [libmysql.dll]. The specified module could not be found. Check [libmysql.dll], which is located in one of the PATH directories or in application EXE directory.

Hello. I am using RTTI to loop trough attributes. If I do this I get FALSE with the IS operator. I premise that "Attribute" is surely and absolutely "MyAttributeOne" class. if Attribute Is MyAttributeOne then IsMyAttributeOne := True But if I do this if Attribute.ClassNameIs('MyAttributeOne') then IsMyAttributeOne := True Then I get a wonderful TRUE. Any idea about this? Thanks Eddy

Yes. It is. I hadn't noticed before. Thanks

Ok Uwe. If you don't want to want to solve this simple issue for a poor, poor programmer, I'll do it myself Seriously, I understand. So I found a configuration for the standard formatter I share for others if they find it useful: This solve my terrible () problem wtih MMX. Thanks Uwe

UsesHelper is a drug 🙂 Please, I miss it in D11. Sources at least?

Hello, I have a task with three nested loops using an XML library to read some parts of a big XML. This loop is too tight and processor works between 20% and 30% only for this process. The "sleep" is not a solution because the XML must be read very quickly. Is there any other solution to avoid the use of so much processor? Thanks, Eddy

I don't know if this is the right place. Sorry in advance if I did a mistake. - Delphi 10.4.1 - GExperts 1.3.18 - Always when close appear an error similar "Error in expert 18". It is favorites file - After this error, Delphi never closes and a lot of AV comes from hell 🙂 - Tried to disable the expert with no success - I have never used this expert - I removed from DPR of the last SVN commit all the uses about favorites and recompile - No more errors

Hello, I don't know how I can pass an anonymous function inside a omniTask. Example: type TMyObject = class [...] end; TMyFunction = reference to function(const Arg1: string): TMyObject; var lFunc: TMyFunction; procedure Something; begin lFunc := function(const Arg1: string): TMyObject begin result := TMyObject.Create(Arg1); end; CreateTask( procedure(Task: IOmniTask) var lthdFunc: TMyFunction; lResult: TMyObject; begin lthdFunc := Task.Params['MyRefFunction'].As???; // <-- What here? lResult := lthdFunc('dummy'); [...] end ) .SetParameter('MyRefFunction', lFunc) .Run; end; Thanks in advance, Eddy.

The marvel: if ThereIsAnError then begin ShowMessage('This is the error'); Abort; end; All exceptions in a big project with this simple, magic trick... I had to work 2 weeks to change all the exception handling system.

Hello, I hope this is the right topic. I am looking for a tool for creating web dashboards starting from Firebird databases. I used some time ago Grafana (https://grafana.com/) but it has not driver for Firebird\Interbase and similar. Do you know any tool that permits the user creation of a query and customization of result data? I don't need a compelete BI, just a web tool to custom-create data analytics (pies, linears, etc) with Firebird. Thanks. Eddy

Thank you for Superset, it looks amazing!