Re: [sqlite] Problem with Left Outer Join

On 5/20/2011 8:36 PM, Yves Plasse wrote: > I have two tables (msglog and msgtbl) I want do join together. On both table, > I have the following common fields: > > iDeviceId Integer > iGroupId Integer > iCodeIdInteger > tMsgText > > When I enter the following command, the table

[sqlite] Problem with Left Outer Join

I have two tables (msglog and msgtbl) I want do join together. On both table, I have the following common fields: iDeviceId Integer iGroupId Integer iCodeIdInteger tMsgText When I enter the following command, the table joins together but there is a lot of fields in msgtbl that I

Re: [sqlite] DB triggers update

Answering myself... It may be feasible to [with little code] catch schema changes that would invalidate DB triggers before committing them. I'm not yet sure how to do that without re-entrance, but that may be OK too (hey, OP_ParseSchema does it). At least I've an idea that might be worth

[sqlite] DB triggers update

I've a patch that has only one bug that I'm aware of left: in autocommit mode, a PRAGMA connect_triggers=1; will fire any connect triggers and any before commit triggers, but not any after begin triggers -- mildly annoying, but tolerable. Writing tests, however, I discovered something subtle and

Re: [sqlite] Interop DLL question

> Meanwhile, perhaps, if you rephrase your goal and post again here on the > list, someone with experience in your environment (I'm NOT one of > those) will respond. I'm _guessing_ that you _don't_ mean to ask for the > xcopy command syntax itself: > Correct - what I'm looking for is the ability

Re: [sqlite] Interop DLL question

On Fri, May 20, 2011 at 12:10 AM, Michael Yeaney wrote: > For the 1.0.72.0 (3.7.6+) package (x64), is there a stand-alone (mixed > mode) DLL offered anymore that does not require the interop library > (much like the 1.0.66.0 version? Not currently, as Shane mentions

Re: [sqlite] Interop DLL question

Switching to a "single format" greatly simplified things from an "administrative" point of view - giving us a consistent single "packaging" format across all platforms (Windows, Mono, Compact, ARM, etc.) - a support customer even specifically pointed out this made things much easier for them as

Re: [sqlite] Unable to load dll "SQLite.Interop.dll"

The setup packages available from here: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki are suppose to check if the MSVC runtimes are installed or not and install them. It's the main reason the packages are as large as they are. How did you install the SDS DLLs? Thanks.

Re: [sqlite] Better way to get records by IDs

If you just need them in descending order, i.e. not an arbitrary order, then "order by rec desc" will work. On 5/20/2011 7:23 AM, jose isaias cabrera wrote: > "Martin Engelschalk" on Friday, May 20, 2011 10:21 AM wrote... > > >> Hi, >> >> to order, you have to use "order by". In that case,

Re: [sqlite] Better way to get records by IDs

"Martin Engelschalk" on Friday, May 20, 2011 10:21 AM wrote... > Hi, > > to order, you have to use "order by". In that case, however, it gets > complicated. > > SELECT * FROM Jobs WHERE rec IN (87, 33, 27,2, 1) > order by case rec when 87 then 1 > when 33 then 2 >

Re: [sqlite] Better way to get records by IDs

Hi, to order, you have to use "order by". In that case, however, it gets complicated. SELECT * FROM Jobs WHERE rec IN (87, 33, 27,2, 1) order by case rec when 87 then 1 when 33 then 2 when 37 then 3 when 2 then 4 when 1

Re: [sqlite] Better way to get records by IDs

"Oliver Peters" on Friday, May 20, 2011 9:47 AM wrote... > jose isaias cabrera writes: > >> >> >> Greetings. >> >> I would like to get a bunch of records of IDs that I already know. For >> example, this table called Jobs, >> rec,...,data,... >> 1,...,aaa,... >> 2,...,zzz,... >>

Re: [sqlite] Better way to get records by IDs

jose isaias cabrera writes: > > > Greetings. > > I would like to get a bunch of records of IDs that I already know. For > example, this table called Jobs, > rec,...,data,... > 1,...,aaa,... > 2,...,zzz,... > ... > ... > 99,...,azz,... > [...] What about SELECT * FROM table

Re: [sqlite] Better way to get records by IDs

"Martin Engelschalk", on Friday, May 20, 2011 9:04 AM wrote... > Hi, > > you want this: > > select * from Jobs where rec in (1, 2) > > Martin Darn it! Thanks. And that is easier... :-) > Am 20.05.2011 15:00, schrieb jose isaias cabrera: >> Greetings. >> >> I would like to get a bunch of

Re: [sqlite] Better way to get records by IDs

Hi, you want this: select * from Jobs where rec in (1, 2) Martin Am 20.05.2011 15:00, schrieb jose isaias cabrera: > Greetings. > > I would like to get a bunch of records of IDs that I already know. For > example, this table called Jobs, > rec,...,data,... > 1,...,aaa,... > 2,...,zzz,... > ...

[sqlite] Better way to get records by IDs

Greetings. I would like to get a bunch of records of IDs that I already know. For example, this table called Jobs, rec,...,data,... 1,...,aaa,... 2,...,zzz,... ... ... 99,...,azz,... I know I can do this call, begin; select * from Jobs where rec=1; select * from Jobs where rec=2; end; and

Re: [sqlite] OSX building in xcode leading to crashing lib.

On 19 mai 2011, at 17:32, Chris Dillman wrote: > > > On 5/19/11 10:26 AM, "Richard Hipp" wrote: > >> On Wed, May 18, 2011 at 6:52 PM, Chris Dillman < >> chris.dill...@zenimaxonline.com> wrote: >> >>> Im having a lot of trouble getting a working build up and running. >>> >>

Re: [sqlite] OSX building in xcode leading to crashing lib.

On 19 May 2011, at 4:32pm, Chris Dillman wrote: > On 5/19/11 10:26 AM, "Richard Hipp" wrote: > >> The SQLite amalgamation would probably better >> serve your purpose. It's just two files: sqlite3.c and sqlite3.h. There >> is no configure script or makefile. No parameters to

Re: [sqlite] OSX building in xcode leading to crashing lib.

On 5/19/11 10:26 AM, "Richard Hipp" wrote: >On Wed, May 18, 2011 at 6:52 PM, Chris Dillman < >chris.dill...@zenimaxonline.com> wrote: > >> Im having a lot of trouble getting a working build up and running. >> > >You are building from the canonical source code, consisting of

[sqlite] Question about SQLite Encryption Extension (SEE)

Hi, I have a question about SQLite Encryption Extension (SEE) add-on. I am using for develop a Visual Basic .NET v2010 with ADO.NET 2.0 and *System.Data.SQLite 1.0.72.0* for work with DB. If I adquire SEE add-on, it works correctly with *System.Data.SQLite 1.0.72.0*. Thanks for all! --

Re: [sqlite] Unknown parameter for prepare_v2

Forget my last post.. The error was that I didn't initialize pzTail to NULL... That's ok :) Dev_lex wrote: > > > Simon Slavin-3 wrote: >> >> >> On 19 May 2011, at 9:35am, Dev_lex wrote: >> >>> I need to prepare the statement before to know the name of the table, >>> but >>> I'll find an

Re: [sqlite] Unknown parameter for prepare_v2

Simon Slavin-3 wrote: > > > On 19 May 2011, at 9:35am, Dev_lex wrote: > >> I need to prepare the statement before to know the name of the table, but >> I'll find an other way.. >>> I would like to do this : const char *zSql = "INSERT INTO ?(ID, MyData)

Re: [sqlite] (no subject)

>Ah, there is a way to write it so that you can have at most one of >those constraints where only one makes sense, and not require a >specific order of constraints, but it'd require listing all the >possible orderings, which would be impractical. > >So if one wanted to enforce that there's at