[sqlite] Unable to create table, default value of column [ID] is not constant

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

Re: [sqlite] Virtual tables are driving me insane!

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

[sqlite] Virtual tables are driving me insane!

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 (*) (*)

Re: [sqlite] (no subject)

(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, 2012 11:10 PM Subject: [sqlite

[sqlite] Foreign key constraint failed

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

[sqlite] Help request for a query...

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

[sqlite] Need help constructing a query

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

[sqlite] Compiling without dependencies on Windows?

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