Michael,
#1 Thanks for the comments. I have the book, The Definitive Guide to
SQLite from Apress by Michael Owens, but it is the 2006 first edition.
Do you, or anyone, know if the new or 2nd edition is worth buying or
does it just cover 1 new item? I am not afraid to buy books. You should
se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/29/2011 12:17 PM, Black, Michael (IS) wrote:
> I'll note a few things here...
[snip]
Much good advice. Seconded!
ABS
- --
Alaric Snell-Pym
http://www.snell-pym.org.uk/alaric/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Co
e...@cox.net]
Sent: Monday, November 28, 2011 5:24 PM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Newbie question on Data Source
On 11/28/2011 4:59 PM, Simon Slavin wrote:
> On 28 Nov 2011, at 10:44pm, Dave wrote:
>
>> On 11/28/2011 4:37 PM, Simon Slavin wrote:
On 11/28/2011 4:59 PM, Simon Slavin wrote:
On 28 Nov 2011, at 10:44pm, Dave wrote:
On 11/28/2011 4:37 PM, Simon Slavin wrote:
Just to stress that the filename includes the bit after the '.'. You can have
any number of files with the same part before the '.' but different extensions.
To t
On 28 Nov 2011, at 10:44pm, Dave wrote:
> On 11/28/2011 4:37 PM, Simon Slavin wrote:
>> Just to stress that the filename includes the bit after the '.'. You can
>> have any number of files with the same part before the '.' but different
>> extensions. To tell the operating system which one you
Thanks Simon,
Actually, I knew that. Just having a bit of a multiple crash
course...all at once. I just recently built this pc and have been on XP
until recently too. I do some graphic stuff and have many same named
pics with the various .jpg, .bmp, .gif extensions.
Dave
On 11/28/2011 4:37
Thanks Igor,
I am just getting started so I am bound to get tripped up a little.
:-) That was going to be my next question anyhow, about the database
name. I was thinking we *had* to have the extension .db3 but you have
answered that. I just have been using VB.Net less than 30 days and that
On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote:
> On 11/28/2011 5:23 PM, Dave wrote:
>> Ok, I switched that and now my original database file has a .db added
>> whereas the one created by my app stays the same.
>
> It doesn't have .db added. It had it all along, you just couldn't see it.
>
>
On 11/28/2011 5:23 PM, Dave wrote:
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
It doesn't have .db added. It had it all along, you just couldn't see it.
Anyway, now you can name your file however you want. Make sure th
Thanks John.
On 11/28/2011 4:18 PM, John Drescher wrote:
You probably have "Hide extensions for known types enabled in windows"
When this is enabled windows does not display the extension for known
types so that if you have more than 1 file with the same base name they
will appear as the same
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
Thanks,
Dave
On 11/28/2011 4:14 PM, Igor Tandetnik wrote:
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3 to
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3 to it and it remains in the same folder as the other file with
one exception. The properties for my database shows:
type: Data Base File
Where the one generated at 0K with the same n
Yes, that is what I am trying to connect to. The problem is that it
apparently doesn't connect to it as it cannot see the tables in it. So
it creates another database file that has 0K in size. My database file
has the correct icon next to it's name with a little key in the pic
where the one tha
On Mon, Nov 28, 2011 at 5:13 PM, Dave wrote:
>
>
> On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
>>
>> On 11/28/2011 4:52 PM, Dave wrote:
>>>
>>> I am trying to learn VB.Net and SQLite at the same time. I have used VB6
>>> Classic in the past. I have VB Studio 2010 Pro and am just trying to
>>> ope
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
probl
On 11/28/2011 5:08 PM, Dave wrote:
I just checked and the 0K file that is created is the same name except
it has .db3 added to it's name.
Why is this suprising? Your connection string requests a file named
MyDatabase.db3. Is this not the file you want to connect to?
--
Igor Tandetnik
___
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
probl
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying. I
...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave
Sent: Monday, November 28, 2011 4:53 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Newbie question on Data Source
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying. I keep getting the
error message:
On 20/06/2011 6:59 AM, Richard Hipp wrote:
> On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson wrote:
>> IIRC sqlite does *not* do any join ordering optimizations and simply
>> runs them in whatever order the query specifies. This can have
>> unfortunate effects on runtime for some queries. Can anyone
On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson wrote:
> IIRC sqlite does *not* do any join ordering optimizations and simply
> runs them in whatever order the query specifies. This can have
> unfortunate effects on runtime for some queries. Can anyone verify this?
>
>
The SQLite query optimizer st
On 19/06/2011 8:03 PM, Simon Slavin wrote:
> On 20 Jun 2011, at 12:58am, Lucas Cotta wrote:
>
>> I understand that for a query with a two tables join, SQLite will do a
>> nested loop join with these two tables.
>> But what about a query joining 5 tables?
>> It would be like this?:
>>
>> for(table1
On 20 Jun 2011, at 12:58am, Lucas Cotta wrote:
> I understand that for a query with a two tables join, SQLite will do a
> nested loop join with these two tables.
> But what about a query joining 5 tables?
> It would be like this?:
>
> for(table1 lines){
> for(table2 lines){
> for(t
Hi!
I understand that for a query with a two tables join, SQLite will do a
nested loop join with these two tables.
But what about a query joining 5 tables?
It would be like this?:
for(table1 lines){
for(table2 lines){
for(table3 lines){
Thanks.
Lucas Cotta wrote:
> Are primary keys and foreign keys indexes by default? Or do we have to set
> them as indexes?
An index is automatically created to implement PRIMARY KEY and UNIQUE
constraints.
No indexes are automatically created for foreign key constraints. Columns
mentioned in REFERENCE
Hi!
Are primary keys and foreign keys indexes by default? Or do we have to set
them as indexes?
Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e: [sqlite] Newbie Question
On 16 Apr 2011, at 6:18pm, Db Dvlpr wrote:
> My goal is to eventually become a contractor and work from home. It seems as
> if
>
> SQLite will optimally facilitate my goal—am I corect?? I will greatly
> appreciate any light that anyone can sh
On 16 Apr 2011, at 6:18pm, Db Dvlpr wrote:
> My goal is to eventually become a contractor and work from home. It seems as
> if
> SQLite will optimally facilitate my goal—am I corect?? I will greatly
> appreciate any light that anyone can shed on this.
SQLite is a database tool, and allows a
My goal is to eventually become a contractor and work from home. It seems as if
SQLite will optimally facilitate my goal—am I corect?? I will greatly
appreciate any light that anyone can shed on this.
___
sqlite-users mailing list
sqlite-users@sqlite.
Thanks, Igor & Michael - your help is much appreciated.
Cheers
Kai
On Mon, Mar 21, 2011 at 4:47 AM, Igor Tandetnik wrote:
> Kai Peters wrote:
>> given a table with two columns (SaleDate, SaleVolume) is it possible in one
>> query to obtain
>> the following three column result set:
>>
>> SalesC
Kai Peters wrote:
> given a table with two columns (SaleDate, SaleVolume) is it possible in one
> query to obtain
> the following three column result set:
>
> SalesCurrentYear, SalesLastYEar, SalesAllyears
select
sum(SaleVolume * (SaleDate >= StartOfCurYear)) SalesCurrentYear,
sum(SaleV
___
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Kai Peters [kpet...@otaksoft.com]
Sent: Sunday, March 20, 2011 11:10 PM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] Newbie question
Hi all,
given a table with two columns (SaleDate, Sal
Hi all,
given a table with two columns (SaleDate, SaleVolume) is it possible in one
query to obtain
the following three column result set:
SalesCurrentYear, SalesLastYEar, SalesAllyears
?
Thanks as always for any help,
Kai
___
sqlite-users mailing
Hello!
I think your structure is not good enough. You may use
cookie-based database selection instead and doesn't
store user information into your "Master DB".
The algorithm is like to:
Username -> user_id -> check password by user_id database
As example:
User enter USERNAME and PASSWORD and we
On Sat, 6 Mar 2010, Richard Cooke wrote:
> Our application could have up to 10,000 users via a public facing web
> site. As a first stab at the schema, I thought I'd have one "Master User"
> database which will probably look like this:
Richard,
If I recall correctly, SQLite does not do well
Richard Cooke wrote:
> Can I use the user_id (as a FOREIGN KEY) that resides in another
> database to link the two DBs together? I'm a newbie to all of theis
> database design so I am using this project as a learning experience.
> From my limited knowledge of MySQL I think I could have everyt
Hi Folks,
Please forgive me if this isn't the proper forum to post this question
but I am in need of some expert advice concerning if SQLite is the best
choice for my application.
Our application could have up to 10,000 users via a public facing web
site. As a first stab at the schema, I thou
On Sun, May 10, 2009 at 4:46 AM, John Machin wrote:
> On 10/05/2009 3:29 PM, kalyan@aol.in wrote:
>> Hi,
>>
>> I am a newbie to sqlite.
>> I want to create a sqlite database in Linux OS.
>>
>> The data that I wish to put in the table contains both ASCII and UTF-16
>> encoded strings.
>> For e
On 10/05/2009 3:29 PM, kalyan@aol.in wrote:
> Hi,
>
> I am a newbie to sqlite.
> I want to create a sqlite database in Linux OS.
>
> The data that I wish to put in the table contains both ASCII and UTF-16
> encoded strings.
> For eg. File and directory names are UTF-16 where the URL, date ti
Hi,
I am a newbie to sqlite.
I want to create a sqlite database in Linux OS.
The data that I wish to put in the table contains both ASCII and UTF-16 encoded
strings.
For eg. File and directory names are UTF-16 where the URL, date time
information about the files are in ASCII.
How do I create a
Vinnie pisze:
>> From: wiktor
>> Subject: [sqlite] Newbie question about using SQLite with
>> Windows Forms application (VS 2005 C++)
>> I'm trying to build a win form application that uses
>> sqlite. I have problems with making it work. I would like
>>
> From: wiktor
> Subject: [sqlite] Newbie question about using SQLite with
> Windows Forms application (VS 2005 C++)
> I'm trying to build a win form application that uses
> sqlite. I have problems with making it work. I would like
> to have the sqlite source included in
Hi,
I'm trying to build a win form application that uses sqlite. I have problems
with making it work. I would like to have the sqlite source included in my
project (as .h file or dll) - sth similar to (but done by a function)
http://www.sqlite.org/quickstart.html. As I have read on internet s
My background is with SQL Server and Delphi, so the concepts in SQLite
are new for me. I have a TDISQLite3Database component in my TDataModule
with the DatabaseName set to Demo. Since I am familiar with the
TDataset and other Delphi components, I would like to use those (at the
expense of siz
sqlite.org]
On Behalf Of Dermot
Sent: Wednesday, March 18, 2009 12:05 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Newbie question
2009/3/18 Hoover, Jeffrey :
>
> Assumming this is only one row in tbl2 where name='Joe'...
>
> this should work:
> SEL
On Wed, 18 Mar 2009 16:04:51 +, Dermot
wrote:
>2009/3/18 Hoover, Jeffrey :
>>
>> Assumming this is only one row in tbl2 where name='Joe'...
>>
>> this should work:
>> SELECT * FROM tbl1
>> WHERE description='someval'
>> AND foreign_key_id=(select id from tbl2 where name='Joe');
subselect
(I
according to this
http://www.sqlite.org/lang_keywords.html
both the single and double quotes should have worked. (the single quotes are
preferred)
On Wed, Mar 18, 2009 at 9:04 AM, Dermot wrote:
> 2009/3/18 Hoover, Jeffrey :
> >
> > Assumming this is only one row in tbl2 where name='Joe'...
>
2009/3/18 Hoover, Jeffrey :
>
> Assumming this is only one row in tbl2 where name='Joe'...
>
> this should work:
> SELECT * FROM tbl1
> WHERE description='someval'
> AND foreign_key_id=(select id from tbl2 where name='Joe');
>
> this is better:
> select tbl1.* from tbl1, tbl2
> where tbl1.descript
sers@sqlite.org
Sent: Wednesday, March 18, 2009 8:35:52 AM
Subject: [sqlite] Newbie question
Hi,
I am very green with SQL entirely so I apologise in advance for what
might be a simple query.
I want to do a select query a bit like this:
SELECT * FROM tbl1 WHERE description="someval" AND
select "grant#" from "Current_Projects";
-Jeff
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Hardy, Andrew
Sent: Wednesday, March 18, 2009 11:50 AM
To: General Discussion of SQLite Database
Subject: Re: [
rom: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dermot
Sent: Wednesday, March 18, 2009 11:47 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Newbie question
2009/3/18 Igor Tandetnik :
> Dermot wrote:
>> I want to do
org]
On Behalf Of Dermot
Sent: 18 March 2009 15:47
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Newbie question
2009/3/18 Igor Tandetnik :
> Dermot wrote:
>> I want to do a select query a bit like this:
>>
>> SELECT * FROM tbl1 WHERE description="someva
2009/3/18 Igor Tandetnik :
> Dermot wrote:
>> I want to do a select query a bit like this:
>>
>> SELECT * FROM tbl1 WHERE description="someval" AND
>> foreign_key_id=(select id from tbl2 where name="Joe");
>>
>> This gives me a syntax error and my other efforts are not yielding
>> results.
>
> Wha
Dermot wrote:
> I want to do a select query a bit like this:
>
> SELECT * FROM tbl1 WHERE description="someval" AND
> foreign_key_id=(select id from tbl2 where name="Joe");
>
> This gives me a syntax error and my other efforts are not yielding
> results.
What's the text of the error message?
Igo
Hi,
I am very green with SQL entirely so I apologise in advance for what
might be a simple query.
I want to do a select query a bit like this:
SELECT * FROM tbl1 WHERE description="someval" AND
foreign_key_id=(select id from tbl2 where name="Joe");
This gives me a syntax error and my other effo
Am Samstag, 10. Januar 2009 schrieb silvio grosso:
> The query is:
> select avg(age), avg(durata), sum(età) from acoda, main, dipendenti
This is "cross join" over all three tables. The result is a "monster table",
consisting of every possible combination of the records of those three
tables. An
-users@sqlite.org
Subject: [sqlite] newbie question regarding my sqlite code
Hello,
I am a new sqilte user and I am learning sqlite code in my spare time..
I have always used sql code with Microsoft Access and Base (openoffice).
Therefore, sorry to ask a question very simple .
When I write the
Hello,
I am a new sqilte user and I am learning sqlite code in my spare time..
I have always used sql code with Microsoft Access and Base (openoffice).
Therefore, sorry to ask a question very simple .
When I write the very simple code:
select sum(età) from dipendenti
everything works fine and th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Listman wrote:
> anyone see a problem with us piggy backing on the svn sqlite
> client install?
You should be asking the Subversion folks. I'd assume they would want
you to ensure your tables have their own namespace prefix. You will
also want to f
hi, the SCM tool Subversion is going to start using sqlite in the
upcoming 1.6 release to manage client metadata. would it be possible
for us to also that sqlite install as part of some custom code we
write around subversion? we'd like to be able to cache the list of
managed object in the
sqlfan wrote:
>
> Thank you so so so so so so so much So much. Even when I have your
> code in front of me, it's still very very hard for me to understand it.
> This is hard stuff! So much harder than a spreadsheet, but hopefully it
> will work out in the end, because I'm programming in
Dennis Cote wrote:
>
> sqlfan wrote:
>> I'm booking five resources, and right now I just use an excel sheet with
>> all
>> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
>> columns are the five resources. When I book one, I just scroll to the
>> appropriate date and ch
On 4/7/08, sqlfan <[EMAIL PROTECTED]> wrote:
>
> I guess I fit in the more ambitious category then. I hope my workload will
> increase at any rate.
>
> Anyway I've looked at some tutorials, but I'm a bit daunted.
>
> What do you think about this layout:
>
> [integer booking # (=unique ID)] -
I guess I fit in the more ambitious category then. I hope my workload will
increase at any rate.
Anyway I've looked at some tutorials, but I'm a bit daunted.
What do you think about this layout:
[integer booking # (=unique ID)] - [integer start date] - [integer end date]
- [text everything el
sqlfan wrote:
> I'm booking five resources, and right now I just use an excel sheet with all
> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
> columns are the five resources. When I book one, I just scroll to the
> appropriate date and change the color of the column for
On 4/7/08, sqlfan <[EMAIL PROTECTED]> wrote:
>
> I'm booking five resources, and right now I just use an excel sheet with all
> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
> columns are the five resources. When I book one, I just scroll to the
> appropriate date an
I'm booking five resources, and right now I just use an excel sheet with all
the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
columns are the five resources. When I book one, I just scroll to the
appropriate date and change the color of the column for that resource for
all
On Fri, 7 Mar 2008 21:06:21 +1100 (EST), Jeff Brown
<[EMAIL PROTECTED]> wrote:
>"so, the file locking logic of many network
>filesystems implementation contains bugs (on both Unix
>and windows). If file locking does not work like it
>should, it might be possible for two or more client
>programs to
r situation, youd have to use ODBC or
> ADO, else you'd have to write it yourself.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Brown
> Sent: Friday, March 07, 2008 4:06 AM
> To: sqlite-users@sqlite.org
> Subje
On 3/7/08, Jeff Brown <[EMAIL PROTECTED]> wrote:
> Hi all
>
> I'm looking at switching the database that I use for
> my XCode/Cocoa application from MySQL to SQLite. (I'm
> getting tired of all the incompatibilities with new
> versions of MySQL).
With a Cocoa application, all you have to do is
riginal Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Brown
Sent: Friday, March 07, 2008 4:06 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Newbie question re using SQLite in basic
client/serversituation
Hi all
I'm looking at switching the database that I us
En/na Jeff Brown ha escrit:
> But I need to be able to use it as a server with at
> most 10 clients that occasionally use the system.
Hi, I'm a newbie myself, so I didn't use the following, but did you check
http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork
?
Bye
--
Luca Olivetti
Wetron Aut
Hi all
I'm looking at switching the database that I use for
my XCode/Cocoa application from MySQL to SQLite. (I'm
getting tired of all the incompatibilities with new
versions of MySQL).
But I need to be able to use it as a server with at
most 10 clients that occasionally use the system. I
notice
Asume we have three tables:
CREATE TABLE ARTIST (Artistname TEXT UNIQUE)
CREATE TABLE SONG (SongTitle TEXT UNIQUE)
CREATE CHART(Artist INTEGER, Song INTEGER)
CHART.Artist should hold ARTIST.ROWID
CHART.Song should hold SONG.ROWID
Is it possible to do something like "INSERT INTO CHART(Artist, So
On 3/3/07, A.J.Millan <[EMAIL PROTECTED]> wrote:
Hi all:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
This is standard SQL syntax, and works just fine in SQLite. It will
match all rows where someField contains the string 'xyzetc'
You can also anchor
Hi all:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
After some search in this list, I'm a bit more confused that before. For
example after reading literally:
>The escape mechanism for LIKE has never been implemented in
>SQLite. The work-around is to
Roger Miskowicz wrote:
I am having a problem updating a table in one of two attached
databases. What I want to do is indicate in one table whether a name is
listed in a table in the other attached database. I am sure it is
simple but I can't get the UPDATE criteria to work properly.
Any hel
I am having a problem updating a table in one of two attached
databases. What I want to do is indicate in one table whether a name is
listed in a table in the other attached database. I am sure it is
simple but I can't get the UPDATE criteria to work properly.
Any help would be appreciated.
Hi Guys,
John,
The configure script is looking for the location of a file named
tclConfig.sh. On Fedora Core 4, that file is provided when you install
the tcl-devel package.
Here is the ../configure incantation (taken from ../configure --help):
--with-tcl=DIR directory containing tcl configu
Bob,
I was able to compile on Linux after removing tclsqlite.c from the
build. It appears as though that was causing my errors. Once I removed
that, by changing
HAVE_TCL = 1
to
HAVE_TCL =
It compiled without errors. I found this in another thread which
indicated, to me at least, that it
Post the error messages and someone will help you. I'll also check for
messages after work tonight. There are others on this forum who are far
more knowledgable than I.
Bob
JohnD wrote:
Bob,
Thanks for the information. Are the required dependencies for Sqlite
listed anywhere? I'm unable
Bob,
Thanks for the information. Are the required dependencies for Sqlite
listed anywhere? I'm unable to compile on Linux and it appears as
though I'm missing a dependency or two. Any idea where I can check those?
Thanks,
John
Robert L Cochran wrote:
I think sqlite3.h is generated for yo
Compiling the CVS checkout is really the same -- just cd into the
'sqlite' directory and follow the instructions below from the 'mkdir'
onwards.
Bob
Robert L Cochran wrote:
I think sqlite3.h is generated for you automatically as part of the
build process from source code and it will be late
I think sqlite3.h is generated for you automatically as part of the
build process from source code and it will be later installed for you in
the include directory. You must actually compile sqlite from the source
code.
For Linux, why not just download sqlite-3.2.7.tar.gz (the linux source
cod
Hello,
I'm new to Sqlite and am trying to create a simple C/C++ program. I've
downloaded both the binary and the CVS source but can't seem to locate
the sqlite3.h header file.
Is there any document that details what I need to do in order to set up
an environment to be able to write and comp
> are indexes used when doing range searches on integer columns?
Yes, your simple example will use the index, but it has
nothing to do with the data being integers. You can read
all about indices at
http://www.sqlite.org/php2004/page-041.html
and following pages.
You can see whether a query
On Tue, 2005-05-10 at 18:28 -0700, Andy Turk wrote:
> I'm very new to sqlite and have a question about indexing: are indexes
> used when doing range searches on integer columns?
>
Yes.
--
D. Richard Hipp <[EMAIL PROTECTED]>
I'm very new to sqlite and have a question about indexing: are indexes
used when doing range searches on integer columns?
Suppose I have a table and index like the following:
CREATE TABLE example (value INT);
CREATE INDEX example_value_idx ON example (value);
If I issue the following query, is s
Josh Don said:
> I have read http://www.sqlite.org/sqlite.html
>
> I want to get something like this working:
>
> [C:\test.js]
> WS=new ActiveXObject('WScript.Shell')
> WS.Run('C:\\sqlite.exe "C:\\test.db" .read "C:\\query.txt" .output
> "C:\\OUT.txt" ')
>
> [C:\query.txt] contains...
> select * fr
hello :)
how can i store an image as a blob in sqlite about the java wrapper
classes?
thX
yesso
I have read http://www.sqlite.org/sqlite.html
I want to get something like this working:
[C:\test.js]
WS=new ActiveXObject('WScript.Shell')
WS.Run('C:\\sqlite.exe "C:\\test.db" .read "C:\\query.txt" .output
"C:\\OUT.txt" ')
[C:\query.txt] contains...
select * from sqlite_master;
What's up
I have read http://www.sqlite.org/sqlite.html
I want this to work:
[C:\test.js]
WS=new ActiveXObject('WScript.Shell')
WS.Run('C:\\sqlite.exe "C:\\test.db" .read "C:\\query.txt" .output
"C:\\OUT.txt" ')
[C:\query.txt] contains...
select * from sqlite_master;
What's up?
I have searched fo
Fred Williams wrote:
-Original Message-
From: Michael Roth [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 9:10 AM
To: Ulrik Petersen
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Newbie --question about multiple PCs accessing
sqlite
Ulrik Petersen wrote:
- Mingw or Cygwin (google
> -Original Message-
> From: Michael Roth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 20, 2004 9:10 AM
> To: Ulrik Petersen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Newbie --question about multiple PCs accessing
> sqlite
>
>
> Ulrik Petersen
Ulrik Petersen wrote:
- Mingw or Cygwin (google for each)
www.mingw.org, www.cygwin.com
- Microsoft Visual C++ Toolkit 2003. Microsoft recently released their
compiler and toolchain for free download:
http://msdn.microsoft.com/visualc/vctoolkit2003/
Check the license! It is not really fair! Don't
Hello Shamil,
[EMAIL PROTECTED] wrote:
I do not have a C++ compiler
If you are using Linux or some other Unix-like environment, you can get
g++ (i.e., gcc) for free.
If you are using Windows, there are several options for getting one
(also for free):
- Mingw or Cygwin (google for each)
- Mic
I'm contemplating using the TCL binding of sqlite, but the database is to
(Bbe located in a shared folder and about 100 users will be accessing it for
(Bread/write purposes. I would like to take some time to learn as much as
(Bpossible to safeguard the database from getting corrupt due to sever
> I'm contemplating using the TCL binding of sqlite, but the database is to
(B> be located in a shared folder and about 100 users will be accessing it for
(B> read/write purposes. I would like to take some time to learn as much as
(B> possible to safeguard the database from getting corrupt due
100 matches
Mail list logo
