Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

-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)

Re: [sqlite] Newbie question on Data Source

ent: 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: >>> Ju

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: 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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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. > >

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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.

Re: [sqlite] Newbie question on Data Source

...@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

[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 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:

Re: [sqlite] Newbie question, how multiple joins are executed

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

Re: [sqlite] Newbie question, how multiple joins are executed

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

Re: [sqlite] Newbie question, how multiple joins are executed

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

Re: [sqlite] Newbie question, how multiple joins are executed

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){ >

[sqlite] Newbie question, how multiple joins are executed

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.

Re: [sqlite] Newbie question

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

[sqlite] Newbie question

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

Re: [sqlite] Newbie Question

t; Sent: Sat, April 16, 2011 1:24:09 PM Subject: Re: [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

Re: [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 shed on this. SQLite is a database tool, and allows

[sqlite] Newbie Question

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

Re: [sqlite] Newbie question

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

Re: [sqlite] Newbie question

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))

Re: [sqlite] Newbie question

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, SaleVolume) is it possible in one query to obtain the following three column result set: SalesCurrentYear, Sale

[sqlite] Newbie question

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

Re: [sqlite] Newbie question - SQLite the best choice?

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

Re: [sqlite] Newbie question - SQLite the best choice?

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

Re: [sqlite] Newbie question - SQLite the best choice?

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

[sqlite] Newbie question - SQLite the best choice?

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

Re: [sqlite] Newbie Question about ASCII and UTF-16 strings

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

Re: [sqlite] Newbie question about using SQLite with Windows Forms application (VS 2005 C++)

Vinnie pisze: >> From: wiktor <siri...@o2.pl> >> 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 wou

Re: [sqlite] Newbie question about using SQLite with Windows Forms application (VS 2005 C++)

> From: wiktor <siri...@o2.pl> > 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 sqli

[sqlite] Newbie question about using SQLite with Window s Forms application (VS 2005 C++)

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

[sqlite] Newbie question about creating tables

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

Re: [sqlite] Newbie question

] 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 <jhoo...@jcvi.org>: > > Assumming  this is only one row in tbl2 where name='Joe'... > > this should work: &g

Re: [sqlite] Newbie question

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

Re: [sqlite] Newbie question

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

Re: [sqlite] Newbie question

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 >

Re: [sqlite] Newbie question

com> To: sqlite-users@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=&q

Re: [sqlite] Newbie question

ot;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: [sqlite] Ne

Re: [sqlite] Newbie question

] 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 <itandet...@mvps.org>: > Dermot <paik...@googlemail.com> wrote: >> I want to do a select query a bit like this

Re: [sqlite] Newbie question

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 <itandet...@mvps.org>: > Dermot <paik...@googlemail.com> wrote: >> I want to do a select query a bit like this: >> &g

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="someval" AND >> foreign_key_id=(select id from tbl2 where name="Joe"); >> >> This gives me a syntax error and my

Re: [sqlite] Newbie question

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

[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 foreign_key_id=(select id from tbl2 where name="Joe"); This gives me a syntax error and my other

Re: [sqlite] newbie question regarding my sqlite code

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.

Re: [sqlite] newbie question regarding my sqlite code

-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

[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 very simple code: select sum(età) from dipendenti everything works fine and

Re: [sqlite] newbie question

-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

[sqlite] newbie question

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

Re: [sqlite] newbie question about laying out a simple database for bookings

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

Re: [sqlite] newbie question about laying out a simple database for bookings

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

Re: [sqlite] newbie question about laying out a simple database for bookings

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)] -

Re: [sqlite] newbie question about laying out a simple database for bookings

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

Re: [sqlite] newbie question about laying out a simple database for bookings

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

Re: [sqlite] newbie question about laying out a simple database for bookings

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

Re: [sqlite] Newbie question re using SQLite in basic client/server situation

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

Re: [sqlite] Newbie question re using SQLite in basic client/serversituation

n, 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 > Subject: [sqlite] Ne

Re: [sqlite] Newbie question re using SQLite in basic client/server situation

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

Re: [sqlite] Newbie question re using SQLite in basic client/serversituation

- 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 use for my XCode/Cocoa

Re: [sqlite] Newbie question re using SQLite in basic client/server situation

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

[sqlite] Newbie question re using SQLite in basic client/server situation

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

[sqlite] Newbie question "INSERT INTO" on joined tables

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,

Re: [sqlite] Newbie question about LIKE and ESCAPE

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

[sqlite] Newbie question about LIKE and ESCAPE

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

Re: [sqlite] Newbie Question

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

[sqlite] Newbie Question

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.

[sqlite] Newbie Question - Multiple Users, Multiple files

Hi Guys,

Re: [sqlite] Newbie Question

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

Re: [sqlite] Newbie Question

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

Re: [sqlite] Newbie Question

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

Re: [sqlite] Newbie Question

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

Re: [sqlite] Newbie Question

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

[sqlite] newbie question re indexes

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

[sqlite] Newbie question: sqlite.exe command usage?

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

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

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

RE: [sqlite] Newbie --question about multiple PCs accessing sqlite

> -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

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

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

[sqlite] Newbie --question about multiple PCs accessing sqlite

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) -

[sqlite] Newbie --question about multiple PCs accessing sqlite

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

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

> 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