Hello all,
I was just curious if there was a respository for user defined functions? I
was hoping to find a hash function that I could use to hash some strings
with, and I have not seen anything in the SQLite docs.
Thanks,
Mike
Hi Rich,
On Thu, 10 Jan 2008 16:10:14 -0800 (PST), Rich Shepard
<[EMAIL PROTECTED]> wrote:
> I cannot find the specific syntax on the web site's SELECT page nor in
>Owens' book. It should not be as difficult to craft the statement as I'm
>finding it to be.
>
> Here's what I want (with the
On Thu, 10 Jan 2008, Igor Tandetnik wrote:
I get a different error: no such column "f.subcomp". The reason for this
is that you use Fuzzyset fields in a subquery that's not coordinated with
Fuzzyset.
Igor,
I could generate that error, too.
What you want is something like this:
select
A tired James wrote:
>
> select foo as bah from baz, not select foo from baz as bar, I think.
>
> -- James
Evidently I don't think too well this afternoon; please disregard
this...
-- James
-
To unsubscribe, send
Rich Shepard <[EMAIL PROTECTED]> wrote:
I cannot find the specific syntax on the web site's SELECT page nor
in Owens' book. It should not be as difficult to craft the statement
as
I'm finding it to be.
Here's what I want (with the sqlite3 error following):
SELECT * from Fuzzyset as f
> -Original Message-
> From: Rich Shepard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 10, 2008 4:10 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Syntax for Multi-table Join
>
>I cannot find the specific syntax on the web site's SELECT page nor
in
> Owens' book. It
I cannot find the specific syntax on the web site's SELECT page nor in
Owens' book. It should not be as difficult to craft the statement as I'm
finding it to be.
Here's what I want (with the sqlite3 error following):
SELECT * from Fuzzyset as f
INNER JOIN (SELECT num_ts
On 10-Jan-2008, at 1:45 PM, Samuel Gilbert wrote:
I though that typing ".mode csv" in your SQLite shell would solve
the problem.
I though it might be a good idea to test it before suggesting a
solution.
However, it only works with the results of queries and not with the
built-in
commands.
I though that typing ".mode csv" in your SQLite shell would solve the problem.
I though it might be a good idea to test it before suggesting a solution.
However, it only works with the results of queries and not with the built-in
commands.
I work on X11/Linux, and widening the terminal
Just now I opened a bunch of shells, pasted the same query into all of
them, and closed the ones I didn't want after seeing the result.
So I ran .databases to see which databases I'm actually left with, and
saw something like this (not exact):
seq name file
--- --
Ken <[EMAIL PROTECTED]> wrote:
> A suggestion, instead of using an "integer code" make it a bit mask so that
> any and all permutataions of the defined events can be executed?
>
> That way the tracing function can be installed, and the flag can be set to
> disabled. Effectively disabling
A suggestion, instead of using an "integer code" make it a bit mask so that any
and all permutataions of the defined events can be executed?
That way the tracing function can be installed, and the flag can be set to
disabled. Effectively disabling trace. Not sure if thats something useful or
The current interface definition for sqlite3_trace()
is as follows:
void *sqlite3_trace(
sqlite3 *db, /* Database connection */
void(*xTrace)(void*, const char*), /* Callback function */
void *pArg /* 1st arg to callback */
Hi Prameeth,
Just cut and past the shell.c routines:
open_db
shellstaticFunc
appendText
run_table_dump_query
dump_callback
run_schema_dump_query <- this is the top level routine
Look at the code for dump command to dump everything use:
run_schema_dump_query(p,
"SELECT name,
Petr Vanek <[EMAIL PROTECTED]> wrote:
> I have to perform an additional check for example by a dummy
> select statement to be sure it is a db.
>
Correct. SQLite defers opening and looking at the database file
for as long as it can. This allows you to issue pragma to set
up your connection.
Sqlite will create a database if it does not find one. You really need
to add a test for the existence of the file, such as an "access".
Petr Vanek wrote:
hello sqlite gang,
I'd like to consult here some possible bug in Qt4 SQL library. I'm fixing
one bug in my Qt4 based application and I
hello sqlite gang,
I'd like to consult here some possible bug in Qt4 SQL library. I'm fixing
one bug in my Qt4 based application and I see there is propably buggy
QSqlDatabase::open() method in their Sqlite driver. They are using this
routine to open a database:
...
if
17 matches
Mail list logo