[sqlite] Re: Re: like operator

RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: I could not under the "/" what is the purpose of it? Like I said - '/' just happens to immediately follow '.' in ASCII table. Thus, 'xxx/' is the smallest string greater than any string of the form 'xxx.yyy', in lexicographical order. Igor

Re: [sqlite] Re: like operator

Hi, Thanks for the reply. I could not under the "/" what is the purpose of it? regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the

[sqlite] Re: like operator

RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: we have given a web interface which receive delete request. Now in the req we get "%" and in the delete impl we do this delete from table where itemName like xxx.%; since the key is % the above statement becomes, "delete from table where itemName

Re: [sqlite] like operator

You have to test your incoming values, and reject requests that have "%" (and other illegal) chars. I never allow real deletes from a web form, and especially not from trusted users. Consider adding a "deleted" column, and update the affected rows to indicate they've been deleted. It's a

[sqlite] like operator

Hi, we have given a web interface which receive delete request. Now in the req we get "%" and in the delete impl we do this delete from table where itemName like xxx.%; since the key is % the above statement becomes, "delete from table where itemName like %.%";And result in fatal problem of

[sqlite] building 3.4.2 on solaris

I tried to build sqlite 3.4.2 on Solaris 8, 64 bits. My existing gcc setup failed to do it, but I could do it with the Sun compiler 5.3. I configured with: ../sqlite-3.4.2/configure --enable-debug --enable-threadsafe --with-tcl=/usr/local/lib/sparcv9 CFLAGS='-DSQLITE_MEMDEBUG=2

Re: [sqlite] Sqlite 3.4.0 - problem with prompt

Do you have readline? Rachmel, Nir (Nir) wrote: Hi, I recently upgraded from sqlite 3.2.8 to sqlite 3.4.0. I have only made minor changes in my system to get the new version up and running, however I encountered a problem: when I run sqlite with a database and try to use the 'history'

Re: [sqlite] SQLITE_BUSY error in multi-threaded environment

I came across some OS's over the years which implemented file locks as a single global lock. Yours may do that. Mark Brown wrote: Hi John- There is a .lock file for each database. From my understanding, that should prohibit 2 connections from using the same database at the same time.

RE: [sqlite] Problem loading extension in Delphi (FTS2)

DISQLite3 does not use SQLite.NET. As I read Sam, he did not say so. He just compared the two to support his argument that "loadable extensions are not required to create custom functions and having access to source is not required for custom functions either". Ralf >I was not aware that

Re: [sqlite] Problem loading extension in Delphi (FTS2)

Hello Zlatko Matic, >How about Lazarus version of DISQLite3? :) DISQLite3 is Delphi only at the moment, maybe later! ;-) Ralf - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

"As recommended, BEGIN IMMEDIATE should prevent thread2 from even starting a transaction if thread1 did so first, however I think this will only work correctly if the same connection handle is used in both, else they still may not know about eachother." Simply not true... If you

Re: [sqlite] DISQLite FTS

>Does DISQLite have its own implementation of FTS, so not using FTS2 at >all? DISQLite3 uses the original full text search modules, adapted to Delphi. Both FTS1 and FTS2 are already compiled in, and can both be used by the same application (like SQLiteSpy does). >Does it use the same

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

http://www.google.com/ --- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote: > Tried without this line - it still doesn't work. > Any ideas? > > Thanks, Nir. > > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 16, 2007 4:16 PM > To:

RE: [sqlite] Problem loading extension in Delphi (FTS2)

I was not aware that DISQLite3 uses SQLite.NET. thanks. --- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > > loadable extensions are not required to create custom functions, and having > access to source is not required for custom functions either. SQLite.NET > provides very clean support for

Re: [sqlite] Dump with where clause

Andre du Plessis wrote: HI, how can I use .dump or something similar but specify a where clause, I cant see that the .dump command allows this, Without any arguments it seems to dump the whole db, the only argument supported is the table name, I would like to be able to do something like:

Re: [sqlite] Problem loading extension in Delphi (FTS2)

Ralf, How about Lazarus version of DISQLite3?:) Regards, Zlatko - Original Message - From: "Ralf Junker" <[EMAIL PROTECTED]> To: Sent: Thursday, August 16, 2007 11:54 AM Subject: Re: [sqlite] Problem loading extension in Delphi (FTS2) Hello Joe Wilson,

RE: [sqlite] Problem loading extension in Delphi (FTS2)

loadable extensions are not required to create custom functions, and having access to source is not required for custom functions either. SQLite.NET provides very clean support for custom functions written in any .NET language and they are loaded automatically by the wrapper from any DLL present

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

Tried without this line - it still doesn't work. Any ideas? Thanks, Nir. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 4:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite 3.4.0 - problem with prompt You want to enable

Re: [sqlite] Unique ids for each record

I assume you'd rather want three separate tables (artist, album, track) with an autoincrementing ID field per table. Your approach would not allow users to own more than 100 albums. regards, Markus Quoting "Sreedhar.a" <[EMAIL PROTECTED]>: Hi, I have a table with 3 columns. Artist Album

Re: [sqlite] Problem loading extension in Delphi (FTS2)

--- Ralf Junker <[EMAIL PROTECTED]> wrote: > >Your product is not useful to a few users like me who require custom > >sqlite functions for their databases. > > I am not sure I understand currectly. Only loadable extensions are currently > omited from > DISQLite3. > > sqlite3_create_function()

RE: [sqlite] Re: Dump with where clause

That's a very neat little trick, Once again why didn't I think of that :) Thank you very much. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: 16 August 2007 01:52 PM To: SQLite Subject: [sqlite] Re: Dump with where clause Andre du Plessis <[EMAIL PROTECTED]>

Re: [sqlite] Sqlite 3.4.0 - problem with prompt

You want to enable readline to allow command history editting, not disable it. --- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote: > I recently upgraded from sqlite 3.2.8 to sqlite 3.4.0. > I have only made minor changes in my system to get the new version up > and running, however I encountered

[sqlite] Re: Dump with where clause

Andre du Plessis <[EMAIL PROTECTED]> wrote: HI, how can I use .dump or something similar but specify a where clause, I cant see that the .dump command allows this, I would like to be able to do something like: .dump table1 where ID > 1000 create temp table tmp as select * from table1 where

Re: [sqlite] DISQLite FTS

>Does DISQLite have its own implementation of FTS, so not using FTS2 at all? FTS1/2 are compiled in DISQLite. - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Sqlite 3.4.0 - problem with prompt

Hi, I recently upgraded from sqlite 3.2.8 to sqlite 3.4.0. I have only made minor changes in my system to get the new version up and running, however I encountered a problem: when I run sqlite with a database and try to use the 'history' feature of the command-line (pressing the 'up' arrow key

[sqlite] DISQLite FTS

I did not want to highjack the exsiting FTS thread but Ralf, Does DISQLite have its own implementation of FTS, so not using FTS2 at all? Does it use the same mechanism as FTS2 with virtual tables? And have you compared speed and functionality to FTS2, Maybe im actually just looking

Re: [sqlite] Problem loading extension in Delphi (FTS2)

Hello Joe Wilson, >Your product is not useful to a few users like me who require custom >sqlite functions for their databases. I am not sure I understand currectly. Only loadable extensions are currently omited from DISQLite3. sqlite3_create_function() is very well available in DISQLite3 Pro

RE: RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

If they are different files then you should not have any of these problems. -Original Message- From: RaghavendraK 70574 [mailto:[EMAIL PROTECTED] Sent: 16 August 2007 11:21 AM To: sqlite-users@sqlite.org Subject: Re: RE: [sqlite] SQLITE_BUSY error in multi-threaded environment hi, Am

Re: RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

hi, Am not clear. Suppose i have 2 databases and a process spwans 2 threads and each thread opne the db will it result in any problem? They are independent files. thx ragha ** This email and its

RE: [sqlite] SQLITE_BUSY error in multi-threaded environment

Ok well I guess I forgot to mention this is what has made me want to pull my hair out a few times :) the fact that you have to worry about both scenarios for two different reasons, if multiple threads are working with the same connection handle, then SQL will have a better understanding of the

[sqlite] Dump with where clause

HI, how can I use .dump or something similar but specify a where clause, I cant see that the .dump command allows this, Without any arguments it seems to dump the whole db, the only argument supported is the table name, I would like to be able to do something like: .dump table1 where ID >

Re: [sqlite] why doesn't this work? (fts rowids)

fts1 and fts2 have a design flaw which assumes semantics for the standard SQLite rowid which aren't actually provided by SQLite across calls to VACUUM. fts3 will fix this, either making the rowid be a persistent idenfier across VACUUM, or by exposing a new id (or docid) column which operates as a