Yes I had done an "apt-get install sqlite" which had installed sqlite2. I
removed it, installed sqlite3 and all is good now.
On Mon, May 26, 2014 at 8:26 AM, Donald Griggs <dfgri...@gmail.com> wrote:
> Hi Fred,
>
> At the risk of informing you of something you may a
I am using sqlite3 version 2.8.17 on an Arm Debian Linux system.
I created a test table using these commands from Linux:
"
cat 01_create_tables.sql
CREATE TABLE PV_INTERVALDATA (
timestamp DATE,
T_ambient REALNOT NULL,
T_trunk1 REALNOT NULL,
T_trunk4 REAL
> I think that in general it might be a good idea to update the code to
> not produce any 64 bit portability warnings, so that we know for sure,
> that compiling 64 bit does not introduce any 64 bit side effects or possible
> bugs.
...as long as doing so does not break 32-bit c
ums/en-US/windowsgeneraldevelopmentissues/thread/81dd029f-2f55-49f2-bd02-1a8ceb0373eb
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ge.net/
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
le
on a mailing list.)
Gee, "see-plus-plus", "emm-eff-see", and "boost" (etc.) are all a lot
easier (to pronounce, anyway - ).
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
tools producer to recognize the need for "business" math with
their native BCD data type.
Fred
> Seems like I should handle the formatting in my application. Not sure
> I agree that sqlite is not the place to do output formatting - it
> provides lots of date and time for
error 1 in 3.6.20)
You may have decided to eliminate a dangerous feature? I have coded a
workaround in my production applications.
Regards
Fred Meier
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
de by the decimal
offset (i.e. 10, 100, 1000) for presentation purposes, doing my own
"bankers rounding" in code. Big hassle, but transports well.
As long as computer scientists are driving the bus, business math will
remain a step child, although probably 90+ % of all db apps are busines
written several CSV parsers in three of four different
languages at least and have never had a problem parsing a VALID CSV file. I
have never used the SQLite command line utility for such so cannot judge its
functionally. I use my own parser or someone else's'.
Fred
-Original Message
Thanks Dr.
I already read that along time ago and fully understand it 100%. Seems many
others either do not read or do not understand simple straight forward
descriptions of basic functionality. Or just maybe they ask anyway hoping
someone will say well why not? :-)
Fred
120% happy with SQLite
hat do all
the work for the rest of us to decide.
My only incentive that pops readily to mind would be the enormous bandwidth
reduction here with no further need to ask and answer, "Will SQLite support
mulit users? and etc. ad nauseium..." :-)
Fred
-Original Message-
Fro
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
te.dll used as the "Local" and
SQLite.dll + as the "Server."
Fact is Advantage was what I was using for my "Local" DB implementations
before discovering SQLite.
Fred
___
sqlite-us
o remain small, fast,
and tight, a core that can either be used as is or embedded in a bigger
picture.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp
Sent: Monday, September 21, 2009 8:14 AM
To: General Discussio
Fine for me. It seems to be everybody else that wants their favorite
feature imbedded in the core :-)
Fine grained locking would be a great "asset" I feel. Notice I did not
request a "feature."
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mail
y. With finer grained locking implmenting
multi user "server" wrappers and plug-ins would be better facilitated
and allow the base SQLite module to remain true to the three choices.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqli
. With finer grained locking implmenting multi user
"server" wrappers and plug-ins would be better facilitated and allow the
base SQLite module to remain true to the three choices.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sql
g to catch their eye. If it ain't big
and overly complex it must be a toy.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Simon Slavin
Sent: Friday, September 18, 2009 2:56 PM
To: General Discussion of SQLite Database
Subjec
-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
des, I just got back from Big Lots! where I bought some cheap Chinese
tools and I feel better now :-)
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Jay A. Kreibich
Sent: Friday, September 11, 2009 3:41 PM
To: General
get that 25 hour day I've been needing.
I think my previous message was a bit of a vent. But one does often wish
for "White Knights", like when I found Dr. Hip's little less than 500K bit
of code.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-user
Sorry, I guess you might have noticed my frustration is showing a bit...
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Somebody did later write a Databus/Datashare to C translator and the
Datapoint world beat a very deep pathway to his door! Shortly after that
Datapoint was no more and his market evaporated.
Sorry, this ain't SQLite at all. I'm done here.
Fred
-Original Message-
From: sqlite-
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 "SQLit
member, haven't done it in years, Borand's C and C++ compilers
could output Assembler source. One could conceivably take that output and
translate it into almost any foreign CPU's native Assembler with great
efficiency I would think.
Opps! Straying a long way from SQLite!
Fred
-Origin
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
translate into any regurgitated language output, with the exception of
compiling SQLite source with a C++ compiler :-)
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Roger Binns
Sent: Tuesday, August 11, 2009 7:15 PM
T
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 "m
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
place, so to speak.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Jim Showalter
Sent: Saturday, August 01, 2009 1:06 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
Could we
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
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
you mean?
Someday if I can find someone to hold a big enough caliber gun to my head,
I'm going to learn something about the "Visual" development world. I
installed the C++ "Express" version and was so underwhlmed by the
performance I started look for that person with a giant gun :
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
everything in life. With 20 being the Gurus
or wana'bes and 80 the rest of us.
BTW, I'll go further and say that fewer than 20 of the above 80 even know
about this mailing list ;-)
Dr. Hipp may be able to back this up with some general numbers if he wishes
to totally waste his time...
Fred
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
int for
us old _arts.
Fred
Miss the old signature "Tag line" message terminators as well, as most times
they were much more entertaining than the post they were attached to.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Beh
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...@
k,
logical) I still feel an error message rather than an unrequested result to
be much more palatable and much less potentially destructive.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Simon Slavin
Sent: Tuesday, June 1
I'll settle for wishful thinking if that is what it takes to clone a table
schema with a Create...Select...statement.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Igor Tandetnik
Sent: Tuesday, June 16, 2009 12:23 PM
What! The standard is lacking? Will wonders never cease?
Thanks, you saved me from some boring reference reading.
Still think, logically speaking, the construct should throw an error
message, rather than make stealth changes to the expected result.
Fred
-Original Message-
From
/database name that is
incorrect perhaps they should receive a refreshing error message pointing
out their verbal shortcomings? Otherwise I think this could break a lot of
good code for the sake of "maybe"...
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-
/database name that is
incorrect perhaps they should receive a refreshing error message pointing
out their verbal shortcomings? Otherwise I think this could break a lot of
good code for the sake of "maybe"...
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-
op an executable program.
Once you have accomplished this, you can start learning SQLite.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of tsachi ofir
Sent: Wednesday, June 10, 2009 2:27 AM
To: sqlite-users@sqlite.org
Subje
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
Assembler, and you can't
get any closer to the hardware, unless you are into machine language,
independently wealthy, with no need for sleep.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Ibrahim A
Sent: Wednesday, June 03,
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
--- with concurrency.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of jose isaias cabrera
Sent: Sunday, February 22, 2009 10:41 PM
To: pechni...@sandy.ru; General Discussion of SQLite Database
Subject: Re: [sqlite] Windows XP: How Can I Get
it to replace a 100 card per minute reader! I know,
been there, done that! :-)
Sit back and watch the flashing lights. BUT, keep your hands in your
pockets!
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of jose isaias
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
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
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
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
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'
recommend you
wait for, it looks like, maybe, Service Pack 6 before you get serious about
Vista.
Fred
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Roger Binns
Sent: Wednesday, September 17, 2008 4:02 PM
To: General Discussion of SQLite Database
Subject: Re
(Google) tells me to :-)
By then, I figure to be carrying around a holographic 42" 3-D display,
surround sound cell phone anyhow. BTW, that will have the same form factor
as the "Star trek Next Generation", Communicator.
Fred
-Original Message-
From: [EMAIL PROTECTED]
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:
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
---
logically intensive.) for each new stock or price. And just generally
FLEXIBILITY without extreme pain!
3. The date and time the price was quoted.
4. Exactly.
A good book: Oracle, "Case Method, Entity Relationship Modeling."
Good luck!
Fred
-Original Message-
From: [EMAIL PROTE
rly,
daily, weekly, etc.) Your queries would determine "closing price" hourly,
dally, monthly, etc.
Thoughts to ponder: How to handle stock "splits", Mergers, and ?
Fred
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of cstrader
Sent: Tue
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
Mihai Limbasan wrote:
> I don't think it's too OS-specific - I think it's really outside the
> scope of the sqlite3 shell. The shell is really not intended to be a
> presentation layer, it's supposed to be a demo application, debugging
> helper, and quick-and-dirty manipulation tool. If a
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:
S auto makers. When a
US auto maker builds a successful small car the first thing they do is start
making it bigger, to the point it loses all its original market share and
subsequent value.
Fred
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of P Kishor
Se
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
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
I think one of the most lacking aspects of the documentation are
examples. Perhaps this is better addressed in the proposed tutorial, but
not all the "SQL Syntax" pages make it clear how to use the statement,
especially the more complex ones like SELECT, and expressions.
The datetime use is
bject Pascal more so
than "C". Just think of it as a wordy "C" without a real need for those
pesky pointers. I have never looked that deep in that particular area of
the source so have no direct suggestions. I just let Delphi VCL's do the
scrolling in either direction.
Fred
Dennis Cote wrote:
> Fred J. Stephens wrote:
>> Is there a way to list the column names in a table from the SQLite
>> command line interface? I know .schema will show them, but the
>> output seems like it would be difficult to parse so that only the column
>> n
Is there a way to list the column names in a table from the SQLite
command line interface? I know .schema will show them, but the
output seems like it would be difficult to parse so that only the column
names are shown.
Thanks
Fred Stephens
Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
>
>> But to us former Access users, "database" is quick shorthand.
>
> Fred,
>
>Access is a joke. At least, that's what my colleagues who must work in the
> Microsoft world tell me.
I
Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
>
>> No, SQLite IS a database.
>
>Er, not so. It's a relational database management system that supports the
> creation of as many different databases as you care to write.
Right. I knew I was going to m
until you get the data out of Access format. The only way I know offhand
to do that without exporting it in csv (comma separated values) or
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqli
Michael Hooker wrote:
> I dare say someone will ask why you don't use Access 97 (or later) to
> display the file. It would be the easiest option, after all! If you don't
> have Access try OpenOffice, it's free.
>
> If you really want to use Sqlite I'd load the file into Access (or
>
think
SQLite will be any help until you get the data out. Then, you could
store it in SQLite instead of Access.
There are ODBC drivers available, for use in Open Office I think, and
others. Try searching for Access +ODBC
Fred Stephens
___
sqlite-users
ass
multiple commands to sqlite. I'm sure there is a better way, but this works.
NOTES is a table in my personal information manager to store random text.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
How can I limit the width of column returned by a query?
In a bash script I am returning an ID, and a text field from a table.
The text field can be any length, contain newlines, etc. The problems is
if a row of results contains a new line, the "grid" of rows and columns
is messed up. I can
John Stanton wrote:
> Fred J. Stephens wrote:
>> Would it be possible to incorporate a clear screen command, like "clear"
>> in BASH? This would be handy to keep the view in the command line
>> interface uncluttered.
>> Maybe ".clear"?
> You
Derrell Lipman wrote:
> In konsole (and xterm, I'm pretty sure), you can just hit CTRL-L to
> clear the screen whenever you're at an sqlite> prompt.
Excellent! Thats what I needed.
Thank you.
Fred
___
sqlite-users mailing list
sqlite-users@s
SQLite's command line program.
Fred
> On Wed, Mar 26, 2008 at 1:59 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote:
>
>> Would it be possible to incorporate a clear screen command, like "clear"
>> in BASH? This would be handy to keep the view in the
Would it be possible to incorporate a clear screen command, like "clear"
in BASH? This would be handy to keep the view in the command line
interface uncluttered.
Maybe ".clear"?
___
sqlite-users mailing list
sqlite-users@sqlite.org
the
documentation.
Thanks
Fred
On 3/22/08, Christian Smith <[EMAIL PROTECTED]> wrote:
>
> On Sat, Mar 22, 2008 at 06:44:45PM +0900, Fred Janon wrote:
> > Hi,
> >
> > I read the documentation, features and faq and could not find anything
> that
> > specifi
, used a
few selects with join with no surprise. Nice and clean. Good job SQlite
team. I am doing a project on Android, I guess you'll see more and more
people working on Android.
Thanks
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.or
end;
Fred
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Gilles Ganault
> Sent: Tuesday, March 04, 2008 4:08 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?
>
>
> On Tue, 4 Mar 2008 13
text).
Some data I am encrypting with gpg, but I am saving that as files
outside the database.
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
just a
way to get started until I move to Python. Also, it is good practice in
BASH scripting, SQL and basic usage of SQLite.
Thanks for your information.
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mai
Mike McGonagle wrote:
> Hello all,
> I was hoping that someone might share some tips on working with Blobs?
I am also curious about this.
For instance, how can I store a file in a table?
Not read the file and store the text, but the binary file itself?
Thanks.
Derrell Lipman wrote:
> On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote:
>> How can I issue 2 commands to SQLite at the same time in a shell script?
>> I want to temporarily change the separator for the returned data,
>> something like:
>>
How can I issue 2 commands to SQLite at the same time in a shell script?
I want to temporarily change the separator for the returned data,
something like:
sqlite3 database.db ".separator " ", SELECT first,last FROM address;"
But I can't get it to work.
Thanks.
QL Standard whenever possible. This
tends to cause less future work in the long run. Although that approach
does not eliminate all conversion efforts, because most DB vendors can't
even get the SQL Standard right :-(
Fred
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAI
On 1/16/08, John Stanton <[EMAIL PROTECTED]> wrote:
> Do you have readline installed on your Linux machine? If not download
> the package, configure and install. Then compile Sqlite with readline.
John,
Yes I do have readline installed, and as I said, SQLite worked fine
with the version from the
Just replaced SQLite v 3.42 on Kubuntu 7.10 with the new v3.45 binary
downloaded from sqlite.org. it works fine, but now I don't have the
(essential, to me) command history. I have searched the forums and
read that it requires readline. I do have /lib/libreadline.so.5.
I tried compiling from
"marketing" with one
word, so to speak. Therefore I doubt marketing will have much impact on
versioning. What a quandary develops when one goes against the grain of
commercial software deployment :-)
Fred
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
SQLite. Easy for someone like me to ask for, as a non
code contributor "user." :-)
Fred
> -Original Message-
> From: P Kishor [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 11, 2008 1:19 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite --> PostG
rmally a very passionate individual
or idea is presented and is perceived as was unintended.
I pulled that "failure to communicate" trick recently with VB coder references.
Fortunately that thread died a well deserved death earlier than this one.
But, it did little to change my opinion of BASIC as a computer "language." :-)
Fred
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
from PDA to File Server. That
is the reason I use SQLite, and for that reason only.
If I need a greater feature set than SQLite provides, I have a multitude
of database engines at my disposal with greater feature sets and price
range beginni
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
Went south in a rush. Agreed. BTW, I can drive a forklift, and a back
hoe...
Fred
> -Original Message-
> From: James Steward [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 17, 2007 6:43 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Improving performance of
1 - 100 of 236 matches
Mail list logo
