[sqlite] Expr error in TCL

The $prv_rd variable stores backend sqlite data (varchar data type). The data is 874. In order to perform any mathematical operation on this data, I use : set calc [expr $prv_rd+2] The above expression gives me the following error message : Error : expected integer but got "874" (

Re: [sqlite] Expr error in TCL

Hi Anirban I recently suggested to you 2 very good resources for these sort of questions. I really recommend you use them as you will find answers much more forthcomming. The problem you have is a common problem where numbers with leading 0's are interpreted as octal numbers. To solve this,

RE: [sqlite] Unable to open database file

Thanks Clay, It's definitely Starteam - I used FileMonitor from SysInternals to identify it. My database is running on a removable drive, which may be the cause I guess. If it gets temporarily disconnected or something (or this is usually displayed on the screen). You are right in the last

Re: [sqlite] Printing ?

Richard said: > Had a question on printing search results, > to a network printer? > > what command would I use for this? lpr would be favorite, but SQLite itself doesn't have any printing mechanism. If you dump output to a file in columns you could send that file to a printer, or you could

Re: [sqlite] Printing ?

On Fri, 28 Jan 2005 08:46:35 -0500, Richard <[EMAIL PROTECTED]> wrote: > So, one would need some kind of Report Software, > to interface wth SQlite? On-Target Reports supports SQLite:

Re: [sqlite] Case-Insensitive Searches

On Jan 26, 2005, at 8:56 AM, David Wheeler wrote: sqlite> create table a(b text COLLATE nocase); sqlite> insert into a values ('this'); sqlite> insert into a values ('This'); sqlite> insert into a values ('THIS'); sqlite> select * from a where b = 'this'; this This THIS sqlite> Hrm, I'f finding

[sqlite] Windows Shares again... (SQLITE 2.8)

Hi all, I have a small windows network here. On every computer I install a client which should access a sqlite database (the same one). The sqlite database is located in on a server and the clients connect to this server through a windows share. My app tries to open the database which is

Re: [sqlite] Case-Insensitive Searches

David, No, you can't specify a collation when creating a view (http://www.sqlite.org/lang_createview.html). I don't know whether is was intentional that simple columns in a view don't get collation info from the base table, but if you think it's a bug, you can submit a bug ticket; meanwhile,

Re: [sqlite] Case-Insensitive Searches

On Jan 28, 2005, at 10:53 AM, Kurt Welgehausen wrote: David, No, you can't specify a collation when creating a view (http://www.sqlite.org/lang_createview.html). I don't know whether is was intentional that simple columns in a view don't get collation info from the base table, but if you think

Re: [sqlite] Case-Insensitive Searches

> Yes, it seems to me that views should respect the configurations of > their underlying tables, including collations, triggers, and the like. > I'll submit a bug report. It's not quite that simple. A view column may be an expression, and inferring attributes for such a column could be quite

[sqlite] Join two select field together

Hi All, I wonder does Sqlite have feature such as join two string fields together. e.g: Select FirstName + LastName From Username Thank you, Ming

Re: [sqlite] Join two select field together

At 9:49 PM -0400 1/28/05, [EMAIL PROTECTED] wrote: Hi All, I wonder does Sqlite have feature such as join two string fields together. e.g: Select FirstName + LastName From Username Thank you, Ming The '+' is a numerical addition; its result is the sum of 2 numbers; that is not what you want.

Re: [sqlite] Case-Insensitive Searches

On Jan 28, 2005, at 12:04 PM, Kurt Welgehausen wrote: Yes, it seems to me that views should respect the configurations of their underlying tables, including collations, triggers, and the like. I'll submit a bug report. It's not quite that simple. A view column may be an expression, and inferring

Re: [sqlite] Join two select field together

Thank you. That answers my question. Awesome Sqlite! Darren Duncan wrote: At 9:49 PM -0400 1/28/05, [EMAIL PROTECTED] wrote: Hi All, I wonder does Sqlite have feature such as join two string fields together. e.g: Select FirstName + LastName From Username Thank you, Ming The '+' is a numerical

[sqlite] System date and time in Tcl

How do I pick the system date and time in TCL? Any early help will be appreciated since it is very urgent. Thanking in advance. Your's sincerely, Anirban Sarkar

[sqlite] Win CE support

If I was to provide patches for Windows CE support (and maintain win ce code in the future): a) would they get accepted (assuming the quality is up to sqlite's quality) ? Basically I'm asking if it's worthwile for me to spend time on doing that (it wouldn't if e.g. the patches wouldn't get

Re: [sqlite] Case-Insensitive Searches

On Jan 28, 2005, at 6:03 PM, David Wheeler wrote: On the other hand, I don't see why collation info for a simple column reference can't be made availabe through a view, since type info already is available -- but I certainly could be missing something. It makes sense to me. Bug report filed--many

[sqlite] Formatting system date and time in TCL

How do I format system date and time to dd-mm- and hh:mm:ss respectively? Thanks for any response. Anirban Sarkar