[sqlite] CEROD in System.Data.SQLite

I'm working on switching our custom build of System.Data.SQLite from our custom build and am having problems opening a CEROD database. Going back over our code, I see that I wrote in Open(): // TU: Need to split out "cerod" prepend to filename before expandfilename string pattern

Re: [sqlite] recommended way to attach SQLite.Interop.dll

The new NuGet packages use MSBuild integration via a custom targets file to copy the interop DLLs to the "right" place at build-time. Sent from my iPod > On Feb 11, 2015, at 5:38 PM, E. Timothy Uy wrote: > > Hi, when I add the nuget package for System.Data.SQLite, I don't see the > interop.dl

[sqlite] recommended way to attach SQLite.Interop.dll

Hi, when I add the nuget package for System.Data.SQLite, I don't see the interop.dll. However, it is in the nuget packages folder. Am I supposed to manually link to this? Concerned about missing things if we update the nuget. Ideally it should show up automagically. (maybe I missed something) _

Re: [sqlite] visx for regular old windows

Ok, I don't see it. But that is good to know (about MSBuild) On Wed, Feb 11, 2015 at 4:22 PM, Joe Mistachkin wrote: > I've been told that MSBuild will use it but that VS will not show/"see" > it. However, after learning this I didn't verify. Things may improve in > VS 2015. Perhaps we can fin

Re: [sqlite] binding multiple values in a query

On 2/11/15, Igor Tandetnik wrote: > On 2/11/2015 5:46 PM, Jono Poff wrote: >> I wonder if anybody could give me a simple example in C to bind an array >> of values to a prepared statement? >>> > These approaches use stock capabilities of SQLite and don't require > heroic efforts (like patching sou

Re: [sqlite] binding multiple values in a query

On 2/11/2015 5:46 PM, Jono Poff wrote: I wonder if anybody could give me a simple example in C to bind an array of values to a prepared statement? The effect I'm looking for is sqlite3_stmt* stmt = Compile(db, "select * in Things where thing1 in ( );"); sqlite3_bind_???(s

Re: [sqlite] visx for regular old windows

I've been told that MSBuild will use it but that VS will not show/"see" it. However, after learning this I didn't verify. Things may improve in VS 2015. Perhaps we can find out from the CTP release? Sent from my iPod > On Feb 11, 2015, at 4:13 PM, E. Timothy Uy wrote: > > Does the visx for

[sqlite] visx for regular old windows

Does the visx for regular old windows actually work? After installing it I don't see anything in VS2013. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Library routine called out of sequence

On 11 Feb 2015, at 11:19pm, pablo Van wrote: > I have a problem with my delphi's application when I want run it on other > PC. I use ZeosLib in my application > The message is : Library routine called out of sequence What's happening is that SQLite relies on some calls being executed in a seq

[sqlite] Library routine called out of sequence

I have a problem with my delphi's application when I want run it on other PC. I use ZeosLib in my application The message is : Library routine called out of sequence How I can fix it? I need help urgent!!! please Thanks at all ___ sqlite-users mailing li

Re: [sqlite] binding multiple values in a query

Gr really? Thanks for the quick response tho! I'm already building it from source so I'll investigate! Cheers, Jono On 12/02/2015 11:53 a.m., Peter Aronson wrote: You can't do that in standard SQLite -- you can only bind single values. However, if you download the full source pa

Re: [sqlite] binding multiple values in a query

You can't do that in standard SQLite -- you can only bind single values. However, if you download the full source package (as opposed to the amalgamation) of SQLite, there are a pair of files under src, test_intarray.c and test_intarray.h, which implement a virtual table that would let you do

[sqlite] binding multiple values in a query

Hi, I wonder if anybody could give me a simple example in C to bind an array of values to a prepared statement? The effect I'm looking for is sqlite3_stmt* stmt = Compile(db, "select * in Things where thing1 in ( );"); sqlite3_bind_???(stmt,0 ,); Cheers, Jon

[sqlite] FTS5

Hi all, I found a previous FTS5 thread and, encouraged by the comments of Dan Kennedy, thought I would comment on the issue. - Smaller memory footprint and more speed is always great. I'm already very impressed with the speed but even faster is even better of course. My experience is that search

[sqlite] [ANN] ODB C++ ORM 2.4.0 Released, Adds Object Loading Views

I am pleased to announce the release of ODB 2.4.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major ne

[sqlite] Sqlite Virtual Table Example with non-trivial xBestIndex (was: Porting SQLite to another operating system (not supported out of the box))

Having personally written about a dozen virtual table implementations I can confirm that those implementations needing a nontrivial xBestIndex function are all based on building an SQLite interface on substantial proprietary storage subsystems like an in-memory ISAM table (with configurable rec