[sqlite] Fwd: sqlite3_prepare_v2

Begin forwarded message: > From: "Dr. Robert N. Cleaves" > Date: December 24, 2009 6:26:23 PM EST > To: "'D. Richard Hipp'" > Subject: RE: sqlite3_prepare_v2 > > Thank you very much for your help. The problem was in iTUNES. I > removed it > and no more

Re: [sqlite] Problem with cast(xx as YY)

On 24 Dec 2009, at 5:51pm, Pavel Ivanov wrote: >> and see whether one of them gives you the behaviour you want. > > I hope you understand that it's not about what behavior is wanted but > about difference in results after switching the order of predicates in > WHERE clause. Yes, I got it.

Re: [sqlite] A question

Hey Dan, Please be patient with my English. I wonder if you would like to tell me what I am doing wrong. I use Borland C++ Builder 3.0, but it seems impossible to me to get sqlite3 up and running. I have included the sqlite3.c file in my project. But the compiler reports some errors. The same

Re: [sqlite] Problem with cast(xx as YY)

> and see whether one of them gives you the behaviour you want. I hope you understand that it's not about what behavior is wanted but about difference in results after switching the order of predicates in WHERE clause. But yes, you're right, adding type TEXT magically fixed it and results became

Re: [sqlite] Problem with cast(xx as YY)

On 24 Dec 2009, at 1:17pm, Pavel Ivanov wrote: > But this behavior is definitely a bug: You might change the behaviour by defining the type of the column: create table t(f1); Try create table t(f1 TEXT); and see whether one of them gives you the behaviour you want. Simon.

Re: [sqlite] Help with Insert using select

Pavel Ivanov wrote: > Why this doesn't work? > > insert into table (creationdate, modifieddate, mytext, title) > select date('now'), date('now'), "show text", "show title"; It is possible that, if you run this statement at just the wrong moment, the two date('now') calls will produce different

Re: [sqlite] Vaccum with VB,NET

Am 24.12.2009 02:16, schrieb Ernany: > Hello guys, > > How i run sqllite with VB2005 , NE|T. I need tio run *"Vacuum"*. > > Thanks a lot > > Ernany > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Help with Insert using select

Why this doesn't work? insert into table (creationdate, modifieddate, mytext, title) select date('now'), date('now'), "show text", "show title"; Pavel On Wed, Dec 23, 2009 at 11:24 AM, Christopher Doss wrote: > Hello, I have a table that I'd like to create that needs

Re: [sqlite] Problem with cast(xx as YY)

>     The behavior of cast(XX as YY) is not the same as the old version, such > as 3.3.4, and also different to SQL Server or  MYSQL. Don't complain that SQLite's cast works the other way than SQL Server or MySQL. SQLite behaves in a very unique way when the type-related matters are a concern.

[sqlite] Problem with cast(xx as YY)

Dear Friend, My sqlite version is 3.6.21. I find that, the behavior of cast(XX as YY) is not the same as other DBMS, such as SQL Server, MYSQL. This is my test: create table t(f1); insert into t values('1'); select * from t where cast(f1 as int) = 1 and f1 =

Re: [sqlite] trim'ming a column

P Kishor wrote... > On Wed, Dec 23, 2009 at 4:08 PM, jose isaias cabrera wrote: >> >> Greetings and salutations. >> >> I would like to trim a column from all white spaces. I know how to do it >> programmatically, but I would like to do it right to the DB. Is this a >> possibility? >> >> Image

[sqlite] Help with Insert using select

Hello, I have a table that I'd like to create that needs calculated data in multiple fields. The columns are: mytext, creationdate, title, modifieddate, etc. etc If I only had one calculated data date, i could do something like insert into table (creationdate, mytext, title) select date('now'),

Re: [sqlite] sqlite3_prepare_v2

On Dec 24, 2009, at 5:46 PM, Nick Shaw wrote: > I'd suggest having your own sqlite3.dll in your own application's > working folder, rather than relying on an existing version somewhere > on the PC already which could be any version! > > If you created your own DLL, why would you then want to

Re: [sqlite] sqlite3_prepare_v2

I'd suggest having your own sqlite3.dll in your own application's working folder, rather than relying on an existing version somewhere on the PC already which could be any version! If you created your own DLL, why would you then want to statically link to it (defeating a lot of the point of a

Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

The read/write speed will depend quite a lot on disk access speed (unless you're using an in-memory DB of course), not just the database size/complexity/query. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of liubin

Re: [sqlite] Vaccum with VB,NET

VACUUM is an SqLite SQL command, so just use it inside an sqlite3_exec() statement using "VACUUM" as the SQL string parameter. Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ernany Sent: 24 December 2009 01:17

Re: [sqlite] SELECT from fts3 tokens, is it possible?

Thanks, Scott, I see problems with regular tables, but to discuss in details I have to make some tests comparing the approaches. I read once again the info about fts3 internals and would like to share new thoughts. Let's forget about "hit count". Although I mentioned google suggestions, it was