Re: [sqlite] Subselect question

On Nov 3, 2008, at 6:39 AM, Ingo Koch wrote: > Hi, > > I've got a question concerning a query with subselects. > I have a table with stores pairs of events. one of the events is > kind of a start event and the other one is a stop event. > Each event is stored in its own row. What I'm trying to

Re: [sqlite] Trouble with Visual Studio Express

Yep. VS has a hell of time debugging and stepping through the amalgamated source. I use the split source for debugging purposes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, November 02, 2008 9:00 PM To:

[sqlite] Query Issues: Duplicates In UNION Query

Hi, I have been doing a Union query and would like to obtain distinct results. Via the manual, the correct way to accomplish this is to do a UNION statement (versus doing a UNION ALL). Problem: I want the order of the select statements left intact after the UNION select

[sqlite] Trouble with Visual Studio Express

Has anybody else had trouble debugging SQlite3 in Visual Studio Express? Here's what I have: Made a Visual Studio Express project, put the SQLite3 code in, added shell.c, put a breakpoint in sqlite3_exec, and ran the debugger (debugging argument goes through sqlite3_exec). No stop. Then I put a

Re: [sqlite] Subselect question

Firstly, perhaps you should be linking the start and stop event across a common id rather than relying on a start and stop appearing as consecutive entries. Without knowing more about where your database comes from it's hard to say. If you insist on keeping the current structure, here's a way to

[sqlite] Subselect question

Hi, I've got a question concerning a query with subselects. I have a table with stores pairs of events. one of the events is kind of a start event and the other one is a stop event. Each event is stored in its own row. What I'm trying to achive is to get a view which contains rows with the start

Re: [sqlite] Verifying install

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: > Can someone please tell me where I could start looking for the problem? You seem to be mixing system supplied SQLite libraries, your own compiled ones and Python SQLite module. It also looks like you are using a Mac. The

[sqlite] Verifying install

Greetings I just installed sqlite 3.6.4 without any reported errors. make check responded 'nothing to do'. I then installed python 2.6 also without errors. When I try to connect from within python, i.e., db = sqlite.connect("test.db"), it hangs. I have tried to use sqlite from the command