[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

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

[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"

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

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

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);

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

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

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

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 : >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

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

[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

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

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(, "attach database as ", 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 access the tables in the other