Alright, trying to set the scenario:
* I open/create a database
* I register a custom function called HASH (set to be deterministic),
tested and working
* I create a bunch of tables (if not exists)
So far, everything works fine.
Then, the troublesome create:
CREATE TABLE IF NOT EXISTS Programme
Thanks OBones!
Your link gave me the solution to why my code didn't work!
It was (of course) I who made an error in translating function
parameters from C to Pascal!
Best regards!
/Jörgen
sqlite-users-requ...@sqlite.org skrev 2012-09-24 18:00:
Re: [sqlite] Virtual tables are driving me insa
Hi all!
First off, my configuration:
Windows 7 Ultimate x64
SQLite3 v3.7.14 Amalgamation, compiled to DLL using VS2010
Used directives:
SQLITE_4_BYTE_ALIGNED_MALLOC (*)
SQLITE_THREADSAFE=2
SQLITE_OMIT_DEPRECATED
SQLITE_DEBUG (*)
SQLITE_MEMDEBUG (*)
(*) T
ailable version (3.7.12.1) under
SQLite Manager (Firefox / Iceweasel extension).
If you need any further help, please let me know.
Cheers.
Stefanos
____
From: Jörgen Hägglund <jor...@sirlucifer.mine.nu>
To: sqlite-users@sqlite.org
Sent: Sunday, June 3,
Hi all!
I have just recently discovered the strengths of foreign keys but now,
I've been banging my head against the wall for a couple of days.
I just can't figure out what is causing the error or how to get around it.
Here's the specs (simplified) of my DB;
create table if not exists a (id int
Hi all!
I'm not sure if it's my brain melting or what it might be... :-)
I have a table defined as:
CREATE TABLE IF NOT EXISTS History (Path TEXT UNIQUE NOT NULL, Hits
INTEGER DEFAULT 0)
Is there any way of making inserting data as follows;
- If Path does not exist in the table;
INSERT INTO His
Hi all!
I have three tables, one containing IP addresses as integers, lets call
it 'base'.
A second table containing IP ranges and the country code the range
belongs to. Lets call this 'IPtoCC' with the fields IPFrom and IPTo as
integers and CC as text.
Then a third, 'Exclude', containing countr
Hi all!
Anyone being able to give me some pointers on how to compile SQLite3
into dependency-free .obj's on Windows?
The only reason for this is to import it into Delphi, and dependencies
are driving me crazy...
It doesn't matter if You give me an example (or maybe project source(s))
in Borland C++
8 matches
Mail list logo