On Oct 16, 2013, at 7:20 AM, Darren Duncan wrote:
> On 2013.10.14 11:58 PM, Sqlite Dog wrote:
>> seems like SQLite is not checking trigger SQL for invalid column names
>> until execution?
>
> What you describe sounds like the behavior of every SQL DBMS which has
>
On 2013.10.14 11:58 PM, Sqlite Dog wrote:
seems like SQLite is not checking trigger SQL for invalid column names
until execution?
What you describe sounds like the behavior of every SQL DBMS which has triggers
whose trigger behavior I know. Seems better to me to retain this behavior than
to
Paul Bainter wrote:
>
> When I run the program on the target machine, the main window comes up
fine
> because it doesn't access the database, but once I bring up a window that
> does access the database, I get a message stating that the application has
> stopped working. No error message
I'm having a terrible time trying to deploy my SQLite application. I
downloaded from System.Data.SQLite.org the file:
sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe and installed that on my
development machine (Windows 7 Ultimate x64). I actually have 2 development
machines, a laptop and a
Hi,
As I've learnt more about how to use SQLite (mainly from looking at this
mailing list), I've realised I've coded somethings in a less than an
optimal manner .
One of the things I've realised is that SQLite has a timing system built into
accessing the database, so that if things are busy
techi eth wrote:
You should compile your code & sqlite3.c with -g -O0 when
sending a stack trace.
Most likely, the bug is in your program. Since you're on Linux,
try running with valgrind memcheck tool to find bugs (access
to free memory, uninitialized memory, etc.)
If you compile with
Hi,
I have a FTS4 table that contains entries in multiple languages (using the
languageid option). I also have a spellfix1 table that I use to search with
misspelled words on the FTS4 table. In the spellfix1 documentation a fts4aux
table is used to fill a spellfix1 table based on a FTS4 one.
I'm not an sqlite3 dev, but I don't think you'll get much help until you
provide enough information for somebody to see what is going wrong. You
were already asked to provide a backtrace from a debug-compiled sqlite3
library (the backtrace you sent is all but useless).
A self-contained .c
Hi,
I have sqlite running with multiple connections to databases (and perhaps
even multithreaded). I am using a simple error logging callback function to
display additional information while I am hunting down a problem with some
databases. What I really want to be able to do is have the error
Sqlite Dog wrote:
> seems like SQLite is not checking trigger SQL for invalid column names
> until execution?
No.
> Is there a way to force this check?
Not without compiling the respective INSERT/UPDATE/DELETE statement.
> The problem: trying to find out which indices, triggers and views
Hi,
seems like SQLite is not checking trigger SQL for invalid column names
until execution? Is there a way to force this check?
The problem: trying to find out which indices, triggers and views depend on
particular column. We can recreate table without this column and recompile
indices, triggers
11 matches
Mail list logo