RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread Fred Williams
It's the ones who never figure out how little they know that do all the damage... Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:22 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving perfor

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDeviceSQL?

2007-12-17 Thread Fred Williams
There you go! Thinking like an engineer (logical) and not management :-) I have met a few $100K+ programmers out there, but none were VB'ers. Just a bunch of "namby pamby" C and C++ wizards :-) Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
heir technical tasks, because internally they lack the technical strength. Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 3:40 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Improving performance of S

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
sides it's damn hard to be a prima donna, when your replacement is ready to jump off that forklift and learn a cushy job. Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 16, 2007 7:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqli

RE: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-15 Thread Fred Williams
d bytes "real world." My late salesman friend said, "Fred, don't you understand that the computer industry is a Marketing industry based on technology, and not a technology industry?" Thirty years later nothing could be truer. No matter how much things change, they still stay th

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Fred Williams
xpected" results. But then again, my logical thinking is not on Mr. Spock's level, unfortunately. Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 13, 2007 10:41 AM > To: sqlite-users@sqlite.org > Subject: [sqlit

RE: [sqlite] Re: Different between BEGIN, END and "begin transaction", "

2007-11-29 Thread Fred Williams
Actually the first looks like Pascal and the second COBOL (Well, it should be all upper case)... > -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 12:47 PM > To: SQLite > Subject: [sqlite] Re: Different between BEGIN, END and "begin

RE: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Fred Williams
Great idea! Why don't we give them little printable chits for free chips and beer as well?! Just the facts m'am. -- Jack Webb > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, November 09, 2007 5:51 PM > To: sqlite-users@sqlite.org > Subject: Re:

RE: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Fred Williams
ot looking for entertainment, just plain and simple results. Fred > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Friday, November 09, 2007 4:25 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Suggests for improving the SQLite website > >

RE: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Fred Williams
It would most likely be much quicker (and simpler) just to utilize the OS's file coping feature to copy the table. What would be gained with the attaching databases approach over just a straight file copy? Fred > -Original Message- > From: Rich Rattanni [mailto:[EMAIL PROTECTED]

RE: [sqlite] Trigger update of multiple columns

2007-06-18 Thread Fred Williams
the related dynamic master tables. (i.e. the subject table is no longer a "transaction" table in the true sense but a static snapshot of a given physical activity. The exact definition of a particular "sales" event and not subject to change. But then again... Fred > -Origin

RE: [sqlite] Limit statement size?

2007-01-28 Thread Fred Williams
efficient and a much lighter load on resources on a step by step basis? I damn well know it would be much more pleasing to the eye! :-) Fred > -Original Message- > From: RB Smissaert [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 28, 2007 12:07 PM > To: sqlite-users@sqlite.

RE: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Fred Williams
t; > Thanks for your insight. However what's your point? That the OP didn't > check the website, that my reference was incorrect or what? > -- > G. Roderick Singleton <[EMAIL PROTECTED]> > PATH tech > > Now you know why there are no software types that are stand up comedians :-) I think it was a (bad) attempt at a joke... Fred - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Sqlite Preprocessor

2007-01-11 Thread Fred Williams
Or my contempt of code generators in general :-) Fred > -Original Message- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 11, 2007 12:46 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Sqlite Preprocessor > > > I think the fact that sql

RE: [sqlite] sqlite performance, locking & threading

2007-01-06 Thread Fred Williams
Sounds like a H-- of a plan to me! I'll call Larry Ellison and warn him to put the 12 meter yacht up for sale, he's about to get steam rolled! :-) Fred > -Original Message- > From: Bill King [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 06, 2007 1:15 AM > To:

RE: [sqlite] sqlite performance, locking & threading

2006-12-30 Thread Fred Williams
Been following this a while... You have access to the source, and apparently are a "threading genius." Please make the required minor changes and post a link here so we can all benefit. Fred > -Original Message- > From: Emerson Clarke [mailto:[EMAIL PROTECTED]

RE: [sqlite] Using sqlite.exe

2006-12-30 Thread Fred Williams
uite happy with the results. It would certainly prove to be much more straight forward and most likely produce much better performance. Fred > -Original Message- > From: Michael Hooker [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 30, 2006 9:22 AM > To: sqlite-users@sqlite.org > Su

RE: [sqlite] ETA for SQLite 3.3.9 ?

2006-12-25 Thread Fred Williams
Sounds like an assumption is being made that the sqlite.h file will always be present. Never have received the *.h file without downloading the source, which most wrapper users never do. And most likely don't want to know what an *.h file is anyway. Fred > -Original Message- >

RE: [sqlite] ETA for SQLite 3.3.9 ?

2006-12-23 Thread Fred Williams
If it ain't broke, don't "fix" it? > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 23, 2006 12:33 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] ETA for SQLite 3.3.9 ? > > > it's been a while since 3.3.8. > >

RE: [sqlite] calculate age

2006-12-23 Thread Fred Williams
. Didn't take long for the voter outcry to reverse that dumb a-- move :-( Note to silicon designers: Don't rush to adjust! Fred > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 23, 2006 11:52 AM > To: sqlite-users@sqlite.org &

RE: [sqlite] Question about SQLite for Symbian

2006-12-21 Thread Fred Williams
Just looked and my old link to the Symbian/Borland C++ link is gone. THere is a new link to something called "Carbide C++" Must be "Ford Tough." Anyhow, here's the link: http://www.forum.nokia.com/info/sw.nokia.com/id/fd975c95-4c71-4ec2-ad1d- 338f52156503/Carbide_cpp_Express.html >

RE: [sqlite] multiple order by value bug?

2006-12-12 Thread Fred Williams
alligators on that project so the Order By issue is on the "to do" list. I just figured it was my Select statement, although it is pretty straight forward, as I remember. Perhaps there is a bug report in the making. Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [sqlite] Interbase to SQLite

2006-12-09 Thread Fred Williams
How about Pascal? Wordy like Basic, powerful like "C". Download Turbo Delphi, and give it a look. Fred > -Original Message- > From: RB Smissaert [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 07, 2006 4:11 PM > To: sqlite-users@sqlite.org > Subjec

RE: [sqlite] Interbase to SQLite

2006-12-07 Thread Fred Williams
uot; coder break out the whip with nails embedded and slog and flog on through the relevant API's. You will feel right at home :-) Fred > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 07, 2006 10:19 AM > To: sqlite-user

RE: [sqlite] Query generation

2006-12-06 Thread Fred Williams
Pusedo code: set s.sql = 'select a from mytable where (b=0)'; if got.more then set s.sql = s.sql + ' and ' + s.userinput; ... set s.sql = s.sql + ';'; > -Original Message- > From: Lloyd [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 07, 2006 2:46 AM > To: sqlite-users@sqlite.org

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
for various uses. I don't have Interbase installed anywhere right now or I would look into this issue a little closer. I do know that I did both data imports and exports to and from Interbase with little or no problems other than the normal self inflicted wounds. Fred > -Original Mess

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
structure is not possible. Fred > -Original Message- > From: RB Smissaert [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 03, 2006 8:56 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Dealing with dates in the format mmdd > > > I am familiar wit

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
Is there a reason you can use Excel's "Format Cells" to accomplish what you wish? Enter a "Custom" format of "\mm\dd" in a cell and enter "=today()" as a value in that cell. Have not fooled with Excel much lately, but I think you can even form

RE: [sqlite] SELECT on empty fields ??

2006-11-27 Thread Fred Williams
, or is that an empty string, missing value? Or worse, zero vs. unknown? Damn! there goes the AVG(), Count(), and etc. function accuracy out the window! Oh well, it sure is easy to code! Fred > -Original Message- > From: Darren Duncan [mailto:[EMAIL PROTECTED] > Sent: Monday, No

RE: [sqlite] IS there some way of viewing an SQLite Database?

2006-11-04 Thread Fred Williams
Or, simply look here for a whole range of selections. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools I currently prefer SQLiteAdmin.exe Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 04, 2006 3:58 PM > To:

RE: [sqlite] new sqlite-based webserver

2006-10-09 Thread Fred Williams
What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Not going to stir much interest with response times like that! > -Original Message- > From: Günter Greschenz [mailto:[EMAIL PROTECTED] > Sent: Monday, October 09, 2006 12:04 PM > To:

RE: [sqlite] Can anyone recommend some ISAM db to me?

2006-10-08 Thread Fred Williams
Well there's always XBase. Old, solid, widespread. But, I doubt XBase will be that much different overhead, and complexity wise. SQLite is really hard to beat for its intended purpose. And as far as superior implementation, I have never seen an XBase implementation that can even come close to

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 1:44 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Fred Williams wrote: > > >

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
> -Original Message- > From: Gerry Snyder [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 12:42 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Fred Williams wrote: > > Would it not be more logical

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
h, others may > find this > useful. > > HTH > Dennis Cote Would it not be more logical to modify the .import command to place a null value in a column where the input value is non existent? (i.e. Back to back separators in the input) Null in, null out. Fred - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] The term "flat-file" as applied to sqlite

2006-09-25 Thread Fred Williams
nd retrievable only by opening the file and reading sequentially from start to finish to seek out a particular data item. Fred > -Original Message- > From: Griggs, Donald [mailto:[EMAIL PROTECTED] > Sent: Monday, September 25, 2006 3:07 PM > To: sqlite-users@sqlite.org > Subj

RE: [sqlite] Re: Re: Re: Which API to use to get resultant of query

2006-09-15 Thread Fred Williams
ndetnik > Just a suggestion. When I am learning a new language, database, etc. I sometimes find working with and even stepping through supplied samples prove to be the quickest way to gain insight into how the new entity works. Saves both me and a lot of other people a lot of time and effort. Fr

RE: [sqlite] Re: two questions about formatting output

2006-08-29 Thread Fred Williams
utput, you could insert a first row in your table with "X"'s in all positions out to your maximum column widths. Export the data and delete the first line. Fred > -Original Message- > From: John Salerno [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 29, 2006 11:3

RE: [sqlite] converting a sqlite table to dbf

2006-08-29 Thread Fred Williams
Damn acronyms anyhow! Thanks. > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 29, 2006 6:47 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] converting a sqlite table to dbf > > > On 8/29/06, Fred Williams &

RE: [sqlite] converting a sqlite table to dbf

2006-08-29 Thread Fred Williams
through DBASE IV.) Or you could use that block buster database, "Access", to do the same. Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P > Kishor > Sent: Monday, August 28, 2006 11:23 PM > To: sqlite-users@sqlite.org >

RE: [sqlite] IO Access Time

2006-08-01 Thread Fred Williams
e, and etc.? Some of my stuff running today "grew up" on some pretty archaic technology. With each "upgrade" I noticed the things supporting SQL provided a much easier path than those that did not. Now, if it don't do no sten'ken SQL, it is toast! Fred > -Original

RE: [sqlite] locked implies exception?

2006-07-24 Thread Fred Williams
Good Grief! Everybody knows CRUD is what you clean off on US Navy ships at least once a week. > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 10:32 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] locked implies exception? > > >

RE: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Fred Williams
Did not realize he was using VB when I sent my last message. I'd bet VB still can't do anything dynamic. That's only one of the reasons I walked away from VB's "Daddy" (Quick Basic) years ago. > -Original Message- > From: Martin Jenkins [mailto:[EMAIL PROTECTED] > Sent: Thursday, July

RE: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Fred Williams
What language are you using? Can't you do a dynamic array? > -Original Message- > From: John Newby [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 13, 2006 7:37 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How do you find out the names of the > fields within > a table? > >

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
I think with that last one you best witch to some other database. I fear you will get no help here. Your lack of command of the English language does not excuse your extremely misaligned mind. No one on the face of this planet would place me in the "politically correct" crowd, but this last

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
Then how 'bout letting me know the next time you see a market "bubble" coming? :-) > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, July 07, 2006 8:53 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > ??? I am in

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
be required for "Databases 101" and you will get pretty much the reaction you have already witnessed. It is also not against the law to skip ahead in text when you find the current topic boring. How else could one read all those 1000+ page tomes so ubiquitous in our field of endeavor.

RE: [sqlite] Re: problem with creating a table

2006-06-25 Thread Fred Williams
> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 25, 2006 10:19 AM > To: SQLite > Subject: [sqlite] Re: problem with creating a table > > > Bijan Farhoudi > wrote: > > A. Pagaltzis wrote: > >> SELECT [order] FROM foo > >> > > But how would

[sqlite] Re : [sqlite] Very blocking problem... please help me

2006-06-22 Thread Fred a
...? Should i execute special BEGIN TRANSACTION query before creating table or another ? For this context (add some records and select some records without closing db), what is the best use case ? Thank you very much for your aid!!! Best regards, Fred Fred a <[EMAIL PROTECTED]>

[sqlite] Very blocking problem... please help me

2006-06-22 Thread Fred a
close the db before SELECT it run...) I try with BEGIN IMMEDIATE and COMMIT but it don't work... THANK YOU FOR YOUR AID Best regards, Fred.

[sqlite] locking, unlocking issues ...

2006-06-22 Thread Fred a
that without closing db before SELECT query. THANK YOU FOR YOUR AID Best regards, Fred.

RE: [sqlite] SQLite Vs VistaDB - Comparison ???

2006-06-16 Thread Fred Williams
lti-user environment, selecting SQLite is like trying to take that old '57 fuel injected, ultra lite Corvette and use it for a fully tricked out hearse. Sounds to me like a job for "Monster Garage" rather than CVS SQLite :-) Fred > -Original Message- > From: Mikey C [mailto:[E

RE: [sqlite] Sankara Narayanan is out of the office.

2006-05-31 Thread Fred Williams
Now here's a "class" of messages it would be nice to "trash." It ain't spam, but it looks like it, smells like it, and is as useful. Even if it is unintentional. > -Original Message- > From: Sankara Narayanan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 31, 2006 6:33 PM > To:

RE: [sqlite] unsuscribe

2006-05-31 Thread Fred Williams
Yet another mailing list weakness: One must be able to spell to unsubscribe! :-) > -Original Message- > From: Bob Dankert [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 31, 2006 1:43 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] unsuscribe > > > Especially considering they

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Fred Williams
BUT, the spammers ARE posting... > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 30, 2006 8:46 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Purging the mailing list roles. Was: Please > Restore Your Account Access > > > On 5/29/06,

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Fred Williams
Here's an example: --- Hi Fred Willisams, Please click on the following link to activate your account. Then start Worksite CD and click 'Yes' to get current prices at your local Home Depot: Please Click Here! Thank you for using The Home Depot Worksite CD. If you need help with Worksite

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Fred Williams
s granted on receipt of confirmation. At least the damn spammer would have to do a little work to be a bottom feeder. Too bad there must be an endless number of idiots out there (P T Barnum postulation) or the problem would self regulate. Fred > -Original Message- > From: René Tegel [mailt

[sqlite] Porting sqlite3 library problems....

2006-05-21 Thread Fred a
regards, Fred

RE: [sqlite] How can I get the type of a column?

2006-05-10 Thread Fred Williams
EMAIL PROTECTED]> > > > Only six years? How many years did it take for programmers > and others > to get past the concept of 80 column Hollerith cards, and how many > haven't yet made it? > JS Well in 196x we forward thinkers in the Polaris Navy used 90 column Univac punch cards (With ROUND holes) for our target cards. We always fancied the one with D.C. as the terminal destination :-) Fred

RE: [sqlite] How can I get the type of a column?

2006-05-10 Thread Fred Williams
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 10, 2006 7:23 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How can I get the type of a column? > > > sqlite <[EMAIL PROTECTED]> wrote: > > Eric Scouten wrote: > > > SQLite

RE: [sqlite] Structured or Object-Oriented?

2006-04-13 Thread Fred Williams
And, don't forget I used the required simley face :-) BUT, I do know that when you are up to your a__ in alligators, it is difficult to remember the objective was to drain the swamp. (or check for smiley faces.) Good luck alligator hunting! Fred > -Original Message- > From: Aaron

RE: [sqlite] Structured or Object-Oriented?

2006-04-13 Thread Fred Williams
It would appear the first responder gave you your answer. So where's the beef? If you don't like the answer, don't complain to us about service :-) Fred > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 13, 2006 8:20 AM > To:

RE: [sqlite] Most appropriate Web based database? (Newbie)

2006-04-06 Thread Fred Williams
Then again only 10,000,000 hits for SQLite (Less information to wade through) and NO book to buy! (zero out of pocket expense!) Good luck! You are most likely headed the right direction. > -Original Message- > From: Lenster [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 06, 2006 6:59

RE: [sqlite] UI framework for sqlite

2006-04-05 Thread Fred Williams
tly exceed the capabilities of a single GUI line length. Actually I think a third party Delphi Grid Component vendor I use may have the capability to do what you describe, although I have no interest is finding out how far I can "stretch" their grid in that direction. Anyway that's enough off to

RE: [sqlite] how to fix problem of lock

2006-04-04 Thread Fred Williams
not have the time and especially the patience required to teach an SQLite beginner how to write a Google replacement. Fred > -Original Message- > From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 04, 2006 1:23 PM > To: sqlite-users@sqlite.org &

RE: [sqlite] How to unsubscribe from this maillist ?

2006-04-03 Thread Fred Williams
smime.p7m Description: S/MIME encrypted message

RE: [sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-28 Thread Fred Williams
Very well thought out response. Now perhaps we will see if various people here attempting to help have been, as we say in east Texas, "Talking to a fence post." :-) Fred > -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Tuesday, Mar

RE: [sqlite] Re: concers about database size

2006-03-16 Thread Fred Williams
he "number of seats" that could/will be interacting. But, I think I smell a possible "Client Server" environment. Even simple query runs most likely won't be "snap your fingers" kind'a deals. Fred ...

RE: [sqlite] Re: concers about database size

2006-03-16 Thread Fred Williams
any manageable logical groups of data that might lend themselves to simple segmentation into separate tables/databases? Commercial databases often range into terabytes but I doubt many accomplish those numbers with a single table. None that I have worked on ever have, including "never ever forget", (spool or delete) SAP:-) Fred

RE: [sqlite] updating SQLite to implement The Third Manifesto

2006-03-12 Thread Fred Williams
reer in regards to application of relational database technology. Fred > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 12, 2006 11:03 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] updating SQLite to implement The Third Manifesto > &

RE: [sqlite] Creating a (really) big table

2006-02-10 Thread Fred Williams
then Listen. We who consider ourselves "sophisticated" must endeavor to be forever humble, in order to appear "Inteligent" rather than "Smart A--". Fred > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Friday, February 1

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

2006-01-22 Thread Fred Williams
software development is a high cost one time event. I have had occasion to see code I have written running five plus years after implementation. In that time migrated across three platforms. Fred > -Original Message- > From: Steve O'Hara [mailto:[EMAIL PROTECTED] > Sent: Sunday, J

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

2006-01-21 Thread Fred Williams
ke so many other languages has grown well beyond its initial intent, small, simple applets imbedded on a web page. With all of our advances in programming we still have not evolved that "perfect" language, and most likely never will. I spite of what those "C" guys tell you :-)

RE: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Fred Williams
stment. If anyone's application's logging requirements are non standard to the point of requiring a full featured database, I suspect this might not be considered a "traditional" logging requirement. Fred > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] >

RE: [sqlite] Thread handling in Windows

2006-01-11 Thread Fred Williams
Damn! Then he would have ALL the money, not just a few billion! :-) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 11, 2006 9:44 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Thread handling in Windows > > > "Robert

RE: [sqlite] equivalent of linked tables in sqlite ?

2005-12-14 Thread Fred Williams
Microsoft.) That has been one of Delphi's strengths in the past, connectivity to ANY data source, but Microsoft is slowly wearing Borland down and that is not a "good thing", IMHO. Fred > -Original Message- > From: gl demoor [mailto:[EMAIL PROTECTED] > Sent: Tuesday, Decemb

RE: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread Fred Williams
a little more support. Fred > -Original Message- > From: John Newby [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 13, 2005 4:26 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Final Year Project/Dissertation help > required > > > No, I'm not as

RE: [sqlite] equivalent of linked tables in sqlite ?

2005-12-12 Thread Fred Williams
ite? > >> > >> > > > >Take a look at 'attach'. I think that might get you where > you want to go > > > > > thanks for your reply, I'll look that up > > To Fred Williams: thank you too. Although I'm not very keen > to learn yet > another programming tool, I'll check delphi out . > > regards > glenn > >

RE: [sqlite] equivalent of linked tables in sqlite ?

2005-12-11 Thread Fred Williams
Use Delphi. > -Original Message- > From: gl demoor [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 11, 2005 4:46 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] equivalent of linked tables in sqlite ? > > > Hi All, > > I'm just starting with SQLite and hope to use it as the >

RE: [sqlite] basic question about sqlite

2005-11-03 Thread Fred Williams
Has somebody got amnesia or something? I think I've seen this question going on four or five times now. > -Original Message- > From: Dave Dyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 03, 2005 12:40 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] basic question about

RE: [sqlite] Re: Request for comment: Proposed SQLite API changes

2005-11-03 Thread Fred Williams
nning, why would I want two! :-) I have yet to have worked with any database engine that I could not migrate to a new release external to any code I have written. Including Paradox and XBase if those qualify as engines. To each his own. Fred > -Original Message- > From: Igor Tandetni

RE: [sqlite] type confusion

2005-11-03 Thread Fred Williams
lly wither and die. Fred > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 03, 2005 9:35 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] type confusion > > > Since SQL conformance is hard to legitimately define (Ar

RE: [sqlite] Request for comment: Proposed SQLite API changes

2005-11-03 Thread Fred Williams
ity of a documented function changes > (as opposed to merely extended) I would think it would warrent > a major revision number increase. Sqlite versions 3.1.0 and 3.2.0 > did not change as radically as is planned for this upcoming release. > > --- Fred Williams <[EMAIL PROTECTED]>

RE: [sqlite] Request for comment: Proposed SQLite API changes

2005-11-03 Thread Fred Williams
Ah, that explains why I get all those bugs in each new release of Oracle :-) > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 03, 2005 8:44 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Request for comment: Proposed SQLite API

RE: [sqlite] Request for comment: Proposed SQLite API changes

2005-11-03 Thread Fred Williams
rename all their function calls between major releases. I'm on Delphi 7.0 and have never been forced to change anything because of a new release, since Delphi 1.0. And closer to home, From PC DOS Oracle to 8.0i Oracle. Seems like a lot of additional work, and would like to understand why. Fred >

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-02 Thread Fred Williams
he "Standard." My contention is, if done properly, the Standard will be preserved. Fred > -Original Message- > From: Drew, Stephen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 02, 2005 10:01 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite]

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-02 Thread Fred Williams
ns of numbers that don't ad up with the total, and doing other tough things :-) Fred FTB2(SS) long ago > -Original Message- > From: Brass Tilde [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 02, 2005 9:44 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Proposed

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-02 Thread Fred Williams
cience. I learned the concept in the Military many years ago. Many database engines are beginning to support the data type in some manner, with few calling it BCD. Fred > -Original Message- > From: Brass Tilde [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 02, 2005 7:03 AM > To: sqli

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Fred Williams
ing "Float" (Real?) fields because (IMHO) the database designers were scientific mathematicians and the world of users were 99%^ business types. So, spare me further anguish... :-) Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesda

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Fred Williams
er find something old obscurely broken or yet another way to shoot myself in the foot with a 3.x.x "Enhancement." :-) Ah, life on the "bleeding edge"! BTW. On the Windose machine, footprint (.dll size): 2.8.x, 219K; 3.x.x, 245k (today) equals +36k, If you had yet another 36K what cou

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Fred Williams
In Delphi we have the Type: "Variant," which is pretty much "Type-less" for OOP purposes. > -Original Message- > From: Doug Currie [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 01, 2005 11:25 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Proposed 3.3.0 changes. Was:

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Fred Williams
Is it time to officially declare/fully support some Types and clear the air? Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 01, 2005 9:43 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Proposed 3.3.0 changes. Was: 5/

RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Fred Williams
What happened to the old: Integer arithmetic produces integer results rule? I thought that was either a "Standard" or at least a very old artifact. Is it not how most Language math functions work? I like the Pragma idea on this one. > -Original Message- > From: Joe Wilson

RE: [sqlite] SQLite as a Windows kernel tool

2005-10-31 Thread Fred Williams
you wish to respond, my email address is in the header Fred > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Monday, October 31, 2005 8:28 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite as a Windows kernel tool > > > What i

RE: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?

2005-09-30 Thread Fred Williams
Anybody thought of: t1.a = 5 t1.b = 2 select a / (b * 1.0); I think that would return a real. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, September 30, 2005 11:10 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem/Bug: "SELECT

RE: [sqlite] csv .import problems

2005-09-27 Thread Fred Williams
s Quick and dirty, so I expect a couple of hundred messages containing solutions of two lines of code or less solving the same problem :-) Fred --- function ExtractData(S: string): string; var j: Integer; FS: String; begin FS := ''; if (

RE: [sqlite] Multi-threading.

2005-07-29 Thread Fred Williams
Reminds me alt.C in the News Groups, arguing over curly bracket placement :-( -Original Message- From: Puneet Kishor [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 5:23 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Multi-threading. Fred Williams wrote: > How 'bout Y'

RE: [sqlite] Multi-threading.

2005-07-29 Thread Fred Williams
How 'bout Y'all take this off-line before I have to track you down and lay some Texas justice on both you... Mentioning SQLite every few sentences does not mask this religious warfare. -Original Message- From: Mrs. Brisby [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 3:15 PM To:

RE: [sqlite] UPDATE - crash when many columns

2005-07-27 Thread Fred Williams
be? Thanks in advance for any help Mark Furnishing no hardware specs requires one to presume there is some form of hardware constraint (most likely memory) causing you issue. Fred

RE: [sqlite] Memory usage and multiple small databases

2005-07-14 Thread Fred Williams
ead design, as long as you promise not to start whining about multi user issues. :-) FOOTPRINT, FOOTPRINT, FOOTPRINT... Fred -Original Message- From: Christian Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 9:23 AM To: sqlite-users@sqlite.org; Joey Ekstrom Subject: Re: [sqli

<    1   2   3   >