There are good reasons to have "NULL" values - though they can make the live
a bit harder. Use them - even Microsoft has found out, that they made a
big mistake
in .NET 1.x and corrected them in 2.0 by introducing nullable types.
Darren Duncan schrieb:
You can save your self a lot of grief by d
Hi,
I am new to database programming, It will be great if somebody will answer
these queries:
Query 1)
Say, I have a table which is having following column
1) STRING 1( string: 12 char max)
2) STRING 2 (string, 12 char max)
3) path( long string)
4) State ( boolean)
5) pupose ( 1 byte)
Assu
Hi,
How much time can it take to perform 2000 selection queries on the
same database ? Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?
Thanks,
Lloyd
__
Scanned and protected by Email scanner
http://www.sqlite.org/cvstrac/tktview?tn=2046 should fix this for fts1 and fts2.
-scott
On 11/21/06, Ralf Junker <[EMAIL PROTECTED]> wrote:
Hello Scott Hess,
>>Not directly related to the format change, but did you have a chance
>>to look at ticket #2046?
>
>Yes, I took a look at it - I _belie
谢谢谢 <[EMAIL PROTECTED]> wrote:
i need to select data from my sqlite database and i want the data
should be ordered by a special column;
my searches of the db should not be case_sensitive;
my sql statement is like:
sqlite> select * from customlist order by name;
i found the result is case_sensit
I have submitted it as ticket #2089 and named it "decoupling
sqlite_int64 from other 64 bit datatypes". I also made another few
changes and now make test reports even fewer errors than before
(attached in the ticket). The only cases it fails are when using big
files and when the integer values do
i need to select data from my sqlite database and i want the data should be
ordered by a special column;
my searches of the db should not be case_sensitive;
my sql statement is like:
sqlite> .head on
sqlite> select * from customlist order by name;
customId|name
X3F15C8HJ9|Bill Gates W2
DNVFWDR82J
I cannot be much help since we never use VB or other similar proprietary
software prisons. However I did see this set of notes from someone
who was using Sqlite from VB and created a modified sqlite.h.
http://www.persistentrealities.com/index.php?p=18
If you don't already have a lot of VB cod
"Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> Dixon Hutchinson
> wrote:
> > Sorry, meant to include a reference to 'p' in my select:
> > SELECT * FROM foo WHERE bar LIKE 'something' AND p='some_int';
>
> An expression involving LIKE cannot use an index anyway.
This is mostly true, but there are
Good evening all,
The image collector project is nearing release status. This project
allows art enthusiasts to more easily collect, organize, and view
images from the internet.
The project is a suite of programs that all cooperate.
* A firefox browser plugin identifies, downloads, and document
Hello John,
Wednesday, November 29, 2006, 1:08:56 AM, you wrote:
> Here are a couple of links to get you started. I suggest you google
> your way until you find something which suits you.
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
> http://www.freevbcode.com/ShowCode.asp?ID=6893
I
Dixon Hutchinson
wrote:
Sorry, meant to include a reference to 'p' in my select:
SELECT * FROM foo WHERE bar LIKE 'something' AND p='some_int';
An expression involving LIKE cannot use an index anyway. This query
would use the index to drill down to the rows having p=some_int, then
scan thos
http://www.sqlite.org/cvstrac/chngview?cn=3520
http://www.sqlite.org/cvstrac/chngview?cn=3513
http://www.sqlite.org/cvstrac/chngview?cn=3512
Changed fts2.c to store smaller terms in interior nodes, and to
delta-encode them. This improves function in the face of very large
terms (hundreds and tho
There us very little to learn, just equivalent names for types.
RB Smissaert wrote:
Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.
RBS
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: 28 November 200
Igor, Dennis, Richard
Sorry, meant to include a reference to 'p' in my select:
SELECT * FROM foo WHERE bar LIKE 'something' AND p='some_int';
But that raises the question of the order of the columns within
UNIQUE(). Should I put the most "unique" column first, or the thing
most easily compar
Dixon Hutchinson <[EMAIL PROTECTED]> wrote:
> I have an SQLite db with one TEXT column. That column and an INTEGER
> column (not the rowid as this column is definitely not unique by itself)
> are declared UNIQUE together.
>
> CREATE TABLE foo (
> bar TEXT,
> p INTEGER,
> rowid INTE
Dixon Hutchinson wrote:
I have an SQLite db with one TEXT column. That column and an INTEGER
column (not the rowid as this column is definitely not unique by
itself) are declared UNIQUE together.
CREATE TABLE foo (
bar TEXT,
p INTEGER,
rowid INTEGER PRIMARY KEY AUTOINCREMENT, -- I k
Dixon Hutchinson
wrote:
I have an SQLite db with one TEXT column. That column and an INTEGER
column (not the rowid as this column is definitely not unique by
itself) are declared UNIQUE together.
CREATE TABLE foo (
bar TEXT,
p INTEGER,
rowid INTEGER PRIMARY KEY AUTOINCREMENT, -- I kn
Check that the version of VB, or VB itself supports calling external
functions using 'cdecl' calling convention (instead of WINAPI
stdcall).
On 28/11/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB
I have an SQLite db with one TEXT column. That column and an INTEGER
column (not the rowid as this column is definitely not unique by itself)
are declared UNIQUE together.
CREATE TABLE foo (
bar TEXT,
p INTEGER,
rowid INTEGER PRIMARY KEY AUTOINCREMENT, -- I know... this is
implicit.
Marten Feldtmann <[EMAIL PROTECTED]> wrote:
> I've read the book from Michael Owens about SQLite and also
> read the parts about threads and sqlite3.
>
> Actually it seems to be possible to use the same connection
> handler from different threads - but within a transaction
> only one thread is all
Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.
RBS
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: 28 November 2006 21:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ SQLite
Maybe all you hav
On Tue, 28 Nov 2006, Craig Morrison wrote:
I believe you are correct. I must admit I'm a bit behind on indexes as
most of the sql operations that I do are simple lookups on small datasets.
Craig,
I'm confident that we're both correct on this.
What you have to make sure of though is that y
Maybe all you have to do is to make yourself a list og VB types cross
referenced to the fundamental type used in the Win32 and Sqlite APIs.
Then you could link any library into your VB programs.
RB Smissaert wrote:
You might be right, but with the Win32 API you have loads of nice
documents/pro
Rich Shepard wrote:
On Tue, 28 Nov 2006, Craig Morrison wrote:
Another method is to have a field declared UNIQUE and use the syntax:
INSERT OR REPLACE INTO table ...
The UNIQUE constraint will trigger the REPLACE constraint if it
already exists and the row will get updated instead of inserte
> In the amount of time that you've spent asking for an import
> library on this list you could have written all of the imports.
If you say so. Thanks in any case.
RBS
-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED]
Sent: 28 November 2006 21:39
To: sqlite-users@sqlite.or
I've read the book from Michael Owens about SQLite and also
read the parts about threads and sqlite3.
Actually it seems to be possible to use the same connection
handler from different threads - but within a transaction
only one thread is allowed to access the library with that
particular connect
On 11/28/06, Nicolas Williams <[EMAIL PROTECTED]> wrote:
On Tue, Nov 28, 2006 at 03:03:58PM -0600, Isaac Raway wrote:
> Use an index on the table with your key values and call "INSERT OR
> UPDATE INTO t(...) VALUES(...)" for all creation and update
> operations. Unless you're dealing with a treme
RB Smissaert said:
> You might be right, but with the Win32 API you have loads of nice
> documents/programs (I like the API guide from KPD) that help you out.
> All I have to do is copy their declares straight to VB and look at the
> data
> types I have to provide. Is the same available for the SQ
On Tue, 28 Nov 2006, Craig Morrison wrote:
Another method is to have a field declared UNIQUE and use the syntax:
INSERT OR REPLACE INTO table ...
The UNIQUE constraint will trigger the REPLACE constraint if it already
exists and the row will get updated instead of inserted.
Craig,
What I
On Tue, 28 Nov 2006, Isaac Raway wrote:
Use an index on the table with your key values and call "INSERT OR UPDATE
INTO t(...) VALUES(...)" for all creation and update operations. Unless
you're dealing with a tremendous amount of data per record this will be
perfectly efficient.
Isaac,
I tot
On Tue, Nov 28, 2006 at 03:03:58PM -0600, Isaac Raway wrote:
> Use an index on the table with your key values and call "INSERT OR
> UPDATE INTO t(...) VALUES(...)" for all creation and update
> operations. Unless you're dealing with a tremendous amount of data per
> record this will be perfectly ef
Rich Shepard wrote:
What is the most efficient approach to test whether a record has a value
in a field that's different from the one displayed? The only approach that
occurs to me is to retrieve each field from the table and compare values
with those in the form when the "Save" button is click
Use an index on the table with your key values and call "INSERT OR
UPDATE INTO t(...) VALUES(...)" for all creation and update
operations. Unless you're dealing with a tremendous amount of data per
record this will be perfectly efficient.
On 11/28/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
T
This is a generic approach question, not neccesarily tied to a specific
database and certainly not to a particular language. For context, however,
my application is written in python and C and uses sqlite3. Here's the
situation:
A database is created or opened, and the user enters data via fi
You might be right, but with the Win32 API you have loads of nice
documents/programs (I like the API guide from KPD) that help you out.
All I have to do is copy their declares straight to VB and look at the data
types I have to provide. Is the same available for the SQLite API?
RBS
-Original
Yes, it worked after I added 'begin' and 'end' at the beginning and at
the end of my transaction:
db.exec("begin;"+
"select * from t1; " +
"delete from t1 where t1key = 1; " +
"insert into t1(data,num) values('Spee
If you can use the Win32 API you can use the Sqlite API. Just because
they can be called from C programs does not make them "all to do with C".
RB Smissaert wrote:
Will have a look, but I was looking for a text geared towards VB. I take it
the documentation that comes with SQLite is all to do
Will have a look, but I was looking for a text geared towards VB. I take it
the documentation that comes with SQLite is all to do with C.
In fact I already have a wrapper that seems to work well, the one from
TerraInformatica, but maybe there was more control if I could write my own.
RBS
-Ori
That should not stop you from starting a transaction and committing it.
Note that Sqlite will automatically wrap your SQL in a transaction is
you don't specify one.
[EMAIL PROTECTED] wrote:
Thanks, but the problem is that I am using this SQLite Java Wrapper
library:
http://www.ch-werner.de
Karthick V - TLS , Chennai wrote:
Hi everyone,
I am trying to generate a time information with the time zone offset
information in the UTC format
-MM-DDTHH:MM:SS.mmm+HH:MM
Try this:
select strftime('%Y-%m-%dT%H:%M:%f', 'now', 'localtime') ||
case
when strftime
Thanks, but the problem is that I am using this SQLite Java Wrapper
library:
http://www.ch-werner.de/javasqlite/
and it looks like the only way I have to execute sql statements is to use
the following commands:
- Database.compile()
- Database.exec()
unfortunately no roll-back
Benedetta T
Extensions are used by such systems as MIME to indicate file type.
Fitting into those conventions is better than not doing so for some
capricious reason.
Name extensions are easier to handle than the traditional Unix "magic"
method.
Trevor Talbot wrote:
On 11/28/06, John Stanton <[EMAIL PRO
Issue ROLLBACK instead of COMMIT for your transaction. If you have
already issued COMMIT it is too late.
[EMAIL PROTECTED] wrote:
Hi,
how can I 'roll-back' some modifications done by some previous sql
statements with SQLite?
Thank you
Benedetta Turchi
Engineering Tools
Engineering Tools W
On 11/28/06, P Kishor <[EMAIL PROTECTED]> wrote:
On 11/28/06, Craig Morrison <[EMAIL PROTECTED]> wrote:
> Just a bit of warning, as it has bitten a few in the bum, about >3
> character extensions under the NT+ variants.. They can and will bite
> you, for instance:
>
> dir *.sql
>
> Will list n
Here are a couple of links to get you started. I suggest you google
your way until you find something which suits you.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
http://www.freevbcode.com/ShowCode.asp?ID=6893
made hendra wrote:
Thanks John,
Btw, i'm not a sqlite advance nor vb.
I'm n
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:
If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability. You can also make it
difficult to parse the extension when it is used to type the file.
The journal filename violates most
[EMAIL PROTECTED] wrote:
> Hi,
>
> how can I 'roll-back' some modifications done by some previous sql
> statements with SQLite?
>
The ROLLBACK command will undo everything from within a
transaction, assuming you have not already committed the
transaction. Once a transaction commits, there is n
On 11/28/06, sebcity <[EMAIL PROTECTED]> wrote:
Where do you execute the SQLite program from?
Is it just the sqlite.exe file?
You need to start from your OS command prompt; run "sqlite3
database.filename" from there. Do not double-click sqlite3.exe.
--
On 11/28/06, P Kishor <[EMAIL PROTECTED]> wrote:
Whether or not this is true, the fact is, in Windows (and even in Mac
OS X, while using the Finder), three letter extensions mean something
special. By making it '.sqlite' (or '.bobbitybob', for that matter), I
hope to make my db immune from all t
Hi everyone,
I am trying to generate a time information with the time zone offset
information in the UTC format
-MM-DDTHH:MM:SS.mmm+HH:MM
with the last HH and MM referring to the offset of the timezone hours and
minutes from the GMT. My table is created using the following queries
CREAT
Yes. It's a regular windows DLL, so it will behave like all other Windows
DLLs.
Clay Dowling
[EMAIL PROTECTED] said:
> Can I call the SQLite API (as in the dll SQLite.dll) directly from
> VB or do I need the wrapper? So, could it work from VB with declares
> as I use for the Windows API?
>
> RBS
After 30+ years, still waiting for management to learn one simple
rule...
Ah, but then they wouldn't need all of us "Consultants" :-)
Fred
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 28, 2006 9:30 AM
> To: sqlite-users@sqlite.org
> Subjec
Hi,
how can I 'roll-back' some modifications done by some previous sql
statements with SQLite?
Thank you
Benedetta Turchi
Engineering Tools
Engineering Tools Website
-
***
*** Symbian So
Can I call the SQLite API (as in the dll SQLite.dll) directly from
VB or do I need the wrapper? So, could it work from VB with declares
as I use for the Windows API?
RBS
> sebcity wrote:
>> How would one go about using c++ (Visual Studio.NET) to call and display
>> SQLite tables. C++ wrappers?
>
On 11/28/06, Craig Morrison <[EMAIL PROTECTED]> wrote:
P Kishor wrote:
> On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:
>> If you use an extension greater than 3 chars you violate rules for some
>> existing file systems and reduce portability. You can also make it
>> difficult to parse the
Sqlite is admirable in the way it uses broad standards and run on just
about anything which can switch electrons. It is tidy practise and
simply good business to maintain that most desirable condition.
P Kishor wrote:
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:
If you use an extens
Thanks John,
Btw, i'm not a sqlite advance nor vb.
I'm not fully understand about vb wrapper. I always using ODBC to
create database connection. Any suggest or clue? where i can find vb
wrapper for sqlite(3).
Tuesday, November 28, 2006, 11:11:04 PM, you wrote:
> I cannot help you with ODBC, but
Remember the first rule of IT. "If you don't have time do do it right,
you don't have time to do it twice".
sebcity wrote:
Time constraints
Craig Morrison-2 wrote:
sebcity wrote:
Thanks, Could you supply an example?
I'm not going to be as nice as everyone else, go here:
http://www.
sebcity wrote:
How would one go about using c++ (Visual Studio.NET) to call and display
SQLite tables. C++ wrappers?
You should be able to call the Sqlite3 API directly.
-
To unsubscribe, send email to [EMAIL PROTECTED]
P Kishor wrote:
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:
If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability. You can also make it
difficult to parse the extension when it is used to type the file.
we are going a bit
made hendra wrote:
Hello John,
Tuesday, November 28, 2006, 4:08:58 AM, you wrote:
sebcity wrote:
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the database? How would you save them?
Write them as a BLOB.
Are there Sqlite ODBC that suppor
On 11/27/06, LuYanJun <[EMAIL PROTECTED]> wrote:
Can anybody give a simple example for domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB
type?
You can insert /any/ kind of data into a SQLite database (or most any other
sort of DB for that matter). Here's
Sqlite is very widely used as an embedded SQL database. You probably
use it already without knowing it. (Do you use Firefox?).
Be warned that the price you pay for its simplicity is that it is not
suitable for enterprise DBMS applications, like running Ebay, but is
ideal for standalone applic
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:
If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability. You can also make it
difficult to parse the extension when it is used to type the file.
we are going a bit off-thread here,
A BLOB is just a block of indeterminate, untyped data. You reference it
by a pointer and a length and recover it the same way. Sqlite will
store it as a linked list of pages.
Think of it as a file, which is a pointer and a length, stored by the
file system as a group or a group of groups of
If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability. You can also make it
difficult to parse the extension when it is used to type the file.
In medecine the Hippocratic Oath requires "First, do no harm". Not a
bad principle for
sebcity said:
>
> Thanks, Could you supply an example?
>
http://www.linuxjournal.com/article/7803
Clay
--
Simple Content Management
http://www.ceamus.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sebcity <[EMAIL PROTECTED]> was heard to say:
>
> Time constraints
>
Good point. I've got time constraints too. Could everyone else please start to
solve all my problems right now too please?
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "m
"Zhang Cheng-E7104C" <[EMAIL PROTECTED]> wrote:
> Hi,Richard
> The cases happens in PC. The disk remained is not much, sorts of several =
> hundreds of Mb .
>
> Then the following step is what I do.
>
> 1) Create a 1M bytes size file.
> 2) create a table and begin to insert data in the table unt
Time constraints
Craig Morrison-2 wrote:
>
> sebcity wrote:
>> Thanks, Could you supply an example?
>
> I'm not going to be as nice as everyone else, go here:
>
> http://www.sqlite.org/cvstrac/wiki
>
> Do some research and then come back instead of asking for handouts.
>
> We've all bee
u have to search sqlite++.
:)
--
Linker M Lin
[EMAIL PROTECTED]
※
※※我思故我在※※
※
- 原始邮件
发件人: sebcity <[EMAIL PROTECTED]>
收件人: sqlite-users@sqlite.org
已发送: 2006/11/28(周二), 下午7:52:07
主题: Re: [sqlite] C++ SQLite
Thanks, Could you supply an example?
Clay Dowling wrote:
>
sebcity wrote:
Thanks, Could you supply an example?
I'm not going to be as nice as everyone else, go here:
http://www.sqlite.org/cvstrac/wiki
Do some research and then come back instead of asking for handouts.
We've all been where you are now, the difference is that we tried on our
own and
Thanks, Could you supply an example?
Clay Dowling wrote:
>
> sebcity wrote:
>> How would one go about using c++ (Visual Studio.NET) to call and display
>> SQLite tables. C++ wrappers?
>
> You could just use the API directly. Myself, I've put a wrapper around
> it, but there's nothing saying t
sebcity wrote:
> How would one go about using c++ (Visual Studio.NET) to call and display
> SQLite tables. C++ wrappers?
You could just use the API directly. Myself, I've put a wrapper around
it, but there's nothing saying that you have to.
Clay
--
CeaMuS
http://www.ceamus.com
Simple Content Ma
How would one go about using c++ (Visual Studio.NET) to call and display
SQLite tables. C++ wrappers?
--
View this message in context:
http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577607
Sent from the SQLite mailing list archive at Nabble.com.
-
Where do you execute the SQLite program from?
Is it just the sqlite.exe file?
John Stanton wrote:
>
> Use anything you like. Version 3 Sqlite is easy to recognize if you use
> .db3.
>
> RB Smissaert wrote:
>>>sqlite3 mydatabase.db3
>>
>>
>> I always use the extension .db
>> What is the d
Where do you execute the SQLite program from?
Is it just the sqlite.exe file?
P Kishor-2 wrote:
>
> I like using .sqlite as the extension (or .sqlite3). That way no
> Windows program will want to mess with it... usually 3 letter
> extensions are grist for the mill
>
> On 11/27/06, John Stant
Where do you execute the SQLite program from?
Is it just the sqlite.exe file?
Kees Nuyt wrote:
>
> On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote:
>
>>
>>I typed exactly what you typed there and i get
>>SQL error: no such table: bar
>>my command window doesnt have : "sqlite3 foo.sqlite"
Hi,
If you want to make an embedded database application with VB6 and
SQLite3, Please visit to http://osenxpsuite.net
And you can using Free Query Analyzer for SQLite3 database from the
following link below:
http://osenxpsuite.net/en/downloads.php?id=sqlite2006pro.exe&uid=mail_sqlite_users
OK
ma
80 matches
Mail list logo