RE: [sqlite] a c++ newbie question

Does anyone have any experience compiling SQLite to run in the Micrium operating system on an ARM9 platform? http://www.micrium.com/ Thank you. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-831-7544 (work) 860-508-5015 (cell)

[sqlite] SQLite on the Micrium OS on an ARM9

Does anyone have any experience compiling SQLite to run in the Micrium operating system on an ARM9 platform? http://www.micrium.com/ Thank you. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-831-7544 (work) 860-508-5015 (cell)

RE: [sqlite] How to unsubscribe from his group?

I don't think Dr. Hipp has a tech support center ;). Be patent. In my experience, he reads these emails and will fix whatever needs fixing on his end. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-831-7544 (work) 860-508-5015 (cell)

RE: [sqlite] Database Commoditization and SQLite

A "commodity" is something which is indistinguishable by brand (e.g., wheat, oil, frozen orange juice). Calling SQLite a commodity is a misnomer. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-831-7544 (work) 518-763-6549 (cell) -Original

RE: [sqlite] LEMON

http://www.hwaci.com/sw/lemon/lemon.html Sorry if this link has already been pointed out to you. http://www.webdotdev.com/nvd/server-side/c/lemon-parser-generator-tutori al.html Looks OK but I have not looked at this site before. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204

RE: [sqlite] LEMON

: [sqlite] LEMON Lemon generates C files that could be compiled in Win or Linux Right? On 29/12/06, Downey, Shawn <[EMAIL PROTECTED]> wrote: > > http://www.hwaci.com/sw/lemon/lemon.html > Sorry if this link has already been pointed out to you. > > > http://www.webdotdev.com

RE: [sqlite] cant sum rows

I think you created a column in table1 named "int" of type "id". Try: CREATE TABLE table2 (id int); Then sum() should work. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -Original Message- From:

[sqlite] Sqlite3explorer can't open my DB

Version 1.4 of Sqlite3explorer could not open my database. The error message is: 4:malformed database schema - near "to": syntax error An older version of Sqlite3explorer worked fine on this database. I am using sqlite.dll version 3.2.1. Does anyone else have problems with

RE: [sqlite] Sqlite3explorer can't open my DB

Thanks anyway. I solved this myself. Sqlite3Explorer is more particular about the table schema syntax than Sqlite. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Downey, Shawn Sent

RE: [sqlite] Sqlite3explorer can't open my DB

:56 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Sqlite3explorer can't open my DB Could you please let me know what the problem was ? I am the author of sqlite3Explorer, and perhaps I could fix it. > -Original Message- > From: Downey, Shawn [mailto:[EMAIL PROTECTED]

[sqlite] Ticket 923 status (missing quotes in 2.8.15 .dump...)

Hello, I recently had some troubles converting a database from v2.8.0 to v3.08 per the following commands (under Windows XP): sqlite ddg53.db .dump >ddg53.dump sqlite3 ddg53.db3 ".read ddg53.dump" The dump of the 2.8.0 database did not enclose varchar fields containing numbers with

RE: [sqlite] Ticket 923 status (missing quotes in 2.8.15 .dump...)

Message- From: Downey, Shawn Sent: Monday, July 11, 2005 4:07 PM To: sqlite-users@sqlite.org Subject: [sqlite] Ticket 923 status (missing quotes in 2.8.15 .dump...) Hello, I recently had some troubles converting a database from v2.8.0 to v3.08 per the following commands (under Windows XP

[sqlite] proper SQL DELETE syntax

What is the correct SQL syntax for deleting records from a single table based on a where clause with multiple table references? For example: Sqlite> DELETE from timeline where timeline.name=del_timelines.name and timeline.last_change<=del_timelines.last_change; SQL error: no such

RE: [sqlite] proper SQL DELETE syntax

<=del_timelines.last_change) Is this the only way to perform this sort of deletion in SQLite? Thank you all again. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Downey, Shawn Sent: Thursday, July 14, 2005 11

RE: [sqlite] proper SQL DELETE syntax

>> DELETE from timeline where timeline.name=del_timelines.name and >> timeline.last_change<=del_timelines.last_change; > >'Twere me, I'd do it like this: > >delete timeline >from del_timelines >wheretimeline.name = del_timelines.name >and timeline.lastchange <=

RE: [sqlite] proper SQL DELETE syntax

Thanks (everyone) for the guidance on this. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Austin Ziegler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 5:01 PM To:

RE: [sqlite] SQLite 3 manifest typing question

Sergey, I asked the mailing list about this issue last week but I did not get a reply. This problem is documented in ticket 923. I am still hoping someone could think of a work around or tell me if it is agreed that this is a bug (or not). Shawn M. Downey MPR Associates 632 Plank Road, Suite

RE: [sqlite] SQLite 3 manifest typing question

Thank you for your response. >Unfortunately for you, I believe that most peoples response would be, >either use 3.x... This is not an option. Importing with 3.x does not solve this problem. Although I think 3.x it could be modified to retain the leading zeros depending on the field type (e.g.,

[sqlite] Sqlite 3.2.3 use of Tcl_WideInt not defined in Tcl/Tk 8.3.5

I am building an sqlite3 library as part of a project. I just tried upgrading Sqlite version 3.0.8 to version 3.2.3. We use Tcl/Tk 8.3.5 and are sort of stuck with it. The new tclsqlite.c declares Tcl_WideInt which is not defined in the include files for Tcl/Tk 8.3.5. Can someone

RE: [sqlite] Sqlite 3.2.3 use of Tcl_WideInt not defined in Tcl/Tk8.3.5

te] Sqlite 3.2.3 use of Tcl_WideInt not defined in Tcl/Tk8.3.5 On Mon, 2005-08-22 at 10:51 -0400, Downey, Shawn wrote: > We use Tcl/Tk 8.3.5 and are sort of stuck with it. The new tclsqlite.c > declares Tcl_WideInt which is not defined in the include files for > Tcl/Tk 8.3.5. > Tclsql

RE: [sqlite] Sqlite 3.2.3 use of Tcl_WideInt not defined inTcl/Tk8.3.5

>> But this patch looks like it may work as well (for my purposes only). I >> inserted the following in tclsqlite.c just after the #includes: >> >> /* Added to support backward compatibility to Tcl/Tk 8.3 */ >> #include "os.h" >> #if OS_WIN /* This file is used for windows only

RE: [sqlite] Delete crashes with Version 3.2.4 in Windows XP

Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 11:14 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Delete crashes with Version 3.2.4 in Windows XP On Wed, 2005-08-24 at 10:56 -0400, Downey, Shawn wrote: > I am experiencing a repeatable cr

RE: [sqlite] Delete crashes with Version 3.2.4 in Windows XP

8-5015 (cell) -Original Message- From: Downey, Shawn Sent: Wednesday, August 24, 2005 11:36 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Delete crashes with Version 3.2.4 in Windows XP The database is in the mail (4MB). Thanks. Some additional background: A select with the same

RE: [sqlite] Delete crashes with Version 3.2.4 in Windows XP

Great! Thank you very much! > I see the problem. I'm working on the fix now.

RE: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes withVersion 3.2.4 in Windows XP

Dr. Hipp, I tested the corrected code from the command line with complete success. I did not perform any programmatic interface testing though. Thank you for fix and for the quick turn around. Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3

RE: [sqlite] any suggestion for the database file extension?mine is xxx.drh

I use .db3 At least one tool, Sqlite3Explorer, assumes that extension if I am not mistaken. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Huanghongdong [mailto:[EMAIL PROTECTED]

[sqlite] Redirecting stderr to a file

When working from the command line I can redirect the stdout to a file with the command .output. Is there a similar way to redirect stderr to a file? Thanks you. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell)

RE: [sqlite] howto exit ?

sqlite> .exit The "-->" indicates a line continuation. Usually you can terminate it with a semicolon or by closing a quote. This gets you back to the "sqlite>" prompt where you can type ".help" and ".exit". Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065

RE: [sqlite] sqlite 2.0 database

Download sqlite.exe (version 2.8.16 which has no numeric extension) from http://www.sqlite.org/download.html. >From the command line attempt to open the database: sqlite where mailto:[EMAIL PROTECTED] Sent: Monday, November 07, 2005 9:06 AM To: sqlite-users@sqlite.org Subject: [sqlite]

RE: [sqlite] sqlite 2.0 database

I would double check that the file I am trying to open is indeed the same file the Tcl app is accessing successfully. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -Original Message- From: Manuel Enache

[sqlite] Is it possible to determine if data is string or numeric inside a callback in C?

Does anyone know if it is possible to determine if data is string or numeric inside a callback in C++? I am using sqlite 3.2.7. Background: A table with no data type specified for a field may be populated with an unquoted number. For example: create table t1 (a); insert into t1

RE: [sqlite] sql problem

Using the LIKE qualifier instead of = will result in case insensitive matches. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -Original Message- From: manoj marathayil [mailto:[EMAIL PROTECTED] Sent:

RE: [sqlite] I need a SQLite3 Wrapper for Java.

Hello, I am new to sqlite and I wish to get the count of unique entries in a particular field. The table is created as follows: create table tablename ( field_id char(10) not null , fieldname char(100) ); create unique index findex on tablename (field_id); I get an error with

RE: [sqlite] counting distinctly

That syntax does not seem to work for the sqlite version I am using (2.8.0). I get the following: Sqlite> select count(DISTINCT fieldname) from tablename; SQL error: near "DISTINCT": syntax error Is this a know limitation in 2.8.0? I am sort of stuck with this version because

[sqlite] complex query question

Hello all, First let me say thank you very much for a very useful mailing list. I have a somewhat complex SQL query question. Given the table: CREATE TABLE times(name CHAR(32) not null, time1 CHAR(10), time2 CHAR(10),

RE: [sqlite] complex query question

] Subject: Re: [sqlite] complex query question - Original Message - From: "Downey, Shawn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 7:26 PM Subject: [sqlite] complex query question > The query should return exactly 3 record

RE: [sqlite] How are NULL values deleted?

Does the following schema: create table t(col1 text NOT NULL, col2 text NOT NULL, col3 text NOT NULL, UNIQUE(col1,col2), PRIMARY KEY(col1,col2)); State that the COMBINATION of col1+col2 must be unique? Or that BOTH col1 and col2

[sqlite] creating tables with multi-column uniqueness

Does the following schema: create table t(col1 text NOT NULL, col2 text NOT NULL, col3 text NOT NULL, UNIQUE(col1,col2), PRIMARY KEY(col1,col2)); State that the COMBINATION of col1+col2 must be unique? Or that BOTH col1 and col2

[sqlite] SQLite Advocacy

In our organization, my management is debating the use of SQLite vs. MS SQL Server 7 for an upcoming MS Windows project. Does anyone have any SQLite advocacy info I can use? Perhaps a link to an article? I am hoping someone had written something eloquent about SQLite's advantages such as its

RE: [sqlite] SQLite Advocacy

Greyhound Bus. Fred -Original Message- From: Downey, Shawn [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 8:28 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite Advocacy In our organization, my management is debating the use of SQLite vs. MS SQL Server 7 for an upcoming MS Wi

RE: [sqlite] SQLite Advocacy

Thanks everyone for there input. See below for the arguments I've compiled so far. Please let me know if I am incorrect on any of these items. Do we have any speed comparisons between SQLite and SQL Server 7? I do understand we are talking Apples and Oranges here. Never the less, I need to do

RE: [sqlite] SQLite Advocacy

(cell) -Original Message- From: Tim Anderson [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 12:44 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] SQLite Advocacy > -Original Message- > From: Downey, Shawn [mailto:[EMAIL PROTECTED] > Sent: 31 January 2

RE: [sqlite] SQLite Advocacy

Some good comments everyone. Thank you very much. Sorry to derail the technical discussions here to such an extent. I just wanted to say that I read everyone's replies and I am making most of the changes requested. Especially the good comments from cirisme - Thanks. And yes Dr. Hipp is