On Mon, 8 Oct 2007 10:03:40 -0700 (PDT), Ken wrote
> is there a built in function to display numeric values as
> hexidecimal strings? to_hexstr (40) would display 0x28
hex() isn't quite what you want. hex(40) gives 3430, since '4' is 0x34 and
'0' is 0x30. Moving on...
This is the sort of
Does anyone know how to do a database dump from the C API? I'm linking
to sqlite3.o (the amalgamated file) and was hoping to open a database
and dump the contents to an sql file.
I know this can be done from the shell, but as of yet, I can't get the
shell running on AIX.
What version of AIX
Lee Crain wrote:
Igor,
I have a question.
Why is it "highly recommended" to use the function call sequence you
iterate in preference to the sqlite3_exe call, since it is implemented
using that sequence?
Lee Crain
The callback method did not turn out to be such a good idea in practice
and
A brute force method would be to store the rowid of the owner row in
each of the detail rows.
chetana bhargav wrote:
Is this a garbage collection situation, where you want a row in B to go away when all referring rows in A are deleted?
Yes exactly this is what I wanted :)
Sorry for the
Thanks Joe
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 08, 2007 1:45 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] 3.5.1 build issues
>
> "make test" already fixed in CVS.
>
> http://www.sqlite.org/cvstrac/tktview?tn=2689
>
"make test" already fixed in CVS.
http://www.sqlite.org/cvstrac/tktview?tn=2689
--- "Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote:
> A glitch or two got introduced into the 3.5.1 build for cygwin and
> possibly other platforms. Please advise if I did something wrong:
>
> There are undefined
Addendum: There is a new file, src/test_onefile.c, that needs to be
added to Makefile.in.
-Original Message-
From: Evans, Mark (Tandem)
Sent: Monday, October 08, 2007 12:23 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] 3.5.1 build issues
A glitch or two got introduced into the 3.5.1
I wrote:
> On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote:
> > >> Is this a garbage collection situation, where you want a row in B to go
> > >> away when all referring rows in A are deleted?
> >
> > Yes exactly this is what I wanted :)
> Maintaining a reference count in table B may be
On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote:
> >> Is this a garbage collection situation, where you want a row in B to go
> >> away when all referring rows in A are deleted?
>
> Yes exactly this is what I wanted :)
Okay. A trigger on table A can accomplish it without any extra
On Mon, 8 Oct 2007 09:04:53 -0700 (PDT), you wrote:
>>> Is this a garbage collection situation, where
>>> you want a row in B to go away when all
>>> referring rows in A are deleted?
>
>Yes exactly this is what I wanted :)
>
>Sorry for the confusing message earlier
>
>-x-
>Chetana
This might
is there a built in function to display numeric values as hexidecibmal strings?
to_hexstr (40)would display 0x28
Thanks,
Ken
Lee Crain <[EMAIL PROTECTED]> wrote:
Why is it "highly recommended" to use the function call sequence you
iterate in preference to the sqlite3_exe call, since it is implemented
using that sequence?
1) It's usually easier to write a loop, than to break out the body of
the loop into a separate
Igor,
I have a question.
Why is it "highly recommended" to use the function call sequence you
iterate in preference to the sqlite3_exe call, since it is implemented
using that sequence?
Lee Crain
_
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL
>> Is this a garbage collection situation, where you want a row in B to go away
>> when all referring rows in A are deleted?
Yes exactly this is what I wanted :)
Sorry for the confusing message earlier
-x-
Chetana
- Original Message
From: Trevor Talbot <[EMAIL PROTECTED]>
To:
On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote:
> We got two tables, tableA & tableB.
>
> tableB is turning out to be a many-one relation where in we have many rows of
> tableA mapping to one row of tableB, would like to know what is the best way
> to delete a row in tableB
>
> 1. Keep a
On 10/8/07, Markus Wolff - NorthClick <[EMAIL PROTECTED]> wrote:
> I find this to be a bit irritating - shouldn't it be enough that the
> server can dive into that subdir and find a file it can actually write
> to within the dir? How does it make sense that the entire directory
> containing the
Hey,
I tried to create user defined function called Rank. which gets partition
columns and order by column. this function should create rank according to
its parameters. i.e.:
select customer, product, sales, Rank(customer, sales)
from table
should return:
customerA productA 100 0
customerA
On Mon, 08 Oct 2007 13:12:08 +0200, Markus Wolff - NorthClick wrote
> How does it make sense that the entire directory containing the
> directory must be writeable?
Sounds like a temporary file or lock file is being created.
Somebody who knows more about PHP or SQLite can tell you which is
Hi All,
We are designing a data base landed in some problems would like to know what
approach is the best.
We got two tables, tableA & tableB.
tableB is turning out to be a many-one relation where in we have many rows of
tableA mapping to one row of tableB, would like to know what is the
chetana bhargav
wrote:
Want to know is there any easy way to make all the columns in a
particular row to NULL other than specifying column name and NULL
value, no delete as that would change the row-id
Well, you could remember the ROWID, then delete the row and insert the
new blank one with
I have found the problem. PHP was happily reporting that the frontend.db
file itself is writeable (which was true all the time), but the
directory containing the database was not writeable by the webserver.
I find this to be a bit irritating - shouldn't it be enough that the
server can dive into
Hi Daan,
You can make the columns (a, b) unique across (a, b), but not
separately unique; by that whenever you are trying to insert a row with
same (a, b) combination it will give an error and at that time you can
update the column values c and d. I hope this will solve your problem.
Hi Daan,
You could try this:
sqlite> CREATE TABLE foo(a integer, b integer, c integer, d integer,
...> unique (a, b) on conflict ignore);
sqlite> CREATE TRIGGER fooUnique before insert on foo
...> when exists (select a from foo where a=new.a and b=new.b)
L.S.
Here's the patch for those interested:
--- sqlite-3.4.2-orig/src/printf.c 2007-06-28 14:46:19.0 +0200
+++ sqlite-3.4.2/src/printf.c 2007-10-08 11:56:49.0 +0200
@@ -158,7 +158,11 @@
static int et_getdigit(LONGDOUBLE_TYPE *val, int *cnt){
int digit;
Am Freitag, den 05.10.2007, 01:03 +0200 schrieb Kees Nuyt:
> I can't reproduce the exception (the PDO->query
> version) on an environment I happened to have
> available.
>
> - MS Windows XP Professional (5.2 build 2600)
> - Apache 2.2.4
> - PHP 5.2.2
> - PDO SQLite 1.0.1 2007/03/23
> - SQLite
Hi Joe,
standard temp directory in my setup is /tmp, which is both readable and
writeable by Apache. Available space is 21GB, which should be more than
sufficient for the task at hand :-)
CU
Markus
Am Donnerstag, den 04.10.2007, 16:13 -0700 schrieb Joe Wilson:
> See if the apache/mod_php
On 08/10/2007, Daan van der Sanden <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to merge two rows with SQLite? Say I have the following table":
> CREATE TABLE foo(a integer, b integer, c integer, d integer);
> CREATE INDEX idx ON foo(a,b);
>
> With the following data:
>
> INSERT INTO foo
Hi,
Is it possible to merge two rows with SQLite? Say I have the following table":
CREATE TABLE foo(a integer, b integer, c integer, d integer);
CREATE INDEX idx ON foo(a,b);
With the following data:
INSERT INTO foo VALUES (1,1,1,2);
INSERT INTO foo VALUES (1,2,3,4);
INSERT INTO foo VALUES
28 matches
Mail list logo