Re: [sqlite] Warning message in amalgamation

On 2/2/09, Roger Binns wrote: > Maurí­cio wrote: > > I know this is not a problem, but I would like to > > remove this warning since it's not important for > > the rest of the code. What could I do? > > > The usual method is to cast the result to (void) but gcc still

Re: [sqlite] Warning message in amalgamation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Comperchio wrote: > in io.h write returns an int - number of bytes written. Declare an int > and catch the return value. :) And then the compiler will complain that the variable assigned the value is not used elsewhere. You get to keep

Re: [sqlite] Warning message in amalgamation

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Maurí­cio wrote: > >> I know this is not a problem, but I would like to >> remove this warning since it's not important for >> the rest of the code. What could I do? >> > > The usual method is to cast the result to

Re: [sqlite] (no subject)

Daniel, Thanks for the pointers, but I do not believe that they apply.  You are correct in that the script is more complex and it is hard to post.  I tried to post the relevant portions with explanations.  In terms of connection (self.con) and cursor (self.cur) these are the only existing

Re: [sqlite] Warning message in amalgamation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Maurí­cio wrote: > I know this is not a problem, but I would like to > remove this warning since it's not important for > the rest of the code. What could I do? The usual method is to cast the result to (void) but gcc still whines. I suggest you just

Re: [sqlite] SQLite compile errors with gcc

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 xianzhang wrote: > sqlite/sqlite3.c:18848:3: #error SQLite will not work correctly with the > -ffast-math option of GCC [...] > Any ideas how I can fix this? Thanks! Exactly as it says. Don't supply the -ffast-math option. Something in your build

Re: [sqlite] Question on the "like" item in "select"

J. R. Westmoreland wrote: > It is my understanding that if I use a wildcard at the front of the > string > then it will cause a linear table search rather than using the index > if the > string is the first part of the match. For example, "... col like > '%String'" > or "... col

Re: [sqlite] Question on the "like" item in "select"

It is my understanding that if I use a wildcard at the front of the string then it will cause a linear table search rather than using the index if the string is the first part of the match. For example, "... col like '%String'" or "... col like '%String%'" would cause a linear table search

Re: [sqlite] Substract and decimal

THANK'S A LOT IGOR Igor Tandetnik escribió: > Carlos Suarez > wrote: > >> An date field can be null or not, depending of this the field it >> writes 'without_a_date' or the number of days from a date to another >> *the problem is only the presentation cause I

Re: [sqlite] Substract and decimal

Carlos Suarez wrote: > An date field can be null or not, depending of this the field it > writes 'without_a_date' or the number of days from a date to another > *the problem is only the presentation cause I need the subtract > without decimals number* but round

Re: [sqlite] Substract and decimal

Hello, I need to use a case with that situation: An date field can be null or not, depending of this the field it writes 'without_a_date' or the number of days from a date to another *the problem is only the presentation cause I need the subtract without decimals number* but round doesn't

Re: [sqlite] Question on the "like" item in "select"

On Mon, Feb 2, 2009 at 12:33 PM, J. R. Westmoreland wrote: > Please pardon me if this is really more SQL rather than sqlite behavior. > > > > If I have some thing like: > > SELECT . WHERE . LIKE "String" .; > > Is it going to work like: > > SELECT . WHERE . = "String" .; > > LIKE

[sqlite] Question on the "like" item in "select"

Please pardon me if this is really more SQL rather than sqlite behavior. If I have some thing like: SELECT . WHERE . LIKE "String" .; Is it going to work like: SELECT . WHERE . = "String" .; Thanks, J. R. J. R. Westmoreland E-mail: j...@jrw.org

Re: [sqlite] Fast and simple database merge

Regarding: "...Really cool would be something like: cat db1.dat db2.dat db3.dat > final.dat" I don't think there are any "really cool cat's" available. ;-) The format of the database is fairly fancy, though it is documented if you think you'd be interested in writing a utility

Re: [sqlite] (no subject)

Hey Boris, It's a bit hard to follow what you've posted here, but I'm sure that's because it came from a complicated script. Here are a few things to keep in mind. You've make the connection to be EXCLUSIVE, which means that once you send the first SQL statement to the database the database is

Re: [sqlite] checking database file

Dan wrote: > On Feb 2, 2009, at 2:34 PM, Zaphod wrote: > >> Hi All, >> >> Let's say every time before my system starts to run, i would like to >> check the >> database for any kind of errors/mistakes. >> Is there any API or utility for such purpose? > > See "PRAGMA integrity_check" here: > >

[sqlite] unsubscribe

John Horton Megger Limited Archcliffe Road Dover Kent CT17 9EN England. T +44(0)1304-502100. (Switchboard) T +44(0)1304-502139. (Direct) F +44(0)1304-502306. E john.hor...@megger.com www.megger.com The information contained in this electronic mail message is confidential. It is

[sqlite] Fast and simple database merge

Hi, For an application I use SQLite as datafile. I have written a "compiler" (script chain in Linux) for creating my database file. There are dependencies between tables and "compiling" my single database takes about 1-2 hours. When there is an error I have to restart the whole procedure.

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

There should be no single quotes around question marks -Shibu -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor Sent: Monday, February 02, 2009 6:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite]

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

"hussainfarzana" wrote in message news:21788991.p...@talk.nabble.com > Yes,the SQL prepared statement has got 14 placeholders. > > The statement is "INSERT INTO CollDataNum > values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)" No, there are only thirteen. '?' is not a parameter

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

Hi, no, you habe 13 placeholders and one string constant '?' on position 9. You do not need to include the ? in quotes if the value you want to bind is a string. Martin hussainfarzana schrieb: > Yes,the SQL prepared statement has got 14 placeholders. > > The statement is "INSERT INTO

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

Farzana, You can save a lot of email back-and-forth by showing your code in the first place. The very minimum information that you (that anyone) should provide when asking a code-related question is -- 1. db schema 2. code adding info about computer and operating system, plus any driver version

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

Yes,the SQL prepared statement has got 14 placeholders. The statement is "INSERT INTO CollDataNum values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)" Regards, Farzana. SimonDavies wrote: > > 2009/2/2 hussainfarzana : >> >> Dear All, >> >> We are working with SQLite Version

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

2009/2/2 hussainfarzana : > > Dear All, > > We are working with SQLite Version 3.6.10. > We tried to insert or update the records in the database using > sqlite3_prepare and binding the values using sqlite3_bind functions.We have > started with the index 1.We have a table

[sqlite] sqlite3_bind_int returns SQLITE_RANGE

Dear All, We are working with SQLite Version 3.6.10. We tried to insert or update the records in the database using sqlite3_prepare and binding the values using sqlite3_bind functions.We have started with the index 1.We have a table with 14 columns and when we use sqlite3_bind_int,for the first

[sqlite] SQLite compile errors with gcc

Hello. I am trying to install the SQLite package for R. When I was compiling the source RSQLite_0.7-1.tar.gz, I got the following error message: sqlite/sqlite3.c:18848:3: #error SQLite will not work correctly with the -ffast-math option of GCC The compiler was gcc version 3.4.6 20060404 (Red

Re: [sqlite] onthefly Compression of SQLite database

Hello! В сообщении от Monday 02 February 2009 03:31:16 Lukas Haase написал(а): > I searched a little bit with google but I could not find any code or > extensions to compress an SQLite database on the fly. Is this possible? There are functions compress/uncompress in attached file. Best regards,

Re: [sqlite] onthefly Compression of SQLite database

> VARCHARs. In total, my SQLite database is about 100MB. Very, very huge. 100 MB? Come on, this isn't that "BIG" > It seems that compressing an SQLite database is very efficient. Is there > any way to compress/decompress a whole database on the fly ? Well, you could license the CEROD