On Thu, 20 Sep 2007 13:57:58 -0400, Liam wrote:
> It would be nice if the documentation gave a
> brief indication when a feature is added
> ("new in 3.5.0" unobtrusively somewhere).
Like in http://www.sqlite.org/34to35.html ?
--
ed.
The link isn't on the page anymore, but (as with many old
versions) the download is still available:
http://www.sqlite.org/sqlitedll-2_8_17.zip
I'm glad you managed to compile it by yourself.
--
( Kee
omodate 3.5
MByte.
Ideally, the page_size should equal the allocation unit (for
Window: the cluster size of the formatted disk).
Also, if your rows can be large, a too small page_size would
cause overflow pages, and thus additional overhead.
>Thanks in advance.
On Mon, 24 Sep 2007 10:35:51 -0700, you wrote:
>Kees Nuyt wrote:
>> On Mon, 24 Sep 2007 07:13:51 -0700, Gururaja Nittur wrote:
>>
>>
>>> Sqlite experts,
>>>
>>> I am running Sqlite version 3.4.1. I ran some performance tests and
>>> obs
ious key and concatenate the rest.
- store 'fred' as (2,ed)
- store 'google' as (0,google)
- store 'gopher' as (2,pher)
This works nicely for large indexes with long keys and a lot of
repetition. Of course the effort to handle insertions and
deletions is sign
our
php-cli uses another php.ini than the Apache module does.
Good luck !
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
age earlier
>
>-x-
>Chetana
This might be of help:
http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers
http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
--
( Kees Nuyt
)
c[_]
t_id INTEGER PRIMARY KEY,
t_name TEXT
)
SQLite version 3.4.2
Enter ".help" for instructions
sqlite>
Hope this helps.
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tails automatically."
And this is about the TCL transaction {} method.
>You might want to be a little bit more clear about the fact that [transaction]
>nests even though BEGIN does not.
The TCL transaction{} can be nested, the SQL BEGIN can't.
As drh wrote:
>> The
On Fri, 12 Oct 2007 01:00:32 -0500, you wrote:
>On Thu, 11 Oct 2007 13:33:35 +0200, Kees Nuyt wrote
>> On Wed, 10 Oct 2007 22:10:38 -0500, you wrote:
>>> You might want to be a little bit more clear about the fact that
>>> [transaction] nests even though BEGIN does not
atabases can usually be converted easily to v3 with:
sqlite2 yourv2.db .dump | sqlite3 yourv3.db
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
OWID in
the table prior to the insert.
And:
If a column has the type INTEGER PRIMARY KEY AUTOINCREMENT then
a slightly different ROWID selection algorithm is used.
By supplying NULL as the key (ROWID) you actually don't specify
a value, so SQLite creates a new row wi
en more speed you can prepare the SELECT statement during
the init of your program, and bind to the appropriate values
every time you need it, so it doesn't have to be parsed every
time.
Regards,
--
( Kees Nuyt
)
c[_]
--
ing scheme
as current versions). You might even be able to find v2.1 in
this way, but first you should try v2.8.17.
You can use the v2.8.17 sqlite.exe program to test if your
version 2.1 database is accessible from version 2.8.17.
>thank u
>vijaya
>
>
>Kees Nuyt wrote:
>>
known beforehand that it is not reliable if used with ON CONFLICT clauses.
>
>Mike
Perhaps
http://www.sqlite.org/capi3ref.html#sqlite3_update_hook
can help you solve your problem?
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Just some suggestions:
Index locid in both tables, and rewrite
> select *
> from blocks,locations
> where locations.locid = blocks.locid
> AND ? >= blocks.startIpNum
> AND ? <= blocks.endIpNum
to:
select *
from blocks
INNER JOIN locations USING (locid)
where ? >= blocks.sta
take quite
some time, but as long as the dbfile format stays the same that
won't be a problem, as we will be using the PHP-specific library
version anyway.
I hope Mike Cariotoglou is willing to update sqlite3explorer ;)
The same probably goes for other less actively maintained
frontends.
--
se sqlite3_step() etc. to fish values out of pTmp */
> sqlite3_transfer_bindings(pTmp, X);
> sqlite3_finalize(pTmp);
>
>Dan.
Very smart indeed!
Would it matter much that sqlite3_transfer_bindings() is marked
obsolete in the docs, and, as a result, only d
f I'd
>happily buy one of them [they're inexpensive enough], but I"m just
>trying to correct typos in a DB that I recently converted to version 3]
>Thanks!
> /bernie\
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
gt;1968-08-02
>
>But is there a more robust, built in method?
>
>Thanks,
>Tom
Often there are data cleaning and normalizing tasks to be
performed before the data is ready for (read: can be piped into)
the database.
I would preproces
ll be about a quarter to a third of the full size.
Using the API or the command line tool (.import) is much easier,
and very fast, if done right (transactions).
The library and the command line tool are both smaller than 400k
(MS Windows, v3.4.2), so why bother?
>Than
.dump |
awk '{sub(/ oldtable /," newtable ");print}' |
sqlite new_db
(all on one line, but I added linefeeds after every pipe
character for clarity)
Untested, parenthesis in positions where i assume spaces might
cause some problems, but you get the idea.
HTH
--
( Kees Nuyt
)
c[_]
-
g updates and deletes
(using triggers) between the 'numeric table' and the 'text
table'.
>Best regards,
>Igor
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
a time... something like:
>
>SELECT * FROM table LIMIT 1 OFFSET 2;
Please read this article from drh to improve performance on that
one.
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
--
( Kees Nuyt
)
c[_]
---
TRANSACTION is an alias for COMMIT.
So, you can use either.
>Thanks,
>JP
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
d 'EXPLAIN QUERY
PLAN SELECT ...' output with and without index.
>Is SQLite going to be able to handle, say, 2,000,000 data pairs, and say
>60,000 positions, efficiently and quickly?
In general, yes.
>How can I help SQLite perfor
On Fri, 23 Nov 2007 18:47:40 +0100, <[EMAIL PROTECTED]> wrote:
>Btw, what would be the best GUI to use?
I am happy with SQLite3Explorer.
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
http://www.singular.gr/sqlite/
HTH
--
( Kees N
ogress, not a done
>deal. I am still looking for suggestions, comments,
>and bug reports.
Currently there seems to be no link to the
http://www.sqlite.org/contrib page.
On the contrib page a link to
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
would
tion: Perhaps even on the home page.
"This the homepage for SQLite - a library that implements a
self-contained, serverless, zero-configuration, _portable_,
transactional SQL database engine."
With a link to a 'Portable' paragraph on the 'Di
onths of messages in this list.
Over 13000 messages, 54 MByte raw, 8.5 MByte zipped.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
atabaseexaminationue0.jpg>
>
>* SimpleSQLite.zip: written by C++/Qt (it needs Qt open source
> edition 4.3.1 to run executables)
>
>http://img338.imageshack.us/img338/2189/simplesqliteps6.jpg
><http://img338.imageshack.us/img338/
ntionally, you can:
http://www.sqlite.org/lockingv3.html has a chapter 6.0 How To
Corrupt Your Database Files
>We would like to integrate error handling into our software to handle
>all cases.
>
>Regards,
>
blea_old;
-- Drop the original table
DROP TABLE tablea_old;
-- optimize the database
VACUUM;
ANALYZE;
>Thanks,
>jp
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
e table and get the information from
the result set.
There was a discussion over that last method just one or two
days ago, so you could try the archives.
sqlite3_column_count() perhaps?
>Thanks for the info.
>JP
HTH
--
ase-event
ON [database-name .] view-name
trigger-action
Your trigger-action can do about anything.
>Thanks,
>Robert
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ttp://docs.python.org/lib/module-sqlite3.html, shouldn't the
last line be:
""", ('hui*'))
(without the extra comma)?
>The database used can be downloaded from
> http://xile.org/le/prepared_statement.zip (1.75 MB)
>
&
P.
I didn't try php_pdo_sqlite_external yet, it seems to call a
self-supplied sqlite3.dll, so one would be able to use the
latest SQLite3 version.
>Don't worry about PHP4, as this old version will no more be
>supported soon...
--
( Kees Nuyt
)
c[_]
--
ues ('delta','kappa');
and rerun your test to see what happens.
>P.s. in our program, the "update" statement are generated from a
>database-layer, and optimize the statement generation is a big work..
>for that i'm trying to understand
t; if (DATABASE_SERVER == SERVER_MYSQL) {
>$dbh = new PDO("mysql:host=localhost;dbname=tasks", "tasks",
>"tasks");
> }
> else {
>$dbh = new PDO('sqlite:tasks.db');
> }
>}
Nice setup.
I still have MySQL v5.0.41 running next to SQLite for a
specifics that need to be managed outside the
>> >>> context of
>> >>> SQLite, I am fine with that. However, for doing external
>> >>> management I
>> >>> believe I would need hooks into the basic management of the
>> >>> database. What I
>> >>> would like to know
On Wed, 12 Dec 2007 11:28:40 +, [EMAIL PROTECTED] wrote:
> SQLite Consortium Launches With Mozilla And
> Symbian As Charter Members
>
Congratulations!
--
( Kees N
PRAGMA user_version = 6002;
INSERT INTO test1 VALUES (1,'alpha');
INSERT INTO test2 VALUES (2,'beta');
PRAGMA schema_version;
: 3
PRAGMA user_version;
: 6002
>Thanks,
>JP
I hope this helps,
--
( Kees Nuyt
)
c[_]
---
On Fri, 14 Dec 2007 03:15:17 +0100, Gilles Ganault
<[EMAIL PROTECTED]> wrote:
>On Mon, 10 Dec 2007 16:35:48 +0100, Kees Nuyt <[EMAIL PROTECTED]> wrote:
> >So I activated php_pdo_sqlite_external instead and copied
> >sqlite3.dll v3.5.3 to %serverroot%/bin .
>
DestinationAdd DOUBLE,
ProtocolINT,
Direction INT,
SourcePort INT,
DestinationPort INT
);
CREATE TABLE HipsLog (
FlagINT,
LogDate DOUBLE,
Parent VARCHAR(255),
Target VARCHAR(255)
);
http://www.personalfire
elect statement how SQLite
behaves. Apart from the architecture and optimization pages on
the SQLite website, you may want to study
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>Thanks & Best Regards,
>A.Sreedhar.
--
( Kees Nuyt
)
c[_]
:-/
>
>Tom
Just for the record:
There is a fix in CSV, which will be included in the next
version.
Related Check-ins:
2007-Dec-18 15:41 Check-in [4638] : In the CLI, quote strings
that contain the separator character. Ticket #2850. (By drh)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.help" for instructions
sqlite> .mode csv
sqlite> .output filename.ext
sqlite> SELECT * FROM tablename;
sqlite> .q
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ER INSERT and AFTER UPDATE
triggers, which would store the result of the comparison in a
fourth, indexed, column.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ery plan had another column that
>indicated which columns it had to crawl through...
EXPLAIN QUERY PLAN SELECT ... only shows which access strategy
the optimizer has chosen.
You will get much more detail with EXPLAIN SELECT ...
It shows the VDBE code, which looks cryptic at first but will
pr
---
>
>I just fetch one row.
>
>if that get's a return I update otherwise I insert a new row.
>
>QUESTION: is there a better way to make this important decision? using
>Sqlite
>
>regards W.Braun
INSERT OR REPLACE may work for you.
http://ww
ny
>>rows you do an `INSERT`.
>>
>> In #1, you always get the job done with a single query. In #2,
>> you are usually done after the first but sometimes need a second.
>> Both are more efficient than your current approach, which always
>> runs two queries.
>>
>> Regards,
>>
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ECTED]> :
IT> You can do
IT>
IT> UPDATE ... WHERE keyfield='xxx';
IT>
IT> then use sqlite3_changes to see whether any update
IT> has in fact taken place, and run INSERT if not.
IT>
IT> Igor Tandetnik
>Thanks in advance and happy hollidays!
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
rator
>Thanks, Lothar
Hope this helps.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Sat, 29 Dec 2007 15:17:27 +0100, Lothar Behrens
<[EMAIL PROTECTED]> wrote:
>
>Am 29.12.2007 um 13:59 schrieb Kees Nuyt:
>
>>
>> Hi Lothar,
>>
>> On Sat, 29 Dec 2007 13:13:04 +0100, Lothar Behrens
>> <[EMAIL PROTECTED]> wrote:
>>
>>
SELECT timestamp, x, y FROM d2007.myname;
DETACH DATABASE d2007;
If the table structures are exactly the same, the INSERT
statement can even be shortened:
INSERT INTO myname SELECT * FROM d2006.myname;
etc.
>Thanks in advance W.Braun
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ld be possible, an update trigger most
likely wouldn't fire on a failed update. The only thing you can
rely on is: zero rows changed.
But you could try it anyway.
Experiments are always worth the effort.
--
( Kees Nuyt
)
c[_]
-
of the
PRIMARY KEY of the row in the resultset (Role.id ?), it probably
already is available in Role.*.
Iterate over the columns in the resultset and it should be
there. But perhaps I didn't understand your question correctly?
>Thanks
x column or what column(s) were used to select
>that column.
You know the query, and also the schema, for example from
PRAGMA table_info(tabelname);
That includes primary key info.
Merge that with the i
tudy the source code of some SQLite GUI
front ends to see how they do it?
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
<[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject: Re: [sqlite] sqlite3_rowid
>I will probably just do it myself. I try not to reinvent
>the wheel where possible. ;)
Good luck then ;)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ysql> SELECT EXISTS(SELECT x FROM t1);
+--+
| EXISTS(SELECT x FROM t1) |
+--+
|1 |
+--+
1 row in set (0.02 sec)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 2 Jan 2008 17:49:36 -0600, "Jay Sprenkle"
<[EMAIL PROTECTED]> wrote:
>On Jan 2, 2008 5:31 AM, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
>I found a solution that seems workable. I ended up rewriting my query
>class so it assumes a bunch of things
month");
>2006-03-03
>--> not correct
>
>
>Can anyone confirm? Any suggestions / workarounds greatfully received!
Confirmed.
Better:
select date('2006-03-31', 'start of month','-1 month');
>Many thanks
HTH
>Craig
--
( Kees Nuyt
)
c[_]
--
;I suspect the answer is no, but is there any way to salvage any of the data?
You could try the .dump command in the command line tool, but
I'm afraid you're out of luck.
>Thanks
>
>Doug
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ps the original poster.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
y, integers are compressed, so they don't occupy eight
bytes all the time.
sqlite3_column_int64(); will always return a sqlite3_int64.
So, no need to worry.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
to COMMIT your INSERTs frequently
and measure the size of the database file.
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
O_sqlite:
* php_pdo_sqlite
Has SQLite linked in. Depending on your Linux distribution
and/or your PHP version that might be an obsolete version of
SQLite.
* php_pdo_sqlite_external
Uses any SQLite3 library you offer it, for example the compiled
amalgamation.
>Than
On Fri, 04 Jan 2008 18:16:29 +, [EMAIL PROTECTED] wrote:
>Kees Nuyt <[EMAIL PROTECTED]> wrote:
>>
>> There are two flavours of PDO_sqlite:
>>
>> * php_pdo_sqlite
>> Has SQLite linked in. Depending on your Linux distribution
>> and/or your
TECTED] "
>
>I've never posted on eWeek before so this is upsetting.
>
>Sam
The message is confusing, they mean to say you have to register
to post there. Once you register and login, posting is enabled.
--
( Kees Nuyt
)
c[_]
Lite into thinking this is a
numerical expression ( + ) of which the outcome is zero, because
from a numerical viewpoint all the terms have value zero.
In other words: The contatenation operator is || , not +.
--
( Kees Nuyt
)
c[_]
---
track of AUTOINCREMENT keys.
>Is it possible to instruct SQLite not to create any auto
>indices for the tables I create? If so, how?
Change your schema.
>Thanks and Regards,
>Yuva
HTH
--
( Kees Nuyt
)
c[_]
ifficult to build your own sqlite3_bind_trimmedtext().
I usually delegate the data-validation and -massaging to the
application level.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sidered rude (my girlfriend is
Latvian from Russian parents, so I have some experience with
this kind of culture shock).
We can't expect all posters here to conform to Western European
or USAn habits.
--
( Kee
f.comp=v.comp_name
AND f.subcomp=v.subcomp_name);
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
the operating system?
Is your database on a network share / NFS / SAMBA drive, and if
so, is the filelocking of your filesystem fail proof?
Or do you use a server layer that connects your users to the
database?
Does your application handle exceptions properly?
--
( Kees Nuyt
)
c[_]
in of a 'true'
relational database engine, just like other constraints ('data
domain integrity').
That's because I think a database table should be thought of as
a relation, or a set, not a file. Similarly a database is more
than a file cabin
Hi Jose,
On Sun, 13 Jan 2008 23:47:04 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
>"Kees Nuyt" trying to help me said...
>
>> On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera"
>> <[EMAIL PROTECTED]> wrote:
>>
CHAR(4) 0 0
2jobprio INTEGER 0 9 0
3status CHAR(1) 0 'W' 0
4userid VARCHAR(8) 990
etc.
The columns of this resultset have metadata, just like a normal resultset.
Te
atter case, you may have to copy libsqlite3.so
to the apache/bin directory.
PDO is getting quite popular, not only for sqlite, but
also for other database engines.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
he names I use internally.
col1namecol2name'
?>
You could fetch the column names from a 'dictionary'
table in your database:
CREATE TABLE Friendlynames (
tablenmTEXT NOT NULL,
columnnm TEXT NOT NULL,
friendlynm TEXT NOT NULL,
PRIMARY KEY (tablenm,columnnm)
);
>
a bug. You
could open a bug ticket for it (after checking the
most recent version still behaves like that).
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
version still behaves like that).
No need to file a ticket, it has been repaired today:
http://www.sqlite.org/cvstrac/chngview?cn=4781
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
than will
fit on one index page, and you probably want the users
to be able to jump to the next page, this page might
be of interest for you:
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing lis
On Wed, 12 Jul 2006 19:05:51 +0100, you wrote:
> Hi, how can I find out the names of the
> fields within a given table?
>
> I've tried "pragma table_info(test);"
> but this brings back too much info,
> I just require the names as I'll be
> storing them in an array within my application.
Your
end)AS opendoc
>FROM cntt_sales2 GROUP BY docketno)
>WHERE opendoc = 0
What is the table structure?
>Jack
--
( Kees Nuyt
)
c[_]
k journal not
>being present, this should be backward compatible with existing versions.
True.
>Christian
--
( Kees Nuyt
)
c[_]
d disk
>performance should be about equal on both machines.
You don't mention the settings / optimisations of the
filesystems, nor the amount of memory the OS allows the
filesystem for caching. At least in Windows, server and desktop
versions have different optimisations.
In my opinion this m
ptions as possible about the 'correctness' ...
--
( Kees Nuyt
)
c[_]
many other people if such a feature
were available.
In order to keep sqlite lean and mean where needed I think it
should be a compile time option.
--
( Kees Nuyt
)
c[_]
for the column by querying the database. is there a
>way to do so? I've looked into the doc (for example,
>"information_schema") but I found nothing which was working for me...
Will
PRAGMA table_info(tablename);
do?
>thanks and regards,
>MF
--
( Kees Nuyt
)
c[_]
d
handling:
- optimize your schema
- don't store anything you don't really need
- define indexes for every column you will join on
- be very critical on your joins
- experiment with table order in joins
- sometimes a union of two or more inner joins
is better than one outer join
- experiment
- read the page about index usage
- use EXPLAIN
Many of these techniques are discussed on the sqlite site, it
really pays off to try to read all of it.
--
( Kees Nuyt
)
c[_]
ch sense to have data in that database indexed by SQLite.
You'd better use the index of that given database, or speed up
the conversion process.
>Regards,
>
>Manzoor Ilahi
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
e worse English than you do ;)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Thu, 28 Sep 2006 09:35:54 +0200, you wrote:
> Le Thu, 28 Sep 2006 00:01:08 +0200,
> Kees Nuyt <[EMAIL PROTECTED]> a écrit :
>
>> The first 15 bytes of the sqlite database file tell you which
>> file format it is. The file format doesn't change that often,
Read about SQLite internals for a more detailed explanation.
http://www.sqlite.org/arch.html
The page cache can be shared by mutiple daatabase connections:
http://www.sqlite.org/sharedcache.html
--
( Kees Nuyt
)
c[_]
-
automatic B-Tree
key generation is available separately."
> ...
> Chetana.
I hope this helps.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Thu, 12 Oct 2006 15:24:22 -0400, you wrote:
> PD: I think it could be implement in SQLite to but
> I dont know if it support UNION in selects...
It does. http://www.sqlite.org/lang_select.html
--
( Kees Nuyt
ch.html (Page Cache)
http://www.sqlite.org/opcode.html (Transaction)
http://www.sqlite.org/lockingv3.html (Rollback Journal)
There are many more docs available in:
http://www.sqlite.org/docs.html
Enjoy!
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ecord set val = qty * (select price from
historicalprice where historicalprice.itemid ==
salesrecord.itemid); {untested}
It depends on the version if you can use this.
>thanks.
>
>Radzi.
--
( Kees Nuyt
)
c[_]
--
201 - 300 of 849 matches
Mail list logo