Porting an application to sqlite3.6.13 on Linux i made a mistake
creating a illegal query on a character field:
select * from Test where Remark = NULL
select * from Test where Remark <> NULL
I was confused as there were neither data nor an error. Shouldn't this
cause at least an error
Hi,
there is no link on the SQLite download page for "*Precompiled Binaries
For Windows" to download tclsqlite-3_3_0.zip (sqlitedll with TCL bindings).
Please can anyone provide the community / me with **tclsqlite-3_3_0.zip
as ** I have no access to a Microsoft OS/Compiler?
TIA
Stefan
*
d just do not accept and use them.
In cases german citizens accepted a foreign license model ot contribute
software, it would be nearly impossible to involve a German court
whether for license nor for warranty aspects.
Stefan Finzel
D. Richard Hipp wrote:
On Fri, 2005-06-03 at 21:01 +0200, An
What about the os shells limit? Look at commands limit/ulimit/unlimit
G. Roderick Singleton wrote:
On Mon, 2005-04-11 at 12:05 -0400, Jonathan Zdziarski wrote:
D. Richard Hipp wrote:
Are you sure your users are not, in fact, filling up their disk
drives?
nope, plenty of free space
Although Tcl does not know NULL at all, sqlite does. From my current
unterstanding there are five different fundamental internal datatypes.
One of them is SQLITE_NULL. But SQLITE_NULL is not used at all while
iterating over the results of
dbcmd eval "SELECT ..."
From my current unterstanding
Hello Jay,
Yes, that is the expected behaviour. But that is not my problem.
Within sqlite console there is a a command
.nullvalue NULL
All I want is to know how I can set and use this mechanismen from my Tcl
interpreter too.
Of cause it would be possible to misuse the default setting to get the
Yeah! I've missed the default option. But is this SQL standard?
And it does not seem to work for me at all. I still can't differ empty
and NULL;
create table deftest (k integer primary key,
i integer default 'NULL',
s char default 'NULL');
sqlite> insert
Hi,
maybe this is also a too simple question but I miss it "once again? ;-) "
I am using tclsqlite 2.8.16/3.1.x/3.2.0 to query for results containing
NULL and/or empty integer/float/text/blob.
Is there a way to change the NULL representation to get a specified
string (NULL, NAN) for NULL values
Hi,
what is the correct way to query for NULL-values? I use SQLite version
3.2.0
create table t1(a int, b char);
insert into t1 values(1, '2');
insert into t1 values(3,NULL);
insert into t1 values(NULL,'4');
select * from t1 where b=NULL;
-- this gives no result at all
select * from t1 where
Tcl is really fine for web interfaces. Porting an almost 10 year old web
application to sqlite2 and sqlite3 was a charme. It is supporting Linux,
SunOS,Windows and maybe HP-UX so far. If you are interested in an
generic example using SQLite 3.1.3 (but also supporting 2.1.16) look at
Kurt Welgehausen wrote:
proc lpartition {recsize data} {
set ret {}
set datalen [llength $data]
for {set i 0; set j [expr {$recsize-1}]} \
{$i < $datalen} {incr i $recsize; incr j $recsize} {
lappend ret [lrange $data $i $j]
}
set ret}
So is there another way to determine the number
11 matches
Mail list logo