>>fileall.sql
sqlite3 database3 http://www.sqlite.org/sqlite.html
>Thanks!
Hope this helps.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
'Centroid',0,100,0.2,'Strong','Fuzzy Space','Minimum','Min-max');
>
> There are 14 fields and no extra space trailing the final ';'. The schema
>is attached for reference.
>
> What have I gotten wrong this time, please?
This is not a com
ment the
REGEXP operator.
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,
>R
, try to create a new
one from 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 unsubscr
ar.gr/sqlite/ (Not sure if there
>will be future releases of this or not)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
nsion(X,Y) can be used in the
command line program.
I usually postprocess output by piping it through awk to solve
these kinds of problems.
sqlite3 databasefile outfile
>jim
HTH
--
( Kees Nuyt
)
c[_]
-
To unsub
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]
-
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 [EM
e of speed... especially since the
>value I needed was so tantalizing close in the VDBE struct.
The SELECT will be quite fast, chances are the required pages of
the unique index will still be in the cache.
In my opinion it is always better to write portable code, so I
would prefer to rely on generic SQL than on yet another
implementation specific API.
Just my 2 cents.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
created.
PRAGMA default_cache_size = 100;
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]
-
nd that number is
>only going to get bigger! So I'll have to figure out a better table
>structure anyway.
>
>Additional thoughts:
>
>In general, I think splitting the tables up is the way to go. Any further
>comments/suggestions appreciated!
>
>Jonathan
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
on:
suppress if redirection is active.
>Thanks once again - I can get 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
&
hen execute
.tables
or
.schema
to check what's in there.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Fri, 29 Dec 2006 12:33:46 -0500, you wrote:
> Sqlite3 newdatabase.db .read schemafile.txt
>
> But, when I issue this command from the DOS prompt,
> it gives me an error message saying that there
> is no command named "read".
Try input redirection:
Sqlite3 newdatabase.db
up inserts?
>
>RBS
PRAGMA cache_size
PRAGMA default_cache_size
especially when you are building large indexes.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
gt;CISSP, System Architect
>SafeNet, Inc.
I wonder if shared cache would help you?
http://www.sqlite.org/sharedcache.html
In general, in a high concurrency environment sqlite might not
be a suitable solution.
http://www.sqlite.org/whentouse.html
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ECTED]
>> Sent: 14 December 2006 06:59
>> To: sqlite-users@sqlite.org
>> Subject: Re: [sqlite] Transpose table
>>
>> Can you please provide a use case for your example, so we know what
>> you're trying to accomplish? That should help us to help you better.
>> -- Darren Duncan
>>
>> At 12:08 AM + 12/14/06, RB Smissaert wrote:
>>>I am moving my code away from VBA and transferring it to SQL. There is
>>>one particular routine where I haven't found a good replacement
>> for
>>>and that is to transpose a table from a vertical layout to a horizontal
>> one,
>>
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
>I just tried it in Interbase and the above construction
>indeed doesn't work 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 f
ndows"
>sqlite-3_3_8.zip link. 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
s easy 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]
-
and
>> then,
>> open a new one in unix and import it.
>>
>> just thinking...
>>
>>
>>
>> -
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
>> -
>>
>>
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
hen it
fails.
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
--
( Kee
nsubscribe, send email to [EMAIL PROTECTED]
>-----
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
nitutf.cmd ----
(tested, works with notepad.exe v5.1.2600.2180 Dutch)
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ite library.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
that database, you have to open it
in the same way:
sqlite3 mydatabase.db3
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
mp/master.html
sqlite> SELECT 'Database schema';
sqlite> SELECT 'Report on database schema TESTtables';
sqlite> .mode html
sqlite> .headers on
sqlite> select * from sqlite_master order by type,name;
sqlite> .mode list
sqlite> .headers off
sqlite
select SUBJECT_TYPE from ReadCode limit 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]
-
excellent
Sqlite3Explorer by Mike 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!
&
On Tue, 14 Nov 2006 23:44:12 -, you wrote:
>Have figure out now what the quickest way is to move data from Interbase to
>a SQLite db file:
>IB to ADO recordset
>Recordset to text
>Import the text file with the .import command.
>
>Now I am trying to figure out how to automate the last step
3.8,
>the same also on Mac OS X, sqlite3 3.3.7...
Same here, MS Windows XP Pro, sqlite 3.3.8
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
of the program name itself it is easy
to add 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 i
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
--
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[_]
--
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]
-
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
automatic B-Tree
key generation is available separately."
> ...
> Chetana.
I hope this helps.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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[_]
-
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,
e worse English than you do ;)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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]
-
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[_]
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[_]
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[_]
ptions as possible about the 'correctness' ...
--
( 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
k journal not
>being present, this should be backward compatible with existing versions.
True.
>Christian
--
( Kees Nuyt
)
c[_]
end)AS opendoc
>FROM cntt_sales2 GROUP BY docketno)
>WHERE opendoc = 0
What is the table structure?
>Jack
--
( Kees Nuyt
)
c[_]
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
801 - 849 of 849 matches
Mail list logo