Can you explain me what the possible reasons for an error code 7 can be?
(SQLITE_NOMEM /* A malloc() failed */) (on a P4 2.6G 500MB)
Thanks
Tim
Am Mittwoch, 17. März 2004 16:17 schrieb Puneet Kishor:
[...someting about aliasing columns in views...]
Send an email to [EMAIL PROTECTED]
I think this will answer your question.
> ==
>
> Is there an archive of these mailing lists where I can view previous
> posts?
Send an email to [EMAIL P
Am Mittwoch, 3. März 2004 08:36 schrieb Michal Pasternak:
> Certainly.
>
The first expr is optional, so in this case you could use:
SELECT name_pl,
CASE
WHEN is_cenatel='t' THEN '('
ELSE (CASE
WHEN ((sale_since < %s) + (sale_until > %s)) TH
Hi,
again I've figured out an inconsistency with subselects (and again I think it's
sqlite's fault... ;)
SQLite version 2.8.12
Enter ".help" for instructions
sqlite> .echo on
sqlite> .read test.sql
.read test.sql
DROP VIEW t1view;
DROP VIEW t1view2;
DROP TABLE t1;
CREATE TABLE t1 (
id
ORDER BY b, c DESC
);
b c
-- --
1 3
1 3
1 2
1 2
1 1
1 1
2 3
2 2
2 1
sqlite>
Tim Krah
-
To unsubscribe, e-mail:
two NULL
3 three NULL
4 fourdog
4 fourcat
4 fourdog
Is this a bug? Am I handling it wrong? Has anybody else seen that kind of
problem?
It should work according to the documentation (
|500
>
> update v2 set c = 444 where a = 4;
> select * from v2;
> a|b|c
> 1|10|100
> 2|20|222
> 3|30|300
> 4|40|444
> 5|50|500
> sqlite>
>
> I hope this helps.
That's it! You helped a lot! Many Thanks!
Although it is much work because the view has got
an error 'SQL error: column xyz is not unique' (where xyz is the
unique column of the first table). But the same update-statement directly on
the first table works fine! I don't know what the Problem is...
I appreciate any
8 matches
Mail list logo
