-
Content Count
110 -
Joined
-
Last visited
Posts posted by Sonjli
-
-
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.
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...
- 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:
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
-
1
-
-
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.
-
1
-
-
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)); ...
FireDAC SQLite MetaDefCatalog
in Databases
Posted · Edited by Sonjli
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.