Re: [sqlite] Named parameters in a glob?

aditya siram wrote: > Is there any way to pass named parameter into a glob pattern, for > instance: > >> SELECT name from name where name glob "*$name*" SELECT name from name where name glob '*' || $name || '*'; Igor Tandetnik

Re: [sqlite] SQLite error near "INTEGER": syntax error

It's funny how after looking at lines of code for several hours, you miss one little character. On Tue, Dec 16, 2008 at 2:08 PM, D. Richard Hipp wrote: > > On Dec 16, 2008, at 2:04 PM, David Frischknect wrote: > > > Hello, > > > > I'm having trouble with an SQL script file I'm

Re: [sqlite] SQLite error near "INTEGER": syntax error

David Frischknect wrote: > CREATE TABLE Album ( >Album_ID INTEGER PRIMARY KEY, >Album_Title TEXT NOT NULL, >Album_Year NUMERIC, >Artist_ID INTEGER NOT NULL REFERENCES Artist(Artist_ID), >Genre_ID INTEGER NOT NULL REFERENCES Genre(Genre_ID, Missing

Re: [sqlite] SQLite error near "INTEGER": syntax error

On Dec 16, 2008, at 2:04 PM, David Frischknect wrote: > Hello, > > I'm having trouble with an SQL script file I'm using in my C# > application. > I'm trying to use the script file to create the database if the > database > does not exist when the program starts. As far as I can tell, there

[sqlite] SQLite error near "INTEGER": syntax error

Hello, I'm having trouble with an SQL script file I'm using in my C# application. I'm trying to use the script file to create the database if the database does not exist when the program starts. As far as I can tell, there are no errors in the script file. begin pasted SQL script file

Re: [sqlite] REGEXP

I think it had more to do with a) the fact that it's non-standard syntax and b) compiling in the regex library would unnecessary bloat the binary. See pcre.org for a free (non-GPL) regex library that has proven to work nicely with SQLite. :) -T On Tue, Dec 16, 2008 at 1:44 PM, Griggs,

Re: [sqlite] REGEXP

Regarding: "...No regexp() user function is defined by default..." The reason, if I recall correctly, is that the regexp routines that were available were GPL'd and would mess with the licensing of sqlite. ___ sqlite-users mailing list

Re: [sqlite] REGEXP

Ben Marchbanks wrote: > I am confused. Is REGEXP enabled in SQLite or does there have to be a > regexp custom function created ? The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally

[sqlite] REGEXP

I am confused. Is REGEXP enabled in SQLite or does there have to be a regexp custom function created ? -- *Ben Marchbanks* www.magazooms.com Signature Email: b...@magazooms.com Phone: (864) 284.9918

Re: [sqlite] Sharing a database / Replication

On Tue, 16 Dec 2008 12:26:30 -0500, Simon wrote in turne...@gmail.com, General Discussion of SQLite Database : >Hi there, > I'm developping an application that will use several databases. One >on disk that will hold all configuration and cache, and

Re: [sqlite] Sharing a database / Replication

Simon wrote: > I'm just > wondering if there could be a query made on a database using > information provided in another database (ie to compare, or > insert/copy). http://sqlite.org/lang_attach.html Igor Tandetnik ___

[sqlite] Sharing a database / Replication

Hi there, I'm developping an application that will use several databases. One on disk that will hold all configuration and cache, and another in ram to hold all live data. On the same server, it is possible that multiple process will read/write to both the disk db and the memory db. Someone

Re: [sqlite] Impossible to declare field type BIGINT PRIMARY KEY

Where did you get your pre-occupation with BIGINT? Sqlite handles INTEGERS and makes them up to 64 bits as necessary. An INTEGER primary key will autoincrement,. Sql;ite lets you introduce a type BIGINT as a declared type, but makes its own decision as to underlying type. Nathan Catlow