[sqlite] Prepared statements on rtree index

Hi, I am trying to insert records into a rtree table using prepared statements. The table is defined like this: CREATE VIRTUAL TABLE points_index USING rtree(id, x, y); I successfully populate the table containing geometries/attributes using prepared stmt's. Inserting values into the

Re: [sqlite] Foreign Key

2008/11/25 Satish [EMAIL PROTECTED]: Hi All! I have a small question that Foreign key Constraint is now supported by SQLite or not.I had this question because in an SQLite table for a Foreign key ON DELETE CASCADE or ON UPDATE CASCADE are not working.Is there any problem with my

Re: [sqlite] contstraint failed problem

On Nov 24, 2008, at 5:07 PM, Christophe Leske wrote: Hello, i have a rtree table which I dynamically opulate with results. Sometimes however, I get a constraint failed error from SQLite. After some poking, I found that it occurs whenever my statement tries to insert a record which has

[sqlite] sqlite3_exec function hanging upto 30 to 40 mins

Hi all, I am using sqlite 3.3.15 version in my setup on Solaris 10 SPARC machine. sqlite_exec function is hanging suddenly in the middle while retrieveing rows from a table. I am able to reproduce this very frequently. I did not understand why it is hanging for 30 to 40 mins without throwing any

[sqlite] Rtree coordinate limitations ?

Hi, as far as I can see from docs, the r-tree extension uses 32-bit floats to store rectangles. However, when I try to insert this one INSERT INTO points_index (id, x, y) VALUES (3, 731.293, 74.463); i get SQL error: constraint failed. Reducing the x to 31.293 works. Is the r-tree limitied

[sqlite] sqlite3_open16 fails on Windows Vista 64b

I am getting an exception: An attempt was made to load a program with a incorrect format. (HRESULT: 0x8007000B) when I am trying to use sqlite3_open16 on Windows Vista 64b. On 32b or XP 32bit it works correctly. _ Invite your mail

Re: [sqlite] SQLite - Upade trigger

Thanks Igor, that's got me going. With regards to the PK, I'm moving from an old MS access database that uses an autonumber field, but has a PK on another unique field and I wanted to keep it the same for ease of conversion, but its not a big deal. bb Igor Tandetnik wrote: blackbox [EMAIL

Re: [sqlite] Violating Primary key Constraint

Satish [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You Said me to create the field as INT PRIMARY KEY NOT NULL instead of INTEGER PRIMARY KEY NOT NULL.Even we spell differently they are working same.it is also auto incrementing. sqlite create table dummytable (recid integer

Re: [sqlite] Window functions

Hello! В сообщении от Monday 24 November 2008 19:16:46 Constantine Vassil написал(а): OLAP functionality includes the concept of a sliding *window* that moves down through the input rows as they are processed. Additional calculations can be performed on the data in the window as it moves,

Re: [sqlite] Rtree coordinate limitations ?

On Tue, Nov 25, 2008 at 01:26:48PM +0100, Oyvind Idland scratched on the wall: Hi, as far as I can see from docs, the r-tree extension uses 32-bit floats to store rectangles. However, when I try to insert this one INSERT INTO points_index (id, x, y) VALUES (3, 731.293, 74.463); i get

Re: [sqlite] Violating Primary key Constraint

Hi All! I have created a table in sqlite.Upto my knowledge a column which is declared as primary key will not accept null and even if I don't give any value to that field an error occurs that violating the constraint For Example Create table emp(empno integer PRIMARY KEY,...,...)

Re: [sqlite] Request to check UNICODE support

[EMAIL PROTECTED] writes: Hi all This is krishnakumar i am using SQLite as data base in my application as meta data storage i want use it to store CString how can i deal with UNICODE. Is SQLite support UNICODE Character set Krishna Kumar T M http://www.sqlite.org/faq.html#q18

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

Does sqlite3_open fail too? - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Rtree coordinate limitations ?

Thanks for the reply, I misunderstood the concept of dimensions here (i have fairly good knowledge about r-trees) Still i am stuck with binding values, and cant really figure out why (possibly been looking myself blind on the code ?) Here is a portion of the code that shows what I do, the bind

[sqlite] sqlite3_exec - statement length limit?

Is there a limit on the length of the SQL that can be executed using this function. I mean stmt1;stmt2;...stmtn upto what length. Even if there is no limit is it nevertheless prudent not to exceed a certain maximum length? -- View this message in context:

Re: [sqlite] SPAM: sqlite3_open16 fails on Windows Vista 64b

This can happen if you're accessing the precompiled sqlite library from a 64-bit application. The binary provided by sqlite.org is 32-bit. A lot of .NET managed people get tripped by this, since .NET programs are (by default) compiled as Any CPU which means on a 64-bit machine, the .NET program

Re: [sqlite] sqlite3_exec - statement length limit?

2008/11/25 SQLiter [EMAIL PROTECTED]: Is there a limit on the length of the SQL that can be executed using this function. I mean stmt1;stmt2;...stmtn upto what length. Even if there is no limit is it nevertheless prudent not to exceed a certain maximum length? --

[sqlite] CMAKE support for sqlite3

Hi, i wanted to compile the sqlite3 library on windows. For that reason I made a short CMakeLists.txt file which allows to compile sqlite3 with MINGW/MSYS and MSVC. Please find attached the file contents. Maybe that kind of file could be included in the source? Regards Friedrich

Re: [sqlite] CMAKE support for sqlite3

SET( CMAKE_INSTALL_PREFIX f:/doof ) This *will* cause problems for some people ;). Otherwise, I love CMake, so I'm all for this. Any chance a stable CMake file would be hosted on sqlite.org? - Sherief ___ sqlite-users mailing list

Re: [sqlite] sqlite3_exec - statement length limit?

Thanks. The issues regarding injection attacks are not relevant in my present context. What I wanted to know was this - a. I want to selectively discard N rows from a SQLite dB table. N could be 1 but again it could be, rarely, 10,000 b. Is it better to recursively call Prepare, Step

Re: [sqlite] Violating Primary key Constraint

On Tue, 25 Nov 2008 11:47:10 +0530, Satish [EMAIL PROTECTED] wrote in General Discussion of SQLite Database sqlite-users@sqlite.org: Hi! You Said me to create the field as INT PRIMARY KEY NOT NULL instead of INTEGER PRIMARY KEY NOT NULL.Even we spell differently they are working same.it is also

Re: [sqlite] sqlite3_exec - statement length limit?

SQLiter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] b. Is it better to recursively call Prepare, Step Finalize from my Delphi App It is better to call Prepare once (with a parameterized statement), then (bind, step, reset) multiple times in a loop, then Finalize at the end.

[sqlite] PRAGMA journal_mode not working

Hi all, I am running SQLite3 version 3.6.6 and I have successfully ported it to my OS. The problem I am seeing is that when I execute the command PRAGMA journal_mode = OFF it returns OFF but I am still seeing *.db-journal files being created. It is critical that these files are

Re: [sqlite] Wondering about SQLite and Java

I've been using xerial solely because I can't get a hold of anyone at zentus through their mailing list - the mailing list seems to be broken and has been that way for a long time. I don't trust that anyone is active on their end, and cannot confirm whether or not zentus is reliable or still

[sqlite] sqlite 3.6.5 slow on windows

Hi,   I found sqlite is kind of slow on windows (2003 server and XP professional). Here is what i did: 1) downloaded and installed sqlite3.dll (version 3.6.5). 2) created a MSVC 6.0 C++ projects with the following code, which basically runs a list of SQL statments on a opened database:  

Re: [sqlite] sqlite 3.6.5 slow on windows

Use sqlite3_prepare/bind/step instead of sqlite3_exec and group your activity into BEGIN ... COMMIT transactions. Breeze Meadow wrote: Hi, I found sqlite is kind of slow on windows (2003 server and XP professional). Here is what i did: 1) downloaded and installed sqlite3.dll (version

Re: [sqlite] sqlite 3.6.5 slow on windows

Here is a typical outputs from the program running in debug mode: Debug builds can be substantially slower. I would expect at least some performance improvement with a release build (optimizations on). Notice my constraint is these SQL statements must run one by one, not within a

Re: [sqlite] sqlite-users Digest, Vol 11, Issue 76

I am wondering is somebody compiled SQLite with Intel IPP using 32 bit memory alignment for alloc speedup? Thanks, Constantine ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Function Name

HI! What is the c/c++ API function given by SQLite to attach a database to another database or tell me how to get access the tables in the other database using a c/c++ API function Regards Satish.G ___ sqlite-users mailing list

Re: [sqlite] Function Name

Hi, see http://www.sqlite.org/lang_attach.html. You will have to call sqlite3_exec(your handle, attach database your filename as your alias, 0, 0, 0) Martin Satish wrote: HI! What is the c/c++ API function given by SQLite to attach a database to another database or tell me how to get