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 work
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 w
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 conf
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 mor
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 symbols when building testfixture:
/cygdrive/c/mse/ccm_wa/hsspla/SDM/SQLite-REL01/SQLite/build/cygwin/build
/bld/../../../../Source/sqlite-3.5.
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 tracking
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 b
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 c
Aviad Harell <[EMAIL PROTECTED]>
wrote:
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:
c
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: sqlit
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 di
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 pr
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 takin
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 best
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 t
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 t
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.
Regar
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;
LONGDOUBLE_TY
Thanks for the quick reply!
Simon Davies writes:
> sqlite> select a,b,sum(c),sum(d) from foo group by a,b;
>
> gives you the data you are after. This could be used to populate
> another table via
>
> sqlite> insert into newFoo select a,b,sum(c),sum(d) from foo group by
> a,b;
>
> Of course, if y
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 libr
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 proces
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 VAL
SQL Guru's,
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
-x-
Chetana
__
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 (1,2
Why sqlite3_prepare (... , "select name from sqlite_master where type =
'table' order by name", ...) could return SQLITE_BUSY or SQLITE_OK
dependent on database size?
I'm using Sqlite 3.3.7 and single thread execution.
I have database with about 20 tables and some tables hold about 50'000
records a
33 matches
Mail list logo