Re: [sqlite] SQLite Tutorial: Request For Comments

2005-02-21 Thread Robert L Cochran 
[EMAIL PROTECTED] wrote:
The html has been cleaned up on the tutorial:
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download
 

Has this been updated recently for the 3.1.x series?
Thanks
Bob Cochran

[sqlite] SQLite Tutorial: Request For Comments

2004-12-01 Thread sporkey 
The html has been cleaned up on the tutorial:
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download

Regards,

Mike Chirico

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-25 Thread jacob navia 
[EMAIL PROTECTED] wrote:

>On Wed, Nov 24, 2004 at 04:41:37PM +0100, jacob navia wrote:
>  
>
>>Clay Dowling wrote:
>>
>>
>>
>>>Re:  SQLite Tutorial
>>>
>>>
>>>  
>>>
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download
  



>>Hi!
>>I have compiled the documentation of sqlite (3) in a CHM format, the 
>>standard help file
>>format for windows. Would it be possible to add the tutorial to it?
>>
>>
>
>I have not used that tool, so I would not know how to add it. Are you
>asking if you have the legal right to add it? Yes, this falls under the Open 
>Publication License.
>
>Regards,
>
>Mike Chirico
>  
>

Yes, OK I downloaded the license, and added it together with your
tutorial to the
documentation of sqlite.

Thanks for making your work available for others.

jacob

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-25 Thread sporkey 
On Wed, Nov 24, 2004 at 04:41:37PM +0100, jacob navia wrote:
> Clay Dowling wrote:
> 
> >Re:  SQLite Tutorial
> > 
> >
> >>http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download
> >>   
> >>
> Hi!
> I have compiled the documentation of sqlite (3) in a CHM format, the 
> standard help file
> format for windows. Would it be possible to add the tutorial to it?

I have not used that tool, so I would not know how to add it. Are you
asking if you have the legal right to add it? Yes, this falls under the Open 
Publication License.

Regards,

Mike Chirico




> 
> Thanks in advance.
> 
> jacob
> 
> P.S.
> The chm file is distributed with the lcc-win32 compiler system, that can be
> downloaded at no charge from:
> 
> http://www.cs.virginia.edu/~lcc-win32.
>

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-24 Thread jacob navia 
Clay Dowling wrote:
Re:  SQLite Tutorial
 

http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download
   

Hi!
I have compiled the documentation of sqlite (3) in a CHM format, the 
standard help file
format for windows. Would it be possible to add the tutorial to it?

Thanks in advance.
jacob
P.S.
The chm file is distributed with the lcc-win32 compiler system, that can be
downloaded at no charge from:
http://www.cs.virginia.edu/~lcc-win32.

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-24 Thread Clay Dowling 

Re:  SQLite Tutorial
> http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download

For anybody who hasn't read this yet, I highly recommend that you do.  The
information about Triggers was fantastic.  Until reading it I hadn't
bothered to use triggers, but they're going to be an integral part of the
tool I'm designing to replace our failing inventory system.

The datatime information was helpful as well, as this seems to be an
undocumented feature of SQLite 3.  Should we be considering the DATETIME
features experimental, or can we count on these going forward?  Personally
I love them, as it beats saving everything in some language proprietary
format, such as long integer for C or Doubles for Delphi.

Clay Dowling
-- 
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-24 Thread Bert Verhees 
Op woensdag 24 november 2004 00:22, schreef Griggs, Donald:
> Re:  SQLite Tutorial
> http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?d
>o wnload
>
> Thanks for providing this.

Very good, I was all the times saving emails from this mailinglist, and now I 
have the information all together.
Page works fine in Konqueror, no problems at all.

What I like too, is that it has a lot of information on almost a single page 
and no bitmaps. That makes it easy to save. 
If it could contain more information, I would have no problem with that, But I 
have a good internet-connection

Very good job

Thanks
Bert Verhees

>
> I did notice that the document insists on displaying at about 20% wider
> than my screen, causing lots of horizontal scrolling.
>
> My screen res is set to 1024x768.   Workplace PC with IE 6.0 at full
> screen. Printing it also resulted in some right-edge truncation.
>
> Donald Griggs
>
>
> Opinions are not necessarily those of Misys Healthcare Systems nor its
> board of directors.

-- 
met vriendelijke groet
Bert Verhees
ROSA Software

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-23 Thread Ulrik Petersen 
Mike,
Griggs, Donald wrote:
Re:  SQLite Tutorial
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?do
wnload
Thanks for providing this.  

I did notice that the document insists on displaying at about 20% wider than
my screen, causing lots of horizontal scrolling.
My screen res is set to 1024x768.   Workplace PC with IE 6.0 at full screen.
Printing it also resulted in some right-edge truncation.
Donald Griggs
 

The offending line is in a C code section where it says:
  ss[p->sscnt] << ")";
This line has too much whitespace after the final semicolon. Delete 
this, and the document should display fine w.r.t. width.  Checked with 
IE6 with 1024x768 resolution.

Ulrik P.

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-23 Thread mswarm 
>
>Subject: [sqlite] SQLite Tutorial - [Request For Comments]
>   From: [EMAIL PROTECTED]
>   Date: Tue, 23 Nov 2004 15:15:17 -0500
> To: [EMAIL PROTECTED]
>
>SQLite Tutorial
>http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download
>
>This article explores the power and simplicity of sqlite3, 
>first by starting with common commands and triggers, 
>then the attach statement with the union operation is 
>introduced in a way that allows multiple tables, in 
>separate databases, to be combined as one virtual table, 
>without the overhead of copying or moving data. Next, 
>the simple sign function and the amazingly powerful 
>trick of using this function in SQL select statements 
>to solve complex queries with a single pass through 
>the data is demonstrated, after making a brief 
>mathematical case for how the sign function defines the 
>absolute value and IF conditions. 
>
>This is a working document to help educate the community.
>It will always be GPL or Public domain.
>
>I am open to comments for suggestions.
>
>Regards,
>
>Mike Chirico

Mike, other than the width others have noted, the document
seems to be displaying OK for me in IE5. 

As a newcomer to both SQL and SQLite, but not as a newcomer
to programming in general, the ABSOLUTE BEST single thing 
to have in documentation is EXAMPLES, EXAMPLES AND MORE EXAMPLES.

Thanks for putting this up. Did I mention that examples are a
good thing?

RE: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-23 Thread Griggs, Donald 
Re:  SQLite Tutorial
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?do
wnload

Thanks for providing this.  

I did notice that the document insists on displaying at about 20% wider than
my screen, causing lots of horizontal scrolling.

My screen res is set to 1024x768.   Workplace PC with IE 6.0 at full screen.
Printing it also resulted in some right-edge truncation.

Donald Griggs


Opinions are not necessarily those of Misys Healthcare Systems nor its board
of directors.

Re: [sqlite] SQLite Tutorial - [Request For Comments]

2004-11-23 Thread sporkey 
On Tue, Nov 23, 2004 at 04:39:57PM -0500, D. Richard Hipp wrote:
> amead wrote:
> >D. Richard Hipp wrote:
> >
> >>[EMAIL PROTECTED] wrote:
> >>
> >>The formatting seems all messed up after the 3rd example
> >>in the "ATTACH command" section.  (As viewed from Mozilla.)
> >
> >
> >I didn't notice any obvious formatting issues viewing it using Netscape 
> >7.2 or Firefox Preview 1.0 (on Windows XP).
> >
> 
> The error is in the following snippet of HTML:
> 
> >
> >To summarize a query was performed on two tables that resided in separate 
> >databases. This union created the virtual table. The select syntax is as 
> >follows:  SELECT  FROM . For the table option we have
> >used the complete string "(select 'e1' as db,* from e1.exam union select 
> >'e2' as db,* from e2.exam)", which is our virtual table.
> >
> >
> 
> It should say "" not "" and
> "" not "".  It is the second of these
> that is giving mozilla fits, I suspect.
> 
> Generally speaking, the document I downloaded has a lot
> of "<" and ">" characters that should be "<" and ">"
> respectively.

Thank you.  I go through and correct this.

Mike


> 
> 
> 
> 
> 
> -- 
> D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565


Re: [sqlite] SQLite Tutorial - [Request For Comments]


2004-11-23

Thread
D. Richard Hipp

amead wrote:
D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
The formatting seems all messed up after the 3rd example
in the "ATTACH command" section.  (As viewed from Mozilla.)

I didn't notice any obvious formatting issues viewing it using Netscape 
7.2 or Firefox Preview 1.0 (on Windows XP).

The error is in the following snippet of HTML:

To summarize a query was performed on two tables that resided in separate databases. 
This union created the virtual table. The select syntax is as 
follows:  SELECT  FROM . For the table option we have
used the complete string "(select 'e1' as db,* from e1.exam union select 'e2' 
as db,* from e2.exam)", which is our virtual table.


It should say "" not "" and
"






" not "".  It is the second of these
that is giving mozilla fits, I suspect.
Generally speaking, the document I downloaded has a lot
of "<" and ">" characters that should be "<" and ">"
respectively.


--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565


Re: [sqlite] SQLite Tutorial - [Request For Comments]


2004-11-23

Thread
amead

D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
The formatting seems all messed up after the 3rd example
in the "ATTACH command" section.  (As viewed from Mozilla.)
I didn't notice any obvious formatting issues viewing it using Netscape 
7.2 or Firefox Preview 1.0 (on Windows XP).

I plan on printing this to read it carefully..  it looks very useful.  I 
know there's considerable interest in using sqlite in the Free 
Pascal/Lazarus/Delphi/Kylix communities ... I don't think those bindings 
are mentioned.

-Alan
--
Alan Mead - [EMAIL PROTECTED]
People often find it easier to be a result of the past than a cause of
the future.





Re: [sqlite] SQLite Tutorial - [Request For Comments]


2004-11-23

Thread
D. Richard Hipp

[EMAIL PROTECTED] wrote:
I am open to comments for suggestions.
The formatting seems all messed up after the 3rd example
in the "ATTACH command" section.  (As viewed from Mozilla.)
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565





[sqlite] SQLite Tutorial - [Request For Comments]


2004-11-23

Thread
sporkey

SQLite Tutorial
http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download

This article explores the power and simplicity of sqlite3, 
first by starting with common commands and triggers, 
then the attach statement with the union operation is 
introduced in a way that allows multiple tables, in 
separate databases, to be combined as one virtual table, 
without the overhead of copying or moving data. Next, 
the simple sign function and the amazingly powerful 
trick of using this function in SQL select statements 
to solve complex queries with a single pass through 
the data is demonstrated, after making a brief 
mathematical case for how the sign function defines the 
absolute value and IF conditions. 

This is a working document to help educate the community.
It will always be GPL or Public domain.

I am open to comments for suggestions.

Regards,

Mike Chirico