[sqlite] sqlite.dll

On 3 Sep 2015, at 4:29pm, H?ctor Fiandor wrote: > I am using Lazarus and tables sqlite in an Application. It works fine. You're talking about the free version of the Pascal programming language ? I'm afraid that we don't know how it calls SQLite so we don't know what the problem is. From th

[sqlite] Variables in statements

I use a high level language to write my db applications (Livecode). It permits the use of replacement opertaors in sql statements, e.g. "SELECT * FROM myTable WHERE myKey=:1". I guess that's a standard way of doing things in SQLite. I'm having some issues with this and not sure whether it's a SQ

[sqlite] Query

On Thu, 3 Sep 2015 15:03:27 +0530, manash b wrote: >Hello, > > >I am using SQLite version 3.8.11.1 and PHP for my web application. > >Table *employee* has 4 columns. Last two columns have default NULL values. > >Insert query - > > > >*INSERT INTO employee SELECT 3 AS 'eid','manash' AS 'name' >

[sqlite] Query

Hello, I am using SQLite version 3.8.11.1 and PHP for my web application. Table *employee* has 4 columns. Last two columns have default NULL values. Insert query - *INSERT INTO employee SELECT 3 AS 'eid','manash' AS 'name' UNION SELECT 2,'ram'UNION** SELECT 1,'rahim'* Ge

[sqlite] Using |DataDirectory| in connection string (.NET with System.Data.SQLite)

Hello, I'm just starting to experiment with sqlite and System.Data.SQLite. How do they make use of the connection string |DataDirectory| macro? I've found lots of references online showing that it is indeed used, but I haven't found how to extract the file path from it at runtime. Given a conne

[sqlite] sqlite.dll

Dear members: Thanks very much. I have decided to start again other application from cero, and it is working well up to now. I expect to finish the copy of the app and hope it will work fine. Thanks again. Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu

[sqlite] Variables in statements

On 9/3/15, Peter Haworth wrote: > > SELECT * FROM myTable WHERE myKey IN (:1) > > If the value I supply to be used as :1 is a single integer, the SELECT > finds the correct rows. If the value is a comma separated list of > integers, e.g 1,2 the SELECT statement does not return any rows and no > e

[sqlite] Magic number in sqlite source code

Hello ! I was looking at this particular commit https://www.sqlite.org/src/info/0ea6e5c9fc6b1dd1 then I realize the usage of magic number through sqlite3 source code like the one bellow, it's not good practice to avoid then ? Cheers ! = case PragTyp_STATS: { static const char *azCol

[sqlite] sqlite.dll

This is my first request to the list. I am using Lazarus and tables sqlite in an Application. It works fine. I don?t know what happens (sure I have clicked something) and now, when I clicked over the .lpi file, don?t charge Lazarus and a message appears asking for a file sqlite.dll. I don?t r

[sqlite] Query

Hi, On Thu, Sep 3, 2015 at 5:33 AM, manash b wrote: > Hello, > > > I am using SQLite version 3.8.11.1 and PHP for my web application. > > Table *employee* has 4 columns. Last two columns have default NULL values. > > Insert query - > > > > *INSERT INTO employee SELECT 3 AS 'eid','manash' AS 'name

[sqlite] Magic number in sqlite source code

On Sep 3, 2015 4:17 AM, "Domingo Alvarez Duarte" wrote: > > Hello ! > > I was looking at this particular commit > https://www.sqlite.org/src/info/0ea6e5c9fc6b1dd1 then I realize the usage of > magic number through sqlite3 source code like the one bellow, it's not good > practice to avoid then ? G