Remember that date('now') is the UT1 date, not the local (wallclock) date. To
get the date 'now' for the timezone in which your computer thinks it is located
you need to add the 'localtime' qualifier, as in date('now', 'localtime') ...
---
The fact that there's a Highway to Hell but only a
Running sqlite3 in an embedded Linux distributed environment.
Sqlite3 was built with Yocto and configured to be threadsafe.
One box keeps a master database and periodically will rsync the database to
remote boxes and send them a message to "update" their database.
When "update" message is
Upon thinking further about this bug, I realize that "correct" behavior is
not obvious and might warrant some discussion.
At first, I questioned whether it is appropriate to handle data differently
depending upon whether it is typed as BLOB or text. Maybe the edit()
function needed a flag for
On 2018/08/10 12:07 PM, Lars Frederiksen wrote:
In CMD I can write to my database without problems. Can you give me a hint
about what might be wrong with my OS-setup in Windows 10?
Thank you for the answer and your help! Much appreciated!
Usually the FireDAC connections work fine out the box,
Lars Frederiksen larshgf at dadlnet.dk wrote:
<
From here it was copied to a folder where my program exe-file is placed
when I develop. Using flashcard.db from this folder gave the mentioned
error.
<
I have to find out why it works like that!
You apparently deploy your .exe to a location which
Hi,
Right now I am not by my PC so I am not able to show you the settings in my
FireDAC. Hovever I found some kind of solution to my problem before "closing
down" yesterday:
A few days ago I created my flashcard.db database in the sqlite console prg
located in a folder named C:/SQLite/. From
If you program is installed in the Program Files folder, then you should
NOT put any data files that need to be we written to (like a database)
in that directory, as it is a violation of Microsoft protection rules.
Only privileged programs are allowed to write to files in the program
files
Hi Ryan,
In the meantime I solved my unicode problem by simply setting
FDConnection.StringFormat = unicode (I thought it was the default value but in
my environment I have to choose it actively. (I could also solve the problem by
choosing to use NVARCR instead of VARCHR)
So here are my
Hi SQLite-users,
I have in the console prg (cmd) created a small database in SQLite with only
one table (just in order to check out SQLite). The Table is defined like
this:
CREATE TABLE IF NOT EXISTS "Gloser"(
GRAESK VARCHAR(50) NULL,
DANSK VARCHAR(50) NULL,
LEKTION VARCHAR(10) NULL,
NOTE TEXT
This sounds like a windows file access problem that is not letting your
application access a file created in the context of a cmd box. Can you - from
the sqlite shell - insert the desired record into the database? And select it
afterwards? If so, then SQlite is working perfectly and it is your
Sorry I don't do Windows System Management. You need to take this question to a
windows developer support group.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Lars Frederiksen
Gesendet: Freitag, 10. August 2018 12:08
An:
In CMD I can write to my database without problems. Can you give me a hint
about what might be wrong with my OS-setup in Windows 10?
Thank you for the answer and your help! Much appreciated!
Best Regards
Lars
-Oprindelig meddelelse-
Fra: sqlite-users
12 matches
Mail list logo