Re: [sqlite] specifying field type, any benefit?

If you have "dot zero(s)" values (such as, 4.0) do not save them in an INTEGER column because then they will lose their float characteristics. insert into students values(John, 4.0) select age from students where first_name = 'John' 4 <-- got converted to integer Regards /sd

Re: [sqlite] using tcl/tk and sqlite

In addition to what D.R. Hipp said, you are also creating and closing your db before you get the chance to enter any data, what you really need is to create a procedure to (1) open db (2) enter data and (3) close db every time the "execute" button is pressed. Below is a complete working example

Re: [sqlite] ORDER BY question

I tried that but got: "no such collation sequence: NUMERIC" "Dan Kennedy"

[sqlite] ORDER BY question

Hello, I'm using sqlite3 and have a list of numbers I'd like returned sorted in increasing order: 1 1.1 1.10 1.11 1.9 10 11 9 12 However, if their column is defined as numeric, the 1.10 gets converted to 1.1 (which is not what I want) and the result (using ORDER BY) is: 1 1.1 1.1 1.11 1.9 9 10

[sqlite] searching for proper date and time stamps

Hello, I'm using the TCL binding of sqlite3 One of the columns in my table has a date and time stamp, something like this: 07/20/2004 01:35:40 06/20/2005 01:37:01 06/20/2005 12:10:07 06/20/2005 12:17:08 06/20/2005 01:35:00 If I want to get all dates that are later than "06/20/2005 01:00:00" I

[sqlite] error with tclsqlite-3_0_8.zip

I just downloaded tclsqlite-3_0_8.zip and tried to load tclsqlite3.dll but it failed with: couldn't find procedure Tclsqlite_Init Is there something I'm doing wrong? Thanks, Shamil The information transmitted is intended only for the person(s)or entity to which it is addressed and may

Re: [sqlite] How to handle slashes (\) in text columns

I'm afraid I still get // % db eval "insert into t1 values('')" % // Quoting Hell it still is... -Shamil D. "Lawrence Chitty"

[sqlite] How to handle slashes (\) in text columns

I'm using the TCL binding of SQLITE and was trying to figure out how to enter various characters into a text column. To enter a slash, all I normally would do is to append another slash to it. However, this only works fine if the slash is not the last character in the field. Consider the

Re: [sqlite] Read/Write permission

Ops... I forget that replying to a message sent to sqlite-users goes only to the originator and not to the group. Anyway, I looked through sqlite.org but couldn't find how to properly open an sqlite database in read-only mode. If any knows how to do so (preferably in TCL binding), please let me

Re: [sqlite] Trying to build tclsqlite.dll AND the tclsqlite.c file

nuno.lucas === On 2004-05-28, shamil_daghestani wrote === .. > 3. Do the command: "nmake -f ..\sqlite\Makefile.msvctcl". .. >To do Step 3, In the Command Prompt I did:

[sqlite] Trying to build tclsqlite.dll

I'm using XP and trying to build a Tcl biding of SQLite using "Borland 5.5 Builder" but have run against a few obstacles. This is the very first time I'm trying such a thing, so bare with me please. I downloaded sqlite-2.8.13.tar.gz and unzipped the files into the C:\SQLite folder. Then I

[sqlite] Newbie --question about multiple PCs accessing sqlite

I'm contemplating using the TCL binding of sqlite, but the database is to (Bbe located in a shared folder and about 100 users will be accessing it for (Bread/write purposes. I would like to take some time to learn as much as (Bpossible to safeguard the database from getting corrupt due to

Re: [sqlite] TCL and SQLITE

Thanks Christian. I figured something just wasn't right... Total processing time dropped from 207 to just 0.7 seconds SD "Christian Smith"

[sqlite] TCL and SQLITE

I'm just getting around to using SQLITE to see how it performs. Therefore, I'm just a beginner. I have a couple of questions about it: I downloaded the TCL binding and did pkg_mkIndex to create the pkgIndex.tcl file. Then I did "package require sqlite", I got version "2.0". However, I see from