RE: [sqlite] Trigger update of multiple columns

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 potent

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

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] sqlite programmed in C++

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 SQLi

Re: [sqlite] sqlite programmed in C++

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] Db design question (so. like a tree)

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 Ib

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

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 acc

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

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 column/table/databas

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

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 column/table/databas

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

: 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 wrote: > Is this a violation of SQL Standards? Seems like it should

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

PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams wrote: > What! The standard is lacking? Will wonders never cease? > > Thanks, you saved me from some boring reference reading. > > Still think, logically speaking, the construct s

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

ay, June 16, 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 e

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

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 Of

Re: [sqlite] The SQL Guide to SQLite

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 ol

Re: [sqlite] The SQL Guide to SQLite

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

Re: [sqlite] Installing SQLite

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

Re: [sqlite] Installing SQLite

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 expertis

Re: [sqlite] .lib file?

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 [mailto:sqlite-u

Re: [sqlite] .lib file?

.lib (or, 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 ca

Re: [sqlite] .lib file?

e-users-boun...@sqlite.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&quo

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

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 [mailto:sqlite-user

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

he metal. I would expect the C 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" To: "Gene

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

ster. > > 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" > To: "General Discussion

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

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

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

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 an

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

Of Roger Binns 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

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

d be better to translate the object code. It's also possible to translate bytecode (for example, from Java to .NET). - Original Message - From: "Fred Williams" To: "General Discussion of SQLite Database" Sent: Wednesday, August 12, 2009 5:42 AM Subject: Re: [sqlite

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

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

he origibal code with the comments 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 >

[sqlite] MySQL makes me wish for SQLite

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

Re: [sqlite] MySQL makes me wish for SQLite

ODBC? -Jeff -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 t

Re: [sqlite] MySQL makes me wish for SQLite

eral 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* SQL

Re: [sqlite] MySQL makes me wish for SQLite

-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] Most wanted features of SQLite ?

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 their

Re: [sqlite] Most wanted features of SQLite ?

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 on

Re: [sqlite] Most wanted features of SQLite ?

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 on

Re: [sqlite] Most wanted features of SQLite ?

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 ?

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

Re: [sqlite] Most wanted features of SQLite ?

-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 6:53pm,

Re: [sqlite] Tedious CSV import question

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

Re: [sqlite] SQLite Suitability for Shopping Cart

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] SQLite Suitability for Shopping Cart

, 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] Tedious CSV import question

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 wr

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

- 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 > wrote: >> I'm pretty sure I do store them as strings

Re: [sqlite] Output in currency format

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 to

Re: [sqlite] Output in currency format

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 formatti

RE: [sqlite] Suggests for improving the SQLite website

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] Suggests for improving the SQLite website

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

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

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] Should the next release be 3.5.4 or 3.6.0?

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 t

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

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

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

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 prima

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

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

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

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

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

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

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

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

RE: [sqlite] database column attributes

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 i

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

> -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] Re: "always-trim" - feature suggestion

> -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] SQLite --> PostGres

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 really

RE: [sqlite] Next Version of SQLite

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

Re: [sqlite] Updatable views

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] [Delphi7] TEXT vs. (VAR)CHAR?

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

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

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 t

Re: [sqlite] Delphi dbExpress driver for SQLite3 ?

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] Virtual tables declaration statements

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: sqlite-users@sqlite.org

Re: [sqlite] transaction recovery question

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 so

Re: [sqlite] SQL understanding problem

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: sqlite-users@sqlit

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

smime.p7m Description: S/MIME encrypted message

RE: [sqlite] how to fix problem of lock

I would suggest as a beginning: www.hwaci.com/sw/sqlite/whentouse.html www.hwaci.com/sw/sqlite/lockingv3.html www.hwaci.com/sw/sqlite/faq.html#q7 www.hwaci.com/sw/sqlite/faq.html#q8 www.sqlite.org/cvstrac/wiki?p=MultiThreading AND www.hwaci.com

RE: [sqlite] UI framework for sqlite

Not sure why you are trying to do something like that. One technique which seems to be quite common, and that I use extensively, is to present a scrollable read only grid of pertinent data fields. with a "VCR" button set for control. The user can press the buttons for Insert, Delete, or Edit for

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

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] Structured or Object-Oriented?

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: sqlite-users@sqlite

RE: [sqlite] Structured or Object-Oriented?

t waiting for other people to reply also to > confirm this, I do not have any beef with anyone. Sorry if > it came accross > this way. > > Aaron > > On 13/04/06, Fred Williams <[EMAIL PROTECTED]> wrote: > > > > It would appear the first responder gave you yo

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

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

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

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

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

How about some form of automated(?) sequence where: New subscriber submits subscription request. System sends "query" message to subscriber address. New subscriber sends "confirmation" message within reasonable time period. List access granted on receipt of confi

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

ED]&Ke y=bf3y9e9txka -- > -Original Message- > From: Fred Williams [mailto:[EMAIL PROTECTED] > Sent: Monday, May 29, 2006 9:07 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Purging the mailing list roles. Was: Please > Restore Your Account Acc

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

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, [EMAI

RE: [sqlite] unsuscribe

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 ar

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

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

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

I suggest we don't pick Access/Jet MDB as our shining example of SQLite's future Borland's old, dead, and gone Paradox was Access' main reason to come into existence. Inspire of outliving Paradox, only because of marketing reasons, Access has never been able to leapfrog or even measure up to old

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

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

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

I would guess from the drift of things, you really should be working at learning the database language "SQL" and not "learning" SQLite. SQLite is only one of a multitude of modern relational databases which use SQL as their language of choice for their user interface. Actually using SQLite once y

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

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 hea

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

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 post

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

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] How do you find out the names of the fields within a table?

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 13

RE: [sqlite] locked implies exception?

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

RE: [sqlite] IO Access Time

Using an SQL engine to drive a relatively small database is not really very simple, IMHO. But you will notice I am a member of the SQLite fan club for some time now. My largest dataset is somewhere just over 10K rows. I justify using SQLite by noting the advantage of using a well maintained, wid

RE: [sqlite] converting a sqlite table to dbf

Kind'a like chucking your Pentium 5 and going back to scratching on the cave wall with a rock, Eh? I'd export the tables to a CVS files using something like SQLiteAdmin.exe. Open the CVS files with Excel and save the resulting spreadsheets as .DBF files (My Excel has a choice of DBASE II through

RE: [sqlite] converting a sqlite table to dbf

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] Re: two questions about formatting output

>From experience. Most "free form" output routines I have used utilizes the content of the first row to establish the width of "columns." (i.e. Reflected in the result per your "Administrative Assistant") If you can "throw away" your first row of output, you could insert a first row in your table

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

> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Friday, September 15, 2006 10:27 AM > To: SQLite > Subject: [sqlite] Re: Re: Re: Which API to use to get > resultant of query > > > sandhya <[EMAIL PROTECTED]> wrote: > > But where as when i am executing the sam

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

Unless you have a very funny shaped disk drive all the files are "Flat" :-) I tend to agree stating SQLite is a "Flat file" somewhat oversimplifies things to me as my definition of a "flat file" is a simple sequential set of data written in no particular order and retrievable only by opening the f

RE: [sqlite] Please test check-ins [3445] and [3446]

Win'ders don't recognize no stenk'en .gz files! Besides, Linux groupies don't have time to write Windows evil doer programs. There is no challenge there :-) Fred > -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 26, 2006 10:43 AM > To: sqlite-

RE: [sqlite] import syntax and null values

> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 9:26 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Rich Shepard wrote: > > On Mon, 2 Oct 2006, Eric Matthew Finnin wrote: > > > >> Could someone

RE: [sqlite] import syntax and null values

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

RE: [sqlite] import syntax and null values

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

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

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 S

RE: [sqlite] new sqlite-based webserver

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:

  1   2   3   >