RE: [sqlite] passing C variable in query

2007-09-13 Thread James Dennett
> -Original Message- > From: Yuriy Martsynovskyy [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 13, 2007 11:45 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] passing C variable in query > > Hi Nishit, > > > can anyone tell me the syntax of passing a C variable in a

Re: [sqlite] passing C variable in query

2007-09-13 Thread Yuriy Martsynovskyy
Hi Nishit, > can anyone tell me the syntax of passing a C variable in a query. > i have taken a variable as float hd= 2000.0; > how it'll be passed in a query and what'll be the syntax of that query. First use sprintf () to insert your variable into SQL code. Then execute the resulting SQL

[sqlite] Flipping fts1/2 to fts3.

2007-09-13 Thread Scott Hess
After being out of the office for a bit, I came back and thought "My to-do list is too long." So instead of working on the hardest bit, I decided to see how many pieces of low-hanging fruit I could knock off... So today I'm getting rid of all these to-do items around fts1/2 rowid breakage and

RE: [sqlite] How is the Index table in sqlite?

2007-09-13 Thread B V, Phanisekhar
Sorry for the spelling mistake in the subject. Regards, Phani -Original Message- From: B V, Phanisekhar Sent: Thursday, September 13, 2007 3:53 PM To: sqlite-users@sqlite.org Subject: [sqlite] How is the Index stable in sqlite? Database configuration: Tables: Create table

Re: [sqlite] Re: INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hi Igor, All prepared statements become invalid when the database schema changes. You need to finalize your statement and prepare it again. Alternatively, if you are using new enough version of SQLite, use sqlite3_prepare_v2 to prepare your statements: it stores the original query string and

[sqlite] Re: INSERT after creating an INDEX

2007-09-13 Thread Igor Tandetnik
Frank Fiedler <[EMAIL PROTECTED]> wrote: I have a problem inserting elements into a data base (from process1 accessing the data base) after creating an INDEX on a table (from another process accessing the data base). The error I get is the following: "SQLITE_ERROR : SQL logic error or missing

[sqlite] passing C variable in query

2007-09-13 Thread nishit sharma
Hi All. can anyone tell me the syntax of passing a C variable in a query. i have taken a variable as float hd= 2000.0; how it'll be passed in a query and what'll be the syntax of that query. regards Nishit

[sqlite] How is the Index stable in sqlite?

2007-09-13 Thread B V, Phanisekhar
Database configuration: Tables: Create table maintable(column1 INTEGER, column2 INTEGER, column3 INTEGER). Indices: Create index column1idx on maintable (column1); How does the index table look like in sqlite? c-r 1-3 3-4 3-6 3-7 5-1 5-8 6-2 Or c-r... 1->3

Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hi Simon, On 3.4.2 built from amalgamation on XP using Visual Studio I can follow your scenario without problems. I used command line shell and tcl shell. More detail will help (version etc). Ok...let's try the next level of detail: - We are using sqlite 3.4.0 on linux (Redhat Enterprise

Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread Simon Davies
Hi Frank, On 3.4.2 built from amalgamation on XP using Visual Studio I can follow your scenario without problems. I used command line shell and tcl shell. More detail will help (version etc). Rgds, Simon On 13/09/2007, Frank Fiedler <[EMAIL PROTECTED]> wrote: > Hello everybody, > > I have a

[sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hello everybody, I have a problem inserting elements into a data base (from process1 accessing the data base) after creating an INDEX on a table (from another process accessing the data base). I have the following setup: - I have two processes accessing a single sqlite data base. process1