Sonjli

48 minutes ago, weirdo12 said:

 

Why do you need to use the mydb schema name?

 

 

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.

16 hours ago, weirdo12 said:

schema-name == The database in which the new table is created. Tables may be created in the main database, the temp database, or in any attached database.

 

https://sqlite.org/lang_attach.html

How do you make it work with FireDAC?

Do you use two connections?

Can you better explain with examples?

Thanks

Hello,

I am trying to execute this SQL with FireDAC in D12 ent:

create table if not exists mydb.mytable (name varchar(100) unique not null);

With FDConnection.ExecSQL(...);

These are the params I pass to the connection:

DriverID=SQLite
Database=mydatabase.db
MetaDefCatalog=mydb
CreateDatabase=True

As I read in Embarcadero docs:

https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_SQLite_database_(FireDAC)

Well, the SQL with the "mydb" alias does not work. If I use "MAIN" (look at next sql) then it works, whatever "MetaDefCatalog" value I set!

create table if not exists MAIN.mytable (name varchar(100) unique not null); -- <-- WORKS!

create table if not exists mytable (name varchar(100) unique not null); -- <-- WORKS!

create table if not exists mydb.mytable (name varchar(100) unique not null); -- <-- DOESN'T WORK!

Thanks,

Eddy

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

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... )

2 minutes ago, Stefan Glienke said:

LSP has an official protocol though I don't know exactly which version and which subset Embarcadero supports - but it's enough to let you use it in VS Code.

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"

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

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?

Hi,

I search for this topic all along the forum without success, so I ask here hoping someone answer me...

1. I make a simple one form application in FMX (HD form, not 3D)
2. I add TStyleBook
3. Set the UseStyleManager := True
4. Download a style from GetIt (for me "Stellar")
5. Double click on SB
6. Open the style editor
7. Load the (Android) stellar style
8. First question: The stellar style has a file .style for every platform, why? I want one style for all platforms
9. I copy and paste the Android platform style to the default style and delete the android one
   1. Here for many times, when I close and reopen the project the IDE says "Android style not found"... why?
10. I start the app in Win32: every form is perfectly styled
11. I start the app in Android: all messed up
    1. No controls at all or, sometimes, default android style, why?
12. If I re-add the android platform to style then Android goes well
13. Windows platform uses the "windows" style if present, else the "default" style
14. 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 am very sorry. I will close this post.

I found my horrible mistake... shame on 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

On 12/14/2022 at 6:24 PM, RDP1974 said:

hi,

I have many 4.0 industry software made in D11x and MySQL

in Firedac I use libmysql.dll from the MySQL folder, this should be inserted in TFDPhysical vendorlib property

under Windows Server 2016, 2019, 2022 works fine

you have to setup microsoft visual c runtime before https://learn.microsoft.com/it-it/cpp/windows/latest-supported-vc-redist?view=msvc-170

 

 

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 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

14 hours ago, Uwe Raabe said:

Check if you have more than one declaration of MyAttributeOne.

Yes. It is.

I hadn't noticed before.

Thanks

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

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

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

UsesHelper is a drug 🙂

Please, I miss it in D11.
Sources at least?

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.

On 8/6/2021 at 5:55 PM, julkas said:

For web reporting I use Tibco.

Good option - Apache SuperSet.

Thank you for Superset, it looks amazing!

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

I try to better explain my problem. I understand the last question was a bit (lot...) stupid 😉

I need to know if the receiver task is alive.

In some cases the receiver task has gone so I continue to send messages to it and I receive this error: "TOmniCommunicationEndpoint.Send: Queue is full"

How can I avoid this problem? I would like to do something like this:

if not MyTask.IsDead then
	MyTask.Comm.Send(...)

// or

if WatchDog(MyTask) <> Dead then
	MyTask.Comm.Send(...)
    
// where WatchDog can check the healty of the Task and the MyTask.Comm.Writer.IsFull

Thanks in advance,

Eddy

Hi,

I hardly use tasks comm.

A very simple question: is this code right?

if lTask.Comm.Writer.IsFull then
begin
	lLocalLogger.Debug(Format('Task Queue is FULL %s...', [lTask.Name]), lSenderLogTagMain);
	Sleep(1000);
	...
end
else
	lTask.Comm.Send(WM_RECEIVE_DO, TOmniValue.CastFrom < IBroadcastMessage < TDataPacketBody >>(ABroadcastMessage));
...