Greetings!
I have this scenario...
6 users with local dbs
1 network db to backup all those DBs and to share info.
Every local DB unique record id based on the network DB. So, before each
user creates a new record, the tool asks the network ID for the next
available sequential record and
Hi all,
Following up:
I recently installed SQLite 3.3.13, after having used previous
versions. I now get an error:
Error: database is locked
when I use the sqlite3 command line tool to access a database on a
shared volume.
But opening the same file with an earlier version works fine.
The .import cmd has a problem when it encounters binary zeros embedded
in data.
I have a large tab-separated text file which has some garbage (aka
binary zeros) in one of the fields of one of the records. The .import
cmd trips on this and terminates with this msg:
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
> Just out of curiosity, why is the range for an 8 byte integer in SQLite one
> number off from the 8 byte bigint in MSSQL?
>
> SQLite: -9223372036854775807 through 9223372036854775807
> MSSQL : -9223372036854775808 through 9223372036854775807
>
It
Hello to all,
I am working on an 8-byte data type that stores date time and timezone
information and provides helper routines for date arithmatic as well as
conversion to/from strings, julian dates, UNIX date times, etc... The type
can be stored in a 64-bit integer or as an 8 byte blob. The
Thank you samuel
On 07/03/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:
Try this:
UPDATE items
SET price = (
SELECT price
FROM month
WHERE id = items.id)
WHERE id IN (SELECT id from month);
HTH,
Sam
---
We're Hiring! Seeking
Try this:
UPDATE items
SET price = (
SELECT price
FROM month
WHERE id = items.id)
WHERE id IN (SELECT id from month);
HTH,
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in
Just out of curiosity, why is the range for an 8 byte integer in SQLite one
number off from the 8 byte bigint in MSSQL?
SQLite: -9223372036854775807 through 9223372036854775807
MSSQL : -9223372036854775808 through 9223372036854775807
Values are from testing with SQLite 3.3.12 and MSSQL 2005.
thanks Dennis,
Single quote delimit a string literal. Double quotes delimit a quoted
identifier (i.e a column or table name etc that contains special
characters such as a space).
I just checked Sybase Manual, and there it's exactly as you say.
--
cheers,
Stef Mientki
http://pic.flappie.nl
Hello to all I want to know if sqlite supports updates to more than a
table, as mysql allows
Ex:
UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;
Thanks to all
Stef Mientki wrote:
thanks Dennis, Marco,
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
I'm just a novice,
and although both suggested solutions work,
I thought SINGLE QUOTES were thé standard ?
Single quote delimit
Regarding: "... I thought SINGLE QUOTES were thé standard ?"
I believe single quotes are the standard for literal strings, but double quotes
for table names.
-
To unsubscribe, send email to [EMAIL PROTECTED]
thanks Dennis, Marco,
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
I'm just a novice,
and although both suggested solutions work,
I thought SINGLE QUOTES were thé standard ?
--
cheers,
Stef Mientki
Marco Bambini wrote:
The space between Order and Details is the problem.
This syntax:
SELECT * FROM [Order Details]
works fine with SQLiteManager.
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
Dennis Cote
The space between Order and Details is the problem.
This syntax:
SELECT * FROM [Order Details]
works fine with SQLiteManager.
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Mar 7, 2007, at 7:43 PM, Stef Mientki wrote:
csv file is generated by a program. Program generatin csv do not know the
existing id values from database table.
Program can keep id blank or '' or null or some suitable value in csv
file, which SQLite import should understand to generate next id
automatically by SQLite itself to use it as
Did anyone test this database ?
With 3 out of 4 programs I'm not able to read the table "Order Details",
does anyone what's the problem here ?
thanks,
Mikey C wrote:
Here is a database http://www.nabble.com/file/6997/Northwind.db Northwind.db
It is an exact SQLite implementation of the well
You were absolutely right, I didn't call the new dll.
All solved now.
RBS
-Original Message-
From: Trey Mack [mailto:[EMAIL PROTECTED]
Sent: 07 March 2007 13:12
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What is wrong with this simple query (offset)?
> It looks all as it should
Hello John,
a page rank like algorithm does not make sense with only a bunch of text files.
Its power
comes from its hability to take into account the matrix of links between
documents on the web.
In this case, a classic TFIDF http://en.wikipedia.org/wiki/Tf-idf algorithm
should be sufficient.
Hello Jos,
not as is. You need to modify slighlty the library. Half a day of work I guess.
Pierre
- Message d'origine
De : Jos van den Oever <[EMAIL PROTECTED]>
À : sqlite-users@sqlite.org
Envoyé le : Mardi, 6 Mars 2007, 16h33mn 15s
Objet : Re: [sqlite] Re : [sqlite] Soft search in
Thanks, will have a look at that, but I am sure I am calling the new dll as
the declaration in VB doesn't mention the full path and I point to the dll
by changing the curdir.
RBS
-Original Message-
From: Trey Mack [mailto:[EMAIL PROTECTED]
Sent: 07 March 2007 13:12
To:
It looks all as it should work and it compiles with the same number of
warnings, but I get a bad dll calling convention in VB with the extra
integer argument iFields.
You've changed the signature of the method you're calling, and it looks like
you changed it correctly in the VB declaration.
RohitPatel wrote:
/* SQLite 3.3.8 (Windows) used */
/* table t1 */
/* only two columns are given because other columns are irrelevant here */
create table t1 (id INTEGER PRIMARY KEY, name TEXT);
/* few sample records from csv file data.csv */
1,'name_text_1'
2,'name_text_2'
3,'name_text_3'
On 3/6/07, RohitPatel <[EMAIL PROTECTED]> wrote:
/* SQLite 3.3.8 (Windows) used */
/* table t1 */
/* only two columns are given because other columns are irrelevant here */
create table t1 (id INTEGER PRIMARY KEY, name TEXT);
/* few sample records from csv file data.csv */
1,'name_text_1'
Hello dear sqlite users,
Hello dr. Hipp,
I'm trying to create a user-defined function having the name LEFT but that
does not seem to work (I get an sql parsing error). All is fine if I rename
it to STRLEFT, but I'd stick to the first one since I'd like to add some
compatibility with other db
25 matches
Mail list logo
