Re: [sqlite] sqlite3.lib for ARMV4T processor

Dear Virgilio We now solved the problem of creating the sqlite3.lib file specific for ARMV4T processor, and able to run our application using the sqlite3.lib file that we generated for ARMV4T processor, thanks for your reply. Regards, kartthikeyan.s Virgilio Alexandre Fornazin-2 wrote:

Re: [sqlite] sqlite3 command line usage

Hi John, I don't think that the first command can combine meta-commands with SQL statements. But redirect stdin: C:\> copy con tst.cmd create table if not exists tst( c1 integer ); insert into tst values( 0 ); insert into tst values( 1 ); insert into tst values( 2 ); .mode line select c1 from

Re: [sqlite] sqlite3 command line usage

Or in similar vein if you wish the shell to remain running: C:\> sqlite3 tst.db ".read tst.cmd" 2008/6/13 Simon Davies <[EMAIL PROTECTED]>: > Hi John, > > I don't think that the first command can combine meta-commands with > SQL statements. > > But redirect stdin: > > C:\> copy con tst.cmd >

[sqlite] Question of reusable rowid

Hi, In an application I use the default 'rowid' column as identifier of objects stored in table. I found that if I delete the record that has the maximal rowid, the rowid will be reused when I insert a new record. This mechanism may cause mismatched data in my application because there're

Re: [sqlite] Question of reusable rowid

http://www.sqlite.org/autoinc.html Rgds, Simon 2008/6/13 Kang Kai <[EMAIL PROTECTED]>: > Hi, > > In an application I use the default 'rowid' column as identifier of objects > stored in table. > > I found that if I delete the record that has the maximal rowid, the rowid > will be reused when I

Re: [sqlite] Question of reusable rowid

Aha, AUTOINCREMENT ... Thanks a lot, Kevin > http://www.sqlite.org/autoinc.html > > Rgds, > Simon > > 2008/6/13 Kang Kai <[EMAIL PROTECTED]>: >> Hi, >> >> In an application I use the default 'rowid' column as identifier of objects >> stored in table. >> >> I found that if I delete the

Re: [sqlite] Math Functions

> The extension-functions file doesn't actually implement any of the > math functinos, it simply acts as a glue layer between SQLite and the > system math library. In this case, it looks like the run-time linker > that loads the extension can't resolve the call for log() from the >

[sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

Hi, Is there a way to do tuple comparisons in SQLite? Are there plans to support it as "SELECT (1, 2) = (1, 2)" in the future? Thanks, Taylor ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] table sqlite_extensions

Hello! How can I create table sqlite_extensions? I read http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions and try sqlite> create table sqlite_extensions ( ...> load INT, -- the order in which the extension ...>-- is to be loaded/initialized. ...>

Re: [sqlite] table sqlite_extensions

It appears that any table beginning "sqlite_" provokes "SQL error: object name reserved for internal use: sqlite_?" where ? is the text following "sqlite_" The articles you have referenced appear to be discussions of possible future enhancements. Rgds, Simon 2008/6/13 Alexey Pechnikov <[EMAIL

[sqlite] Structural detection of AUTOINCREMENT

Is there any way to detect, based strictly on querying the structure of a table/database whether there is an AUTOINCREMENT set? That is to say, without analyzing the original SQL creation statement, and without inserting a new element into the database. Consider: CREATE Table myTab (col1 INTEGER

[sqlite] Implementing fast database rotation

Hello, I'm using sqlite to implement a fast logging system in an embbeded system. For mainly space but also performance reason, I need to rotate the databases. The database is queried regularly and I need to keep at least $min rows in it. What I plan, is inside my logging loop, to do something

Re: [sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

"Taylor Basilio" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is there a way to do tuple comparisons in SQLite? Are there plans to > support it as "SELECT (1, 2) = (1, 2)" in the future? Why? Is there any DBMS that supports this syntax? What's wrong with SELECT 1=1 AND 2=2 ?

Re: [sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

On Jun 13, 2008, at 7:41 PM, Igor Tandetnik wrote: > "Taylor Basilio" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED] >> Is there a way to do tuple comparisons in SQLite? Are there plans to >> support it as "SELECT (1, 2) = (1, 2)" in the future? > > Why? Is there any DBMS that

[sqlite] sqlite3_free_table, ~get_table

Do calls to sqlite3_free_table have to be synchronised with calls to sqlite3_get_table?   In order words can one do: ~get_table a, ~get table b, ~free_table a, ~free table b   or does it have to be: ~get table a ~get table b ~free table b ~free table a   ?? Thanks,    

Re: [sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

"Taylor Basilio" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Jun 13, 2008, at 7:41 PM, Igor Tandetnik wrote: > >> "Taylor Basilio" <[EMAIL PROTECTED]> >> wrote in message >> news:[EMAIL PROTECTED] >>> Is there a way to do tuple comparisons in SQLite? Are there plans to >>>

Re: [sqlite] sqlite3_free_table, ~get_table

"Chris Holbrook" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Do calls to sqlite3_free_table have to be synchronised with calls to > sqlite3_get_table? > > In order words can one do: > ~get_table a, > ~get table b, > ~free_table a, > ~free table b Yes, one can. There's nothing

Re: [sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

В сообщении от Friday 13 June 2008 16:26:01 Igor Tandetnik написал(а): > "Taylor Basilio" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED] > > > On Jun 13, 2008, at 7:41 PM, Igor Tandetnik wrote: > >> "Taylor Basilio" <[EMAIL PROTECTED]> > >> wrote in message > >> news:[EMAIL

Re: [sqlite] tuple comparisons, SELECT (1, 2) = (1, 2)

"Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Â ñîîáùåíèè îò Friday 13 June 2008 16:26:01 Igor Tandetnik íàïèñàë(à): >> Are you sure? I can't find any such thing in MySQL nor ProstreSQL >> documentation. The closest I see is >> >> select ROW(1,2) = ROW(1, 2); >>

[sqlite] How compile libSqliteIcu.so and libSqlitefts3.so

Hello! I try: $ gcc -shared -lm icu.c `icu-config --ldflags` -o libSqliteIcu.so [EMAIL PROTECTED]:~/sqlite/ext/icu$ sqlite3 :memory: "SELECT load_extension('/usr/lib/sqlite3/libSqliteIcu.so');" SQL error: error during initialization: $ gcc -shared fts3.c -o libSqlitefts3.so [EMAIL

Re: [sqlite] Math Functions

On Fri, Jun 13, 2008 at 4:31 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: >> The extension-functions file doesn't actually implement any of the >> math functinos, it simply acts as a glue layer between SQLite and the >> system math library. In this case, it looks like the run-time linker

Re: [sqlite] Math Functions

On Fri, Jun 13, 2008 at 09:43:51AM -0400, Liam Healy scratched on the wall: > Interesting; I tried it on Debian sid (unstable) and it worked as > well. I guess the statement in > http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions that the > extensions loading mechanism being turned off by

[sqlite] rtree extension - Windows Binary?

Hi, I've recently created a database with latitude/longitude points in it, and now I need to search for points without a given rectangle. With 60,000 points I'm able to retrieve a rectangle of 50 points in ~1 second. This is way too slow, so I wanted to try out the rtree extension. However at

Re: [sqlite] rtree extension - Windows Binary?

Hi Andrew, Maybe this goes without saying, but I guess you've already worked on the "usual suspects" such as: -- An index for Lat and another for Lon. -- Larger cache -- EXPLAIN QUERY PLAN prefix to ensure that index used -- One-time VACUUM has any effect? -- ANALYZE -Original

[sqlite] Concatenate multiple rows into a set list(no duplicates) based on unique ID

Hello all; Any help, directions, or thoughts on this is much apprecaited. Let's say I have the following table: ID Value 1 a 1 a 1 b 2 c 2 a 3 a 3 c 3 b Is there a quick way in SQLite that will let me build a new table so that it is now represented where the ValueCombination is sorted such

Re: [sqlite] rtree extension - Windows Binary?

Griggs, Donald a écrit : > Hi Andrew, > > Maybe this goes without saying, but I guess you've already worked on the > "usual suspects" such as: > > -- An index for Lat and another for Lon. > -- Larger cache > -- EXPLAIN QUERY PLAN prefix to ensure that index used > -- One-time VACUUM has any

Re: [sqlite] rtree extension - Windows Binary?

Hi Donald, I have a index on both lat and long, but please correct me if I'm wrong, but I think SQLite will only use a single index per SELECT. So only one of the index is in use. I think the EXPLAIN command confirms this for me. I have not played with the cache size, but I have used VACUUM,

Re: [sqlite] Concatenate multiple rows into a set list(no duplicates) based on unique ID

On Fri, Jun 13, 2008 at 09:20:41AM -0700, gtxy20 scratched on the wall: > > Hello all; > > Any help, directions, or thoughts on this is much apprecaited. > > Let's say I have the following table: > > ID Value > 1 a > 1 a These dup records aren't cool and cause some additional issues below,

Re: [sqlite] rtree extension - Windows Binary?

Hi Noël, Sorry I wasn't clear... I don't have a windows compiler, hence being unable to compile it :) Andrew - Original Message - From: "noel frankinet" <[EMAIL PROTECTED]> > However at the moment I'm unable to compile it, so I was wondering if > anyone had a DLL for windows which I

Re: [sqlite] rtree extension - Windows Binary?

В сообщении от Friday 13 June 2008 20:38:42 Andrew Brampton написал(а): > Hi Donald, > > I have a index on both lat and long, but please correct me if I'm wrong, > but I think SQLite will only use a single index per SELECT. So only one of > the index is in use. I think the EXPLAIN command confirms

Re: [sqlite] Sqliite Command for appending the data to file

On Thu, 12 Jun 2008 10:48:11 -0700 (PDT), you wrote: > Hi all, > I need to dump the data to file in csv format and I have done the following: > sqlite> .output dataFile > sqlite> .mode csv > sqlite> select * from myTable; > sqlite>.quit > The data is dump to the file correctly but I want to able

Re: [sqlite] sqlite3 command line usage

On Fri, 13 Jun 2008 15:27:19 +1000, John wrote: >Hi > >I am trying to put multiple commands/statements in a command line args >list to sqlite3 (Win XP command line/batch file). > >This works (sq is alias for sqlite3.exe): >sq data\data1.db3 "DROP TABLE IF EXISTS list; VACUUM; CREATE TABLE IF

Re: [sqlite] Sqliite Command for appending the data to file

Thanks! It worked. Thanks a ton, JP - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Friday, June 13, 2008 11:50:12 AM Subject: Re: [sqlite] Sqliite Command for appending the data to file On Thu, 12 Jun

Re: [sqlite] Client/Srever SQLite

В сообщении от Monday 02 June 2008 19:40:58 Alex Katebi написал(а): > Hi All, > > I am using remote procedure calls (RPC) for SQLite in my application. I > have implemented a few SQLite RPC functions that I needed successfully. > I am wondering if there are other people like me who need this. >

Re: [sqlite] Math Functions

This all makes eminently good sense; thank you for the explanation. I have updated the comments at the head of the file and uploaded a new version, which is now at http://www.sqlite.org/contrib/download/extension-functions.c?get=25. Nothing in the code has changed, so there's no reason to download

[sqlite] Display all the columns of the table in single line.

Hi All, I ran the following select : select appName from appMapTable but I would like all the appName return as single row and seperate by comma. Can we do that using sqlite commands. Thanks so much. JP " ___ sqlite-users mailing list

Re: [sqlite] Display all the columns of the table in single line.

"Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I ran the following select : > select appName from appMapTable > but I would like all the appName return as single row and seperate by > comma. Can we do that using sqlite commands. select group_concat(appName) from

[sqlite] help with Dates please

I have several tables that i need to datestamp as transactions occur and then retrive with a select where between X and Y. What is the best way to do this in SQLite? Thanks Woody ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] SQlite and C works with "like" but not with "="

Hi guys, My first post to this list, and I'm new to SQL in general too. Just a couple of questions to start: ***1: In the sqlite3_prepare_v2 function, can someone explain to me the 5th parameter better than the site's help can? I quote: /* OUT: Pointer to unused portion of zSql */ I'm a bit

Re: [sqlite] help with Dates please

Harold Wood wrote: > I have several tables that i need to datestamp as transactions occur and then > retrive with a select where between X and Y. > > What is the best way to do this in SQLite? > Look at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions and ask again if you have

Re: [sqlite] SQlite and C works with "like" but not with "="

"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My first post to this list, and I'm new to SQL in general too. > > Just a couple of questions to start: > > ***1: > In the sqlite3_prepare_v2 function, can someone explain > to me the 5th parameter better than the site's

Re: [sqlite] SQlite and C works with "like" but not with "="

On Jun 14, 2008, at 10:39 AM, Daniel White wrote: > Hi guys, > > My first post to this list, and I'm new to SQL in general too. > > Just a couple of questions to start: > > ***1: > In the sqlite3_prepare_v2 function, can someone explain > to me the 5th parameter better than the site's help can?