Thank you, thank you!
Balaji Ramanathan
-- Forwarded message --
From: Richard Hipp
To: General Discussion of SQLite Database <
sqlite-users@mailinglists.sqlite.org>
Cc:
Bcc:
Date: Thu, 12 Mar 2020 16:17:59 -0400
Subject: [sqlite] New SQLite Forum established - this mailin
't export an entire multi-tab
spreadsheet as one CSV. Same thing applies to databases. You can either
export each table as a CSV, then import them into multiple tabs of a
spreadsheet and use vlookups to relate the data into one bigger dataset
with more columns - or better yet, w
count of ID's using a
range "between unbounded preceding and unbounded following" just seems
wrong! Is there a simpler construct I am missing? Thank you.
Balaji Ramanathan
> From: Dan Kennedy
> To: sqlite-users@mailinglists.sqlite.org
> Cc:
> Bcc:
> Date: Mon, 24 Dec 2018
functions
were added in version 3.25.0, and does not give any indication as to
whether they are enabled or disabled in the command line tool. Is there
perhaps a pragma setting I have to turn on for window functions to work?
Thank you.
Balaji Ramanathan
the contents of the database into a
text file, use search and replace to do the column rename, and then use
.read to read it back into a SQLite database. Anything I have to watch out
for if I do the above?
Thank you.
Balaji Ramanathan
From: Richard Hipp
To: SQLite mailing list
Cc:
Bcc:
Date: Mon, 26
d, or mangled the syntax in some way. Thank you.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>8. Re: sqlite-users Digest, Vol 130, Issue 11 (Shawn Wagner)
> >On Thu, 11 Oct 2018 09:51:15 -0500, Balaji Ramanathan <
> balaji.ramanat...@gmail.com> wrote:
> >>
> >>2. Re: SQLite mailing list
> >>
> >
> > The 1990's called and t
>
>2. Re: SQLite mailing list
>
>
The 1990's called and they want their mailing lists back. So, let us
switch to 21st century technology already. Count me in as an enthusiastic
YES vote for proper forums (including subforums - so that I can read what I
want and skip the rest instead of
ance, for creating forms, reports, etc. I experimented
with SQLite Expert, but found its user interface less to my liking.
Neither of these tools will limit some people to read-only access to the
database.
Hope I have given you some things to think about, and hopefully try out
to get an i
SELECT COUNT(*) FROM TABLE WHERE NAME <= (SELECT NAME FROM TABLE WHERE ID =
3 ORDER BY NAME ASC)
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
postfixes
come from? If I know a column is going to be repeated n times in my view,
can I predict what the column names in the resulting output will be?
Thank you.
Balaji Ramanathan
On Thu, Mar 8, 2018 at 9:41 PM, Balaji Ramanathan <
balaji.ramanat...@gmail.com> wrote:
> Hi,
>
>
lumns (even though, in the command line,
they are revealed to me as "country" and "country:1").
Anyways, long description of a problem that has probably been
encountered and solved many times before. If someone could give me the
answer or point me to the documentat
Are there equivalent instructions for Windows? Thank you.
Balaji Ramanathan
-- Forwarded message --
From: Richard Hipp <d...@sqlite.org>
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Cc:
Bcc:
Date: Sat, 18 Nov 2017 13:22:45 -0500
Subject: Re: [sq
This is great information. Thank you very much for a clear explanation,
Keith. I guess I have to go back to using CTE's to get what I want in this
case.
Balaji Ramanathan
-- Forwarded message --
From: Keith Medcalf <kmedc...@dessus.com>
To: SQLite mailing list <sql
om where?
Thank you.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
?
Thank you.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Thank you, Peter. Perhaps it would be a good idea to update the SQLite
website and point links to tcl.tk rather than tcl-lang.org.
Balaji Ramanathan
-- Forwarded message --
From: Peter Da Silva <peter.dasi...@flightaware.com>
To: SQLite mailing list <sql
on that platform, I would appreciate it. Thank you again.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ww.tcl-lang.org website has been down for at least the past 3
days it looks like. Not sure how to interpret the reliability of a
technology whose home website is down for days at a time.
Balaji Ramanathan
On Tue, Nov 14, 2017 at 6:00 AM, <
sqlite-users-requ...@mailinglists
Very interesting. Thank you David. I have never used a recursive CTE
before, so I am still trying to understand exactly how it works. But it
does work, so I will definitely take a closer look. Thank you.
Balaji Ramanathan
On Tue, Nov 14, 2017 at 6:00 AM, <
sqlite-users-r
front-end development tool (preferrably
open-source, but just free and well-maintained is sufficient), I would
appreciate it greatly.
Thank you very much.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
OK, thanks for the short and sweet answer! I just wanted to make sure I
wasn't missing something.
Balaji Ramanathan
> -- Forwarded message --
> From: Simon Slavin <slav...@bigfraud.org>
> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
>
se fields. I have thought about creating a temp table out of this view
so that I can index RowNumber (I don't know whether it will help) but it
goes against my minimalist instincts.
Thank you.
Balaji Ramanathan
___
sqlite-users mailing
Ramanathan
From: Igor Tandetnik <i...@tandetnik.org>
> To: sqlite-users@mailinglists.sqlite.org
> Cc:
> Bcc:
> Date: Sat, 11 Nov 2017 21:17:24 -0500
> Subject: Re: [sqlite] Can someone explain these outputs for me?
> On 11/11/2017 8:55 PM, Balaji Ramanathan wrote:
>
>> 3
The only mentions of the "||" operator on the SQLite website (
https://sqlite.org/lang_expr.html) don't really explain what is going on in
the above examples.
Any help would be much appreciated. Thank you.
Balaji Ramanathan
___
sqlite-use
I am glad you were able to fix it quickly. I assume the next version of
SQLite (3.19.4 or 3.20 or whatever) will include the fix? Thank you.
Balaji Ramanathan
On 6/11/17, Balaji Ramanathan <balaji.ramanat...@gmail.com> wrote:
>
> Everything was working fine under 3.15.
Thank you very much, Simon. I was able to downgrade to 3.18 using your
instructions and everything seems to work now.
Balaji Ramanathan
On 11 Jun 2017, at 2:56pm, Balaji Ramanathan <balaji.ramanat...@gmail.com>
wrote:
> This is going to sound stupid, but I would like to know how to
&
Thank you very much, Dr. Hipp. I am glad I was not imagining a problem
that nobody else could reproduce. If you need any additional details or if
you can think of any other way I can help with the investigation, please
let me know.
Balaji Ramanathan
PS: This is going to sound stupid, but I
e symptoms point to some kind of
regression in sqlite between 3.15 and 3.19.3, and I would like to see if
there is a fix that does not involve modifying my database.
Thank you very much.
Balaji Ramanathan
___
sqlite-users mailing list
sq
and one I still have a soft
spot for after all these years is Pascal. As for using SQLite with Access,
once I got to that website and saw the references to Windows XP, I beat a
hasty retreat! I am not that desperate, thank you very much!!
Balaji Ramanathan
>On 2016/05/30 7:09 PM, Balaji Ramanat
end similar to sqlite expert called
aSQLiteManager (
https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager).
But this also seems to be more of a 1-person development effort, so I am
not sure how feature-rich it will eventually become.
Balaji Ramanathan
>I agree on the u
capabilities that come with that. But it costs money to keep
Access around, and it is usable only on my PC. I decided I could live
without the prettiness so that I would have something that is more flexible
and will remain accessible even if I don't have a Windows machine in the
future.
Balaji
ing up with the times, not
already obsolete before you even download it and start using it.
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
me all the time. And a forum can be set up to email you every time someone
posts something if you want to follow along in real-time. But if the main
contributors prefer a mailing list then I can get used to it too.
Balaji Ramanathan
___
sqlite-users
Your case statement syntax is completely off. Also, the concatenation
operator in sqlite is ||, not +.
Try this:
insert into Customer(id)
select case when b.id = id then b.id||'A' else b.id end from customerb b
Balaji Ramanathan
___
sqlite-users
, Bug Reports,
etc., etc.) and readers don't have to wade through all the stuff they are
not interested in just to participate in the stuff they are interested in.
I understand that mailing lists were the norm in the 1990's, but times have
changed.
Balaji Ramanathan
On Thu, May 26, 2016 at 4:53 PM
2; sqlite-us...@sqlite.org
Original-Recipient: rfc822;sqlite-us...@sqlite.org
Action: failed
Status: 5.7.1
Remote-MTA: dns; mail.sqlite.org
Diagnostic-Code: smtp; 554 5.7.1 <sqlite-us...@sqlite.org>: Recipient
address
rejected: Access denied
-- Forwarded message --
From:
. Decisions, decisions . . .
I vote for more extensive support of hidden columns in tables, views, etc.
Is there some site for submitting enhancement requests for SQLite?
Balaji Ramanathan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
re was an easier way to do this using just the view rather
than copying and pasting massive amounts of text between windows.
Balaji Ramanathan
.
In the meantime, copying the view's definition as a query and adding the
filtering and sorting clauses to the query gets me there. It is a little
bit of work, but keeps my formatting so that I can scan each row quickly
and verify the data (which is the primary aim of my view).
Balaji Ramanathan
involved, not
just those in the SELECT clause. Maybe I am just spoilt!
Thank you in advance for your thoughts on this.
Balaji Ramanathan
41 matches
Mail list logo