'Access SQLite Database located in LOCALAPPDATA at design time
I am using FireDac in Delphi 10.3.2 Pro and would like to set the location for a SQLite database to %LOCALAPPDATA% at design time. How can I do this, or is it only possible to do this through code at runtime? Here is an image of what have already tried. I get "[FireDac] [Phys] [SQLite] ERROR: Unable to open database".
Solution 1:[1]
The value of %LOCALAPPDATA% is only meaningful at runtime. You need to resolve it to an actual path, and then use that path to specify the database file to open.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Remy Lebeau |