Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

If that is not an option, then you should probably create a function taking the HSTORE key and the sought key and returning the corresponding value or NULL. On Mon, Mar 17, 2014 at 11:41 PM, Tiago Rodrigues <wtrm...@gmail.com> wrote: > Generally, I'd suggest you take these HSTORE

Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

Generally, I'd suggest you take these HSTORE key-value-pairs types and recast them as a separate table (say, HSTORE (STORE integer primary key, KEY text, VALUE text) ) and then query (SELECT VALUE FROM {TABLE1} JOIN HSTORE ON HSTORE.STORE = {TABLE1}.{HSTORECOLUMN} WHERE VALUE = 'some_key';) On

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

INSERT INTO t1 SELECT 1 UNION SELECT 2 UNION (...) SELECT ; It works out of the box on any DBMS you care to name, and of course in SQLite, too. It is ever so slightly verbose, but better than the alternative of executing INSERT INTO t1 VALUES(###); Cheers, -Tiago On Mon,

Re: [sqlite] vbscript and sqlltie

Hi, Joe, Now, it's been years since I've touched VBScript, but I think the syntax of attributing the connection string to the Open method is wrong. You should probably use objConn.Open "Provider=System.Data.SQLite; Data Source=C:\DATA\SQLLite\mydb.db3" or (better)

Re: [sqlite] curious: Why no "shared library" or DLL?

On Fri, Aug 30, 2013 at 1:37 PM, Simon Slavin wrote: > > On 30 Aug 2013, at 4:46pm, Jay A. Kreibich wrote: > > > On Fri, Aug 30, 2013 at 03:41:18PM +0100, Simon Slavin scratched on the > wall: > > > >> The arguments against DLLs are not the normal arguments

Re: [sqlite] Newbie startup problems

Wenda, Clearly, in spite of you affirming having included the SQLite assembly in your references, the IDE isn't finding the SQLite package. If you say it's not a problem of "using ;" directive, then the reference must be pointing to a bad location (in this case it would get the standard

[sqlite] Implementing "Save As..." functionality for Application File Format usecase

Hello all, I'm writing a small simulation app and for it I would like to use SQLite3 as an application file format, as suggested by the "Appropriate uses for SQLite" page in sqlite.org. More specifically, the page suggests calling BEGIN TRANSACTION when opening a file and calling COMMIT when

Re: [sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

to everyone this doesn't help, then. Cheers, -Tiago On Mon, Jan 7, 2013 at 9:13 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Jan 7, 2013 at 4:18 PM, Tiago Rodrigues <wtrm...@gmail.com> wrote: > > > Oops, Dominique alerted me to the fact that the patch I i

Re: [sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

ntf(out,"void %s(void *,int,%s,%s);\n",name,lemp->tokentype,lemp->arg); + }else{ +fprintf(out,"void %s(void *,int,%s);\n",name,lemp->tokentype); +} +fprintf(out,"void *%sFree(void *,void (*)(void *));\n",name); +} fcl

[sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

Hello, all, First, forgive me if this is the wrong medium for submitting this, but I'm rather new at this patch submission business. Anyway, I was using Lemon to generate a few parsers for a program I'm writing (which uses SQLite, too, for storage), and I noticed that the files I used to call