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 application
BY docketno)
WHERE opendoc = 0
What is the table structure?
Jack
--
( Kees Nuyt
)
c[_]
with existing versions.
True.
Christian
--
( Kees Nuyt
)
c[_]
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 might make a significant difference.
--
( Kees Nuyt
)
c[_]
as possible about the 'correctness' ...
--
( Kees Nuyt
)
c[_]
.
--
( Kees Nuyt
)
c[_]
. 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[_]
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[_]
, or speed up
the conversion process.
Regards,
Manzoor Ilahi
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
file tell you which
file format it is. The file format doesn't change that often, so
it can be compatible with several software versions.
LordPhoenix
PS : Sorry for my English I'm french and don't speak this
language very often :)
Many US citizens write worse English than you do ;)
--
( Kees
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, so
it can be compatible with several software
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[_]
-
To unsubscribe, send email
separately.
/citation
...
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
)
c
)
There are many more docs available in:
http://www.sqlite.org/docs.html
Enjoy!
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
= 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[_]
-
To unsubscribe, send
Hi Lloyd,
On Wed, 25 Oct 2006 20:11:49 +0530, you wrote:
Hi list,
can I insert a hexadecimal value to an integer field?
Yes.
if yes How can do that?
Convert it to an integer in your host language first.
The X'hexstring' syntax is only for BLOBs.
Thanks,
Lloyd
--
( Kees Nuyt
any switch anyway. Your approach in the remarks
of said ticket is right, in my view.
Thank you for any abort-on-error solution and the
beautiful, consistent product sqlite is!
--
( Kees Nuyt
)
c[_]
-
To unsubscribe
...
Same here, MS Windows XP Pro, sqlite 3.3.8
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
filename |`` , but with
less overhead.
By the way, where's your primary key?
Hope this helps,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Cariotoglou (see
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools for a
pointer), which even includes a query editor and a report
generator.
Nogmaals bedankt.
Veel plezier!
RBS
--
( Kees Nuyt
)
c
1;
and detect the presence of the file signal.txt in your VBS
script. Or do everything in your .bat (or better, .cmd).
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
off
sqlite SELECT '/table/body/html';
sqlite .q
C:\DATA\opt\test
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
way:
sqlite3 mydatabase.db3
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
library.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
\x4C\x00\x45\x00\);
exit 0} utf16LE.txt
echo BOM for UTF-16 Big Endian
awk
BEGIN{printf(\\xFE\xFF\x00\x55\x00\x54\x00\x46\x00\x2D\x00\x31\x00\x36\x00\x42\x00\x45\);
exit 0} utf16BE.txt
EOF file initutf.cmd
(tested, works with notepad.exe v5.1.2600.2180 Dutch)
HTH
--
( Kees Nuyt
)
c
]
-
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.
If it doesn't raise an VBerror, you don't detect something is
wrong. SQLiteConn.State will not equal slStateClosed but the
error status, so the loops ends and you stop trying to open,
without having opened the database.
HTH
--
( Kees Nuyt
)
c
and
then,
open a new one in unix and import it.
just thinking...
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
--
( Kees Nuyt
)
c
to
shoot yourself in the foot.
http://www.sqlite.org/arch.html might be a good starting point
for further research.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
. Which is very appropriate, but a bit
modest ;)
Oops, there's another link on
http://www.sqlite.org/quickstart.html
as well:
Additional documentation is available here
--
( Kees Nuyt
)
c
with the error:
SQL error code = -104, invalid column reference
Runs fine though in SQLite.
Is this a known feature?
I wouldn't call it a feature, and you'd better not rely on this
behaviour.
RBS
HTH
--
( Kees Nuyt
)
c
found a good replacement
for
and that is to transpose a table from a vertical layout to a horizontal
one,
snip
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
environment sqlite might not
be a suitable solution.
http://www.sqlite.org/whentouse.html
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
default_cache_size
especially when you are building large indexes.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
schemafile.txt contains valid SQLite statements, it
should work.
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
or
.schema
to check what's in there.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
on with my work now!
You're welcome, good luck, have fun.
Michael Hooker
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 30 December 2006 12:38
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Using sqlite.exe
Make that
C:\sqlite3\sqlite3.exe C:\sqlite3\BaseStation.sqb
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
;
Will make the cache size stick to the database, so you don't
have to repeat it every time it is opened.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
on yet another
implementation specific API.
Just my 2 cents.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 31 Jan 2007 18:31:20 -0500, you wrote:
Is cast documented on the sqlite website? I couldn't find it.
http://www.sqlite.org/lang_expr.html
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL
On Wed, 31 Jan 2007 17:30:29 -0500, you wrote:
BTW, what is the concatenation operator?
Standard SQL: string || string
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
be used in the
command line program.
I usually postprocess output by piping it through awk to solve
these kinds of problems.
sqlite3 databasefile sqlscript | awk -f trim.awk outfile
jim
HTH
--
( Kees Nuyt
)
c
releases of this or not)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sqlite3explorer.
I use it in combination with sqlite3.dll, version 3.3.12,
without any problem. I downloaded it 2006-03-13 and it still
works well.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL
.
The MATCH operator is a special syntax for the match() user
function. The default match() function implementation raises and
exception and is not really useful for anything. But extensions
can override the match() function with more helpful logic.
Regards,
Rick van der Lans
HTH
--
( Kees Nuyt
?
This is not a comma delimited values file like .import could
process, but an SQL script. You can execute it like:
sqlite3 databasefilename variable.sql
Or from within sqlite3:
sqlite .read variable.sql
Rich
--
( Kees Nuyt
)
c
, without intermediate file:
sqlite3 database1 .dump | sqlite database3
sqlite3 database2 .dump | sqlite database3
See also: http://www.sqlite.org/sqlite.html
Thanks!
Hope this helps.
--
( Kees Nuyt
)
c
carefully (not contained in the
collection of reserved words), the [] could easily be filtered
out with sed or awk.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
type.
Just my 0.02
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, DROPs and
UPDATEs can damage your data as well.
Best Regards,
A. Sreedhar.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
] ASC;
I agree it seems slightly inconsistent behaviour.
[] around identifiers are not standard SQL.
You would only need them (or double quotes, which is
standard SQL) if you choose reserved words as
identifiers.
--
( Kees Nuyt
)
c[_]
___
sqlite
On Wed, 12 Mar 2008 18:44:36 -, Bart wrote:
Kees,
Would you be interested to do a project for me for a fee?
[..]
Regards, Bart Smissaert
Answered in private mail.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users
capable PDO_sqlite
for PHP4 (I doubt it, PHP4 practically reached end of
life).
best regards
Giovanni Rossati
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
..e on
I'm sure it is explained in a previous chapter, but
you can always type .help in the command line tool.
It recognizes commands as soon as it the first 1..N
characters are unique.
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
as patching table pages by
hex-editing the database file.
Feel free to do it, but don't expect a safety net.
Thanks again
Marco
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
error.
Ok, I understand now.
Thanks again
Marco
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the magic
filename :memory: refers to an in-memory database.
Thanks
Fred
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
=php_pdo_sqlite_external.dll
plus the current sqlite3.dll
That works for me.
php_pdo_sqlite_external.dll can be in the php/ext
directory, as usual.
You may have to copy sqlite3.dll to the apache/bin
directory.
Thank you.
HTH
--
( Kees Nuyt
)
c
ext3 tinyfilesystem
somewhat similar to busybox file system !
If you had to port the sources to a new OS it is easy
to make mistakes in the platform specific file I/O
routines. They might not return the correct status.
--
( Kees Nuyt
)
c
;
can't open C:/_source/test.sql;
Drop the semicolon, .read is not an SQL statement.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/ms682586.aspx
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for instructions
sqlite .schema
CREATE TABLE test (id, nome, classe, istanza);
sqlite .q
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
return rows in the region of interest.
i am having 6 records.
Is there any other way to optimize.
Have a look at
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
for how and why to optimize a scrolling list.
Thanks Regards,
Mahalakshmi
--
( Kees Nuyt
)
c
filename
extension (.db3) with it.
The command (wrapped by mail):
path\firefox.exe -chrome
chrome://sqlitemanager/content/sqlitemanager.xul
mydb.db3
just doesn't do the trick.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
is 42.
Indeed.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
an
SQLite version 2 database.
You will have to convert your SQLite v3 database to
SQLite v2 before uploading:
sqlite3 .dump your.db3 | sqlite2 your.db2
And hope you didn't use SQL that SQLite v2 doesn't
understand.
--
( Kees Nuyt
)
c[_]
___
sqlite
by applying the right PRAGMAs.
http://www.sqlite.org/pragma.html#pragma_journal_mode
http://www.sqlite.org/pragma.html#pragma_synchronous
Thanks
--
Morten Bjoernsvik, Oslo, Norway
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
storage.
The same happens in the SQLite command line tool if you do
not use a database file name as a commandline parameter.
In-memory databases created in this way disappear completely
after sqlite3_close(), or after exit program, or after the
.quit command in the command line tool.
--
( Kees Nuyt
of gaps in the page layout
);
A wealth of information, really.
sqlite3_analyzer is available on the download page
http://www.sqlite.org/download.html .
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
information:
http://csrc.nist.gov/groups/STM/cmvp/validation.html
Thanks, Dan
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
as well as table's columns name to the file.
On one line:
echo .headers on\n.separator ,\nselect 'myTable' as
tablename,* from myTable; | sqlite3 databasefilename
dataFile
Thanks in advance,
JP
I hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite
.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
binary_report_fmt where column_id = 3 order
by column_id desc);
but it only updates the last item. I guess I can make it a non-
primary key..then it works perfectly.
Gregor
Add a large value to all column_id that have to be changed,
then subtract that same value minus 1.
--
( Kees Nuyt
Small. Fast. Reliable.
Choose any three
==
Small. Fast. Reliable. Free.
Choose any four
:)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
If DBDesigner can handle ODBC, you could try one of the
SQLite_ODBC drivers. But that will not solve everything, as
DBDesigner probably doesn't know the SQLite syntax.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
, 'B',
20.0, 20.0);
[snip]
then every thing goes right.
Am I doing something wrong ?
I don't see any errors, I copied your code verbatim, only
changed some indentation.
Thanks in advance.
Xevi
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
David
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
means conditional logic, testing for
recordid range)?
Thanks in advance.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, but probably
feasible.
Both methods only work if your schema is stable.
I'm stuck with my problem so perhaps here is someone with a really
clever idea.
Sorry for my bad english,
No problem, it's clear.
greetings from hamburg, germany
Till
Greetings from Rotterdam, Netherlands.
--
( Kees Nuyt
/gmane.comp.db.sqlite.general/17286/match=managing+trees+database
and
http://www.sitepoint.com/article/hierarchical-data-database
may help on maintaining trees in a relational database.
Or search the net on Joe Celko and nested sets.
--
( Kees Nuyt
)
c[_]
___
sqlite
On Wed, 6 Aug 2008 16:45:35 -0400, Jeffrey Becker wrote:
On Wed, Aug 6, 2008 at 4:10 PM,
Kees Nuyt [EMAIL PROTECTED] wrote:
Additionally: NodeID and ParentID shouldn't be blobs.
Integer is the most suitable type for IDs.
The blobs I'm inserting are actually a binary representation designed
ON jobs(TSN);
CREATE TRIGGER jobs_ins AFTER INSERT ON jobs
FOR EACH ROW BEGIN
DELETE FROM jobs WHERE jobid (NEW.jobid - );
END;
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
agree (3) should be removed. If it would break any of my
applications (which I doubt), I'll gladly repair it, because
I would have done a bad job, not you.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
On Sat, 9 Aug 2008 09:21:07 +1200, you wrote:
The second question is what can I do to prevent this problem occurring?
Is the database shared over NFS?
Do you use any dangerous PRAGMA, like PRAGMA synchronous =
OFF; ?
--
( Kees Nuyt
)
c
://www.sqlite.org/lang_createtrigger.html
Regards,
Marton
I hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 14 Aug 2008 13:25:56 -0700, you wrote:
--
-- A LITTLE CLEANUP BEFORE WE CONTINUE
--
DROP TABLE TEST1;
I don't think you really want to drop TEST1.
We'll need it later.
--
( Kees Nuyt
)
c
of this box.
Hint:
For a genuinely level playing field you'd have to use more
PRAGMAs, like page size and cache size. Defaults might be
different in different environments.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
auto_vacuum =
0 | none | 1 | full | 2 | incremental;
PRAGMA incremental_vacuum(N);
http://www.sqlite.org/pragma.html#pragma_incremental_vacuum
Thanks,
Richard
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
:
PRAGMA [database.]table_info(table-name);
Most other databse specific PRAGMAs support the
databasealias. prefix, so does this one, although it isn't
documented in http://www.sqlite.org/pragma.html#schema .
Thanks,
Mrinal.
--
( Kees Nuyt
)
c
On Wed, 20 Aug 2008 06:33:17 +0530, Mrinal wrote:
Try:
PRAGMA [database.]table_info(table-name);
( Kees Nuyt
Thankyou Kees for the solution
yw.
But, I am facing another problem
[...]
As Dennis said, that looks like a bug.
I just confirmed SQLite 3.6.0 behaves the same way.
Apparently
On Thu, 21 Aug 2008 02:18:39 +0530, Mrinal wrote:
As Dennis said, that looks like a bug.
Created a new ticket (number 3320:
http://www.sqlite.org/cvstrac/tktview?tn=3320)
which has been fixed now.
Wow, that's fast.
- Mrinal.
--
( Kees Nuyt
)
c
;
VACUUM;
PRAGMA schema_version;
2
PRAGMA page_size;
1024
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
Perhaps there is an esential difference between your test
program and the command line tool?
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to be identified by the missing
commit logrecord, not by the presence of a rollback
logrecord. Reason: In case of crashes you won't be able to
log rollbacks, anyway, whereas SQLite will rollback using
the journal the first time a new connection is made.
Best regards, Alexey.
--
( Kees Nuyt
)
c
On Fri, 12 Sep 2008 11:19:41 -0700 (PDT), you wrote:
I am new to SQLite
Since 51 weeks, to be exact ;)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/realsqlserver/
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
1 - 100 of 750 matches
Mail list logo