-
Content Count
99 -
Joined
-
Last visited
-
Days Won
1
weirdo12 last won the day on July 13 2023
weirdo12 had the most liked content!
Community Reputation
16 GoodTechnical Information
-
Delphi-Version
Delphi 12 Athens
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Thanks for the update.
-
FireDac Array DML Update query - omitting certain fields
weirdo12 replied to Mark Williams's topic in Databases
If you want to be as flexible/portable as possible you could consider using a FireDAC macro like this: email = { fn IFNULL(:EMAIL, email) } -
FireDac Array DML Update query - omitting certain fields
weirdo12 replied to Mark Williams's topic in Databases
😄 So just supply the current value when the value doesn't change. I do like the statement that uses COALESCE because it makes it very obvious that that is what is happening. Are you targeting a specific database server? -
They are retooling the C++ compiler chain. I get the impression that C++ is becoming more important - not less - even if it might seem like a 2 steps forward, one step back (for the moment). My gut feeling is the future has never been brighter for C++Builder.
-
FireDac Array DML Update query - omitting certain fields
weirdo12 replied to Mark Williams's topic in Databases
Why not just supply the current value where you don't want a value to change? -
Thank you, Roger.
-
FYI - Several Embarcadero services are currently unavailable
weirdo12 replied to Keesver's topic in General Help
We still use an old Northern Telecom phone system and have an operational fax machine on a stand alone line here at work here in Toronto. 😄 -
FYI - Several Embarcadero services are currently unavailable
weirdo12 replied to Keesver's topic in General Help
Great to hear that things are getting fixed up! -
FYI - Several Embarcadero services are currently unavailable
weirdo12 replied to Keesver's topic in General Help
I'm still surprised it hadn't been mentioned already as a possible cause... -
FYI - Several Embarcadero services are currently unavailable
weirdo12 replied to Keesver's topic in General Help
I just did a search of the terms 'ransom' and 'ransomware' and they haven't appeared in this thread. I'm kinda surprised. 😉 You'd think that the documentation would be back up by now. -
FDTable: EFDException with message '[FireDAC][Stan][Eval]-117. Empty expression'
weirdo12 replied to Stano's topic in Databases
Thanks for the update. -
You can build your file name like this as well: var file_name : String; file_name := TPath.Combine('D:\Delphi_11_Community\MyProjects\Dinobase\dino_images', sName); file_name := TPath.ChangeExtension(file_name, "jpg"); dinoImage.Picture.LoadFromFile(file_name);
-
Drop a TFDQuery component on your form. If it's the first one, it will be named FDQuery1. Set FDQuery1.Connection property to the TFDConnection you use to connect to the SQLite database. Then, in your code, replace Query. with FDQuery1.
-
[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
weirdo12 replied to gkobler's topic in Databases
In the version that works, what happens if you don't call fdqImportData .Close after copying the data to the TFDMemTable? -
[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
weirdo12 replied to gkobler's topic in Databases
I'm glad you found a solution. You could have a look at this thread and see if there's anything that might help with the original problem: