Re: [sqlite] Output in currency format

2009-11-12 Thread Fred Williams
That has always been my most effective last resort when attempting to do business math with many databases and development environments. > Thanks for all the advice on this. Just to be clear, I wasn't > referring to the accuracy of calculations when I compared the sqlite > date/time

Re: [sqlite] Output in currency format

2009-11-11 Thread Fred Williams
The best (safest?) way I have found to handle non scientific math is to work strictly with integers and multiply and divide using ROUND/TRUNC as required to gain the precision required. This includes way more than SQLite situations as well. Borland (Code Gear) seem to be the only developer

Re: [sqlite] low-level view of data values?

2009-10-13 Thread Fred Williams
- Original Message - From: "Dan Phillips" To: "General Discussion of SQLite Database" Sent: Tuesday, October 13, 2009 2:40 AM Subject: Re: [sqlite] low-level view of data values? > On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson

Re: [sqlite] Tedious CSV import question

2009-09-25 Thread Fred Williams
If you have a file that conforms fully to the RFC, I honestly don't see the problem. Your examples do not meet the RFC rules. If the rule does not address leading spaces outside the quoted text, then the input file should not contain spaces there as they will be ignored. Over the years I have

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Fred Williams
, at 1:13 PM, CityDev wrote: > > > Fred Williams-5 wrote: >> >> no further need to ask and answer, "Will SQLite support >> multi users? >> > Maybe it should be covered a bit more specifically on the SQLite site, http://www.sqlite.org/whentouse.html > bea

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Fred Williams
Since SLQite was never intended for multi user databases in the initial design i.e. the name "SQLite" I would say the design is the reason. Now can the design be reengineered to allow finer grain locking as an option without derailing the original design intent? That is for those that do all the

Re: [sqlite] Tedious CSV import question

2009-09-24 Thread Fred Williams
Try this: http://sqliteadmin.orbmu2k.de/ Works great for me. Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of J Glassy Sent: Thursday, September 24, 2009 3:16 PM To: General Discussion of SQLite Database Subject: Re:

Re: [sqlite] Most wanted features of SQLite ?

2009-09-21 Thread Fred Williams
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Simon Slavin Sent: Monday, September 21, 2009 3:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? On 21 Sep 2009, at

Re: [sqlite] Most wanted features of SQLite ?

2009-09-21 Thread Fred Williams
n of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? On Sep 21, 2009, at 8:58 AM, Fred Williams wrote: > > Fine for me. It seems to be everybody else that wants their favorite > feature imbedded in the core :-) > > Fine grained locking would be a

Re: [sqlite] Most wanted features of SQLite ?

2009-09-21 Thread Fred Williams
to:sqlite-users-boun...@sqlite.org]on Behalf Of Alexey Pechnikov Sent: Monday, September 21, 2009 1:54 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? Hello! On Monday 21 September 2009 01:45:07 Fred Williams wrote: > With the background of th

Re: [sqlite] Most wanted features of SQLite ?

2009-09-20 Thread Fred Williams
Can you say Oracle? :-) Along this same line, and based on a few years of using SQLite and following the messages on this list, here's my two cents worth. First a disclaimer: I have no knowledge of the detailed implementation and architecture of SQLite, other than by inference from discussions

Re: [sqlite] Most wanted features of SQLite ?

2009-09-20 Thread Fred Williams
Can you say Oracle? :-) Along this same line, and based on a few years of using SQLite and following the messages on this list, here's my two cents worth. First a disclaimer: I have no knowledge of the detailed implementation and architecture of SQLite, other than by inference from discussions

Re: [sqlite] Most wanted features of SQLite ?

2009-09-18 Thread Fred Williams
We don't really need that "SQLite." We already have it. It is commonly called MySQL. It take well over 150MB of disk space and major management efforts to maintain any level of performance. Just what the client/server guys love to play with. SQLite is way too small and Bring to catch

Re: [sqlite] MySQL makes me wish for SQLite

2009-09-11 Thread Fred Williams
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Darren Duncan Sent: Friday, September 11, 2009 3:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MySQL makes me wish for SQLite Fred Williams wrote

Re: [sqlite] MySQL makes me wish for SQLite

2009-09-11 Thread Fred Williams
Discussion of SQLite Database Subject: Re: [sqlite] MySQL makes me wish for SQLite On Fri, Sep 11, 2009 at 03:24:09PM -0500, Fred Williams scratched on the wall: > Please, is someone working on a good straight forward .PHP SQLite > interface? I might even pay for it! *Confused* SQLite i

Re: [sqlite] MySQL makes me wish for SQLite

2009-09-11 Thread Fred Williams
Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred Williams Sent: Friday, September 11, 2009 4:24 PM To: General Discussion of SQLite Database Subject: [sqlite] MySQL makes me wish for SQLite Just began coming back to speed on M

[sqlite] MySQL makes me wish for SQLite

2009-09-11 Thread Fred Williams
Just began coming back to speed on MySQL after many years. (Thanks to SQLite) Boy does it SUCK! I've already eaten up the better part of 150MB of disk space, run installation repair once, (of many?) and still trying to find the "admin" logon and password. Damn! It has been too long! Please,

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-13 Thread Fred Williams
ents still meaningful. Fred Williams wrote: > Having had the unfortunate opportunity to use a couple of language > translators as well as spending about six fruitless months developing one > which in the end was no better, I say there is no known translation that > would allow the three SQLite,

Re: [sqlite] [Delphi] Reading list of tables?

2009-08-13 Thread Fred Williams
That's all you are suppose to get when querying the Master table for table names. You ask how to get a list of tables. That is what you got. What you are asking for now is more complex. Try: Select Name, SQL from "SQLite_master"; for even more fun try: Select * from "SQLite_master" Fred

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-12 Thread Fred Williams
translate the object code. It's also possible to translate bytecode (for example, from Java to .NET). - Original Message - From: "Fred Williams" <f.willi...@verizon.net> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday,

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-12 Thread Fred Williams
inns Sent: Wednesday, August 12, 2009 12:09 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLJet - pure Java implementation of SQLite -BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fred Williams wrote: > I say there is no known translation that > would allow the three SQLi

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-11 Thread Fred Williams
Having had the unfortunate opportunity to use a couple of language translators as well as spending about six fruitless months developing one which in the end was no better, I say there is no known translation that would allow the three SQLite, "Small, Fast, Reliable" adjectives to translate into

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Fred Williams
Thank you for your understanding. And best of luck with XXLite? I know you have a large captive audience out there. It is the only reason I swallow my pride and admit knowledge of the most pervasive OS currently on the planet. Not the "best" technically, but best "marketed." Fred

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Fred Williams
und of why this programmer did a port directly > to C# instead of binding C# to the existing C library, but I assume he > had his reasons. > > - Original Message - > From: "Fred Williams" <f.willi...@verizon.net> > To: "General Discussion of SQLite Da

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-01 Thread Fred Williams
version to be faster. I don't know the background of why this programmer did a port directly to C# instead of binding C# to the existing C library, but I assume he had his reasons. - Original Message - From: "Fred Williams" <f.willi...@verizon.net> To: "General Discussi

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-01 Thread Fred Williams
Hummm... Guess there is a reason there are no implementations of C# external to the Mickeysoft world :-) Guess if I had a lot of time to kill I could port it to Delphi... BTW, what's the memory footprint? Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
te.org] On Behalf Of Fred > Williams > Sent: Saturday, July 25, 2009 4:44 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] .lib file? > > Hum. So Mickeysoft does not supply a lib converter/creator utility? I even > have a "Make" and "Grep&qu

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
r, for that matter, .obj) files created by Borland compilers are not compatible with the Microsoft toolchain, and vice-versa. Borland uses a variant of the OMF object format, and Microsoft uses a variant of COFF. On 07/25/2009 08:09 PM, Fred Williams wrote: > Paul, > > If you wish I can send yoou a S

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
Paul, If you wish I can send yoou a SQLite3.lib file I just generated using my old Borland C++ Builder 5 Lib utility. Can't attach it here so contact me: fwillia...@gmail.com And I'll attach it to a reply. Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Installing SQLite

2009-07-23 Thread Fred Williams
That might be an option to consider. But, I think there might be a rather small number of potential SQLite users interested. I would think the group with the greatest benefit of that kind of package would be students and serious rookies. Most users I feel either pre possess the required

Re: [sqlite] Installing SQLite

2009-07-23 Thread Fred Williams
I think you guys are most likely feeding a Troll, or the original poster might ought to contact his IS support department, or enroll in some introductory basic home computer continuing education courses in his local area. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Fred Williams
Ahhh! The price of using the company e-mail :-) "Mustang Vineyards" is willing to let the world receive and store for all posterity edification and benefit, the sage ramblings in every message! Read on you lucky masses! :-) Fred No company disclaimer attached. -Original Message- From:

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Fred Williams
Reminds me of the old days BTW (Before The Web) when the News Net's main recreation was "C" language curly brackets formatting flame wars :-) I was kind'a wondering what on earth is so complicated in SQLite that would take an entire book to cover? Is it a thin book? How 'bout big print for us

Re: [sqlite] [Columns] Keeping internal + beautified names?

2009-07-14 Thread Fred Williams
For overall performance and efficiency, I recommend you keep the "pretty" in the GUI where such things are traditionally implemented. Pick two of three: "COOL, Fast, Tight." Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
6, 2009 12:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Datatypes (D. Richard Hipp) On 16 Jun 2009, at 5:32pm, Fred Williams wrote: > Still think, logically speaking, the construct should throw an error > message, rather than make stealth changes to the expected re

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <f.willi...@verizon.net> wrote: > What! The standard is lacking? Will wonders never cease? > > Thanks, you saved me from some boring reference reading. > > Still think, logically sp

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Igor Tandetnik Sent: Tuesday, June 16, 2009 10:57 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <f.willi...@verizon.net> wrote: > Is this a violation of SQL

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
Is this a violation of SQL Standards? Seems like it should be. I'm not for dumbing down the system to compensate for the occasional idiot programmer. After all, we are not the government, nor should we strive to act like it (IMHO). If someone chooses to attempt to create a

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
Is this a violation of SQL Standards? Seems like it should be. I'm not for dumbing down the system to compensate for the occasional idiot programmer. After all, we are not the government, nor should we strive to act like it (IMHO). If someone chooses to attempt to create a

Re: [sqlite] Topics 1 - Re: sqllogictest tool - please help :-)

2009-06-10 Thread Fred Williams
I think your problems have nothing to do with SQLite, yet. To begin you need some help related to the "C" programming language. The three files you have listed are the "Make", "Source" and "Header" files for a C program. You must compile these to develop an executable program. Once you have

Re: [sqlite] Db design question (so. like a tree)

2009-06-04 Thread Fred Williams
Nothing to do with relational databases, but if you are developing for a future animal husbandry environment I would plan on supporting clones. Like it philosophically or not. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of

Re: [sqlite] sqlite programmed in C++

2009-06-03 Thread Fred Williams
Well said! C++ provides the average programmer "automated" Object Orientation, or better stated, good programming practices, at a price. A good C programmer can equal and most times exceed the results of a C++ programming project. As previously stated C is really just a lazy man's Assembler, and

Re: [sqlite] sqlite programmed in C++

2009-06-02 Thread Fred Williams
I figure the only reasons it is written in C is for portability and Assembler programming is a bitch! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of P Kishor Sent: Tuesday, June 02, 2009 10:36 AM To: General Discussion of

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

2009-02-23 Thread Fred Williams
That's the reason in memory databases are so fast. If a DB is small enough you can spool the whole thing into RAM on open and spool it back out on close. If you are attempting to use the DB in any kind of multi user environment client system large cache sizes are going to play H--- with

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

2009-02-22 Thread Fred Williams
Since the dawn of digital computers the CPU has been waiting on the I/O. Want to go faster? Get a faster mass storage device. Then your CPU usage will most likely jump all the way up to 9% - 14%! You can't believe what a 300 card per minute 80 column card reader does to throughput when you use

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
Subject: Re: [sqlite] SELECT issue with SQLite 3.6.10 On Jan 27, 2009, at 10:08 AM, Fred Williams wrote: > > Should not the GENERAL.ID be enclosed in double quotes? Or did I > misread > the SQL Standard? You can use double-quotes to conform to the SQL standard. But SQLite also all

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
Should not the GENERAL.ID be enclosed in double quotes? Or did I misread the SQL Standard? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Tuesday, January 27, 2009 8:06 AM To: General Discussion of

Re: [sqlite] seeking storage design assistance

2008-10-01 Thread Fred Williams
One rule used in basic systems design is: Define the input, define the output, and the rest will become obvious. If only it were that simple:-) But, a point to ponder. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Godfrey Sent: Wednesday,

Re: [sqlite] Vista frustrations

2008-09-18 Thread Fred Williams
r, Molly is no longer handling the cache manager. I believe she has moved back into the kernel group after a brief departure, but is working on something else. I haven't seen the talks that Robert refers to, but suspect they are close to the versions I have seen in person. I would bet they are still v

Re: [sqlite] Vista frustrations

2008-09-18 Thread Fred Williams
Is a sad day when an application program is forced to compensate for pitiful OS design and performance :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Simpson Sent: Thursday, September 18, 2008 10:31 AM To: 'General Discussion of SQLite Database'

Re: [sqlite] Vista frustrations

2008-09-17 Thread Fred Williams
Have you ever actually used a version of Windows? ANY OS that attempts to read in a xGigibyte file into real memory to the detriment of the entire system load is not working correctly. Call it a bug or a feature it still sucks. I expect nothing less from Microsoft with each new version. I

Re: [sqlite] Vista frustrations

2008-09-17 Thread Fred Williams
Possibly the reason a large number of us are still running Win 2000 :-) It seems to be the least Windows like Windoze ever released... When follow on support degrades to an untenable level, I'll either switch to Linux with a Windoze emulator or maybe run whatever the future ruler of the Universe

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread Fred Williams
I haven't met a real programmer since I wrote my last TASM program quite a few years ago. :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of palmer ristevski Sent: Tuesday, September 16, 2008 11:19 AM To: General Discussion of SQLite Database Subject: Re:

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

2008-09-03 Thread Fred Williams
What is so unique to SQLite that it would require its very own Entity Relationship engine? Relational databases are relational databases. Granted some are "more" relational than others, but that is where the designer's mind is required to function above a video game level. Fred -Original

Re: [sqlite] 2 Questions from a newbie

2008-08-19 Thread Fred Williams
1. Third Normal, as in "Database normalization." (Database 101) No offence intended, you said you are a beginner. 2. Right. My "unlimited" stock and prices advantage. No creating a table for each new stock. No creating a table or adding columns (Both time and logically intensive.) for

Re: [sqlite] 2 Questions from a newbie

2008-08-19 Thread Fred Williams
Third normal says: Table: Stock ID Integer Primary Key, Symbol Varchar(n), ... Other stuff Table: DaylyPrice (I'd call it "Price") StockID Integer (Foreign key:

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Fred Williams
Henceforth and forward: Let the standards violator suffer his just rewards!" :-) Dr., your just trying to supply the worlds greatest database, not take a bunch of slovenly coders to raise... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of D. Richard Hipp

Re: [sqlite] SQL understanding problem

2008-06-26 Thread Fred Williams
If all the collum contents are identical why should it matter wich one is modified? Just do a select ... Limit 1 subquery in the update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of c.panel Sent: Thursday, June 26, 2008 4:57 PM To:

Re: [sqlite] transaction recovery question

2008-06-03 Thread Fred Williams
That's why I continue to monitor SQLite messages even when I'm not actively developing with SQLite. There is an inherent entertainment value that appears built in. Over time I'm certain I have been guilty of posting some shall we say "entertaining" messages myself. Sometimes I think SQLite is

Re: [sqlite] Virtual tables declaration statements

2008-05-05 Thread Fred Williams
Don't think that will happen. "Dot" notation is used as in "databasename.tablename" and is therefore a restricted use notation. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aladdin Lampe Sent: Monday, May 05, 2008 8:57 AM To:

Re: [sqlite] Delphi dbExpress driver for SQLite3 ?

2008-04-22 Thread Fred Williams
Try this: http://www.aducom.com/sqlite/ You can dump DBExpress completely. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LacaK Sent: Tuesday, April 22, 2008 2:15 AM To: sqlite-users@sqlite.org Subject: [sqlite] Delphi dbExpress driver for SQLite3 ?

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Fred Williams
Might want to download the free source for the Delphi VCL set for Sqlite DB access componenets provided at Aducom.com and review the releven source code. Sorry, it is written that highly "inelegant" Object Pascal. But I'm an old "C" coder from way back and do read and write Object Pascal more so

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

2008-03-04 Thread Fred Williams
You might want to test a little further with Aducom's stuff. I'm using Aducom and have the following working code in at least one app: begin AList.Fields.FieldByName(FldName[j+1]).Value := Trim(ExtractData(RS)); if RP >= Length(RS) then break; end;

Re: [sqlite] Updatable views

2008-02-12 Thread Fred Williams
I agree very much with your suggestion. Although all those vendor specific "extensions" generally make the designers and coders lives easier, the wheels tend to come off in onerous ways when a heavily extended project migration is attempted. Even when using a given vendor's product I have, based

RE: [sqlite] Next Version of SQLite

2008-01-14 Thread Fred Williams
> -Original Message- > From: Nicolas Williams [mailto:[EMAIL PROTECTED] > Sent: Monday, January 14, 2008 10:29 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Next Version of SQLite > > > On Sun, Jan 13, 2008 at 08:46:03PM -0600, Rick Langschultz wrote: > > I was wondering what

RE: [sqlite] SQLite --> PostGres

2008-01-11 Thread Fred Williams
I like the idea of keeping SQLite strictly SQL Standard compliant. With strict compliance one has a very strong and highly transportable development platform to migrate a finished application to any SQL Standard compliant database. If all those vendor specific SQL Standard "extensions" are

RE: [sqlite] Re: "always-trim" - feature suggestion

2008-01-09 Thread Fred Williams
> -Original Message- > From: Aristotle Pagaltzis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 1:27 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Re: "always-trim" - feature suggestion > > > * Zbigniew Baniewski <[EMAIL PROTECTED]> [2008-01-09 18:15]: > > On Wed,

RE: [sqlite] "always-trim" - feature suggestion

2008-01-09 Thread Fred Williams
> -Original Message- > From: Zbigniew Baniewski [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 11:08 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] "always-trim" - feature suggestion > > > On Wed, Jan 09, 2008 at 11:25:01AM -0500, Rob Sciuk wrote: > > > You know,

RE: [sqlite] database column attributes

2007-12-21 Thread Fred Williams
Answers in line. > -Original Message- > From: arbalest06 [mailto:[EMAIL PROTECTED] > Sent: Friday, December 21, 2007 9:23 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] database column attributes > > > > good day! > > i want to create a database with a table that has a column which

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

2007-12-17 Thread Fred Williams
sunderstanding...I mean - right off the > forklift. I'm sure > > anyone with the proper motivation can learn to program, but > it took me > > 25 years to realize how little I really knew. > > I didn't write the original about forklift operators. It was Fred > Williams, AFAI

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 performance of SQLite.

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

2007-12-17 Thread Fred Williams
] > Sent: Monday, December 17, 2007 6:16 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite. Anyone heard > ofDeviceSQL? > > > James Steward wrote: > > On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: > > > >> A hun

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

2007-12-17 Thread Fred Williams
myself :) > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http://www.polsoftware.com/ > > -- Original message -- > From: "Fred Williams" <[EMAIL PROTECTED]> > > A hundred or so Visual Basic p

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

2007-12-17 Thread Fred Williams
A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff from the largest pool, not the most effective. Besides it's damn hard to be a

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

2007-12-15 Thread Fred Williams
This discussion reminds me of another long, long ago in a galaxy far, far away. (When I worked on "Mainframes" with 32 K or less "core" memory.) Discussing the then lopsided world with my non-IBM salesman, in a local watering hole, after a particularly trying day of dealing with "management."

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

2007-12-13 Thread Fred Williams
If you suspect "Group By" also may be broken, why not to an interim "bug fix" release and then do the version number change when both "Order By" and "Group By" are fixed? I seem to remember instances where both Order BY and Group By have given me "unexpected" results. But then again, my logical

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
For what reason would "non-technical" types need to look on the SQLite website? :-) I kind'a like it the way it is. Plain and simple, with no over wrought graphics and other worthless fluff. It is a website for a very bare bones, plain and simple database. Those who access it are not looking for

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

RE: [sqlite] Trigger update of multiple columns

2007-06-18 Thread Fred Williams
I think maybe "Normalization" could be one of the best underutilized features of modern database design by most practicing "Database Consultants." Never have I seen such a rule with so many exceptions! Each normalization decision must be prefaced with "It Depends" in every instance. Ah the

RE: [sqlite] Limit statement size?

2007-01-28 Thread Fred Williams
Wow! Talk about obfuscated code! I didn't even try to dig deeper than a quick scan, but could this abomination be broken into multiple update queries? On the surface it looks like each "group" is unique. If so, wouldn't a transaction with multiple update statements be much more efficient and a

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

2007-01-25 Thread Fred Williams
> -Original Message- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 25, 2007 12:06 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to conditionally drop a table? > > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > > If you find a

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 sqlite is typeless actually

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] > Sent: Saturday,

RE: [sqlite] Using sqlite.exe

2006-12-30 Thread Fred Williams
Don't know why you are using the "backdoor" approach (Calling the SQLite.exe module) accessing an SQLite database from Delphi, but you might want to look at what these people have to offer: www.aducom.com I have been using their components for a while now and have been quite happy with the

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

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
Unfortunately our Congress seems to have a short memory, on top of constantly appearing embarrassingly stupid and crooked as a snake. I remember the last time they messed with DST. Seems little Yankee school munchkins were being squashed by school buses in the resulting early morning darkness.

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
I also have an issue with "Order By" with one of my queries as well. I am doing a multi field Order By and the second of the two fields does not sort in the correct order. I do not have the code in front of me, so can't supply any details. I have been killing bigger alligators on that

RE: [sqlite] Interbase to SQLite

2006-12-09 Thread Fred Williams
t: RE: [sqlite] Interbase to SQLite > > > OK, I think I get it now. > There is no ready made dll, but I have to write one in C or C++. > Trouble is I only know VB/VBA, so not too easy then. > > RBS > > > -Original Message- > From: Fred Williams [mailto:[EMAIL PR

RE: [sqlite] Interbase to SQLite

2006-12-07 Thread Fred Williams
well, now that you have one of the most powerful development platforms in the known universe installed, study up a bit (won't require much) on the "VCL" concept. There are VCL's available for both Interbase and SQLite. Install them and sail on... Or, if you are an old "C" coder break out the

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
date storage format based on an > epoch way > >>>back in antiquity so that you can present it in any > national format. > >>> > >>>Using the internal format date comparison is just a > numeric compare, > >>>which is efficient. > >>

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

2006-12-03 Thread Fred Williams
h Excel and I have tried that but it doesn't work. > I find the only reliable way to put dates in Excel is to put > the integer > Excel date in like for example 39054 and then set the date > format in the > sheet. > > RBS > > -Original Message- > From: Fred Williams

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 format a spreadsheet programmatically. Fred >

RE: [sqlite] SELECT on empty fields ??

2006-11-27 Thread Fred Williams
That is why everything in the world is not painted grey. There are those of us who find null values distinct and meaningful and those who don't. I personally prefer null (Unknown, etc.) values versus contrived values which in effect mean I don't like dealing with nulls so here's a blank string,

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:

  1   2   3   >