[sqlite] problem compiling loadable extensions using Visual Studio

I'm trying to find the way to develop loadable extensions using Visual Studio 2005. I've started by using the "half.c" extension from the documentation. I'm compiling using this command: cl /LD /I. /Fmhalf.map half.c The compilation proceeds without producing errors. I get a "half.dll", and t

RE: [sqlite] PRAGMA table_info

This leaves you to parse the DDL from sqlite_master. Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 2:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] PRAGMA table_info Marco Bambini <[EMAIL PROTECTED]> wrote: > Using PRAGM

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

I'd like to second Dennis' earlier remarks, and add some of my own. One of my greatest hopes when I found SQLite (it's "value proposition") was in having a great little database that would operate in such a familiar way. By "familiar", I mean that it should execute the SQL language, and produc

RE: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?

Perhaps not a solution, but a workaround: Try coercing the data entering the table into a value recognizable as a real: Create trigger t_t1i after insert on t1 Begin Update t1 set a = 1.0 * a, b = 1.0 * b Where rowid = new.rowid; End; Create trigger t_t1u after update on t1 Begin Update t1

RE: [sqlite] NEW DATA TYPE IN SQLITE

Is the application written in the legacy language, or are you changing it, too? What language was/is it in? The TCL language library has the ability to link functions to the engine. Such functions can affect coercion of the data into a different type, so that storage and presentation of the data