emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: "Thomas S. Dye" <tsd@tsdye.online>
To: Eric Abrahamsen <eric@ericabrahamsen.net>
Cc: emacs-org list <emacs-orgmode@gnu.org>
Subject: Fwd: Re: Finally figuring out some ob-sqlite stuff -- for worg?
Date: Sat, 09 Nov 2019 07:43:16 -1000	[thread overview]
Message-ID: <87zhh5ndxn.fsf@tsdye.online> (raw)
In-Reply-To: 871ruhosqd.fsf@tsdye.online

Cancel that, I was looking at a cached version of the page.

Thanks again for the documentation.

All the best,
Tom

Thomas S. Dye writes:

>> Okay, it's up. If anyone wants to explain to me the point of 
>> the
>> "where
>> exists" clause in the SQL, I would be interested to hear. It
>> works as
>> expected this way, but is that clause necessary?
>
> The 'if exists' clause protects against an SQLite error raised 
> if
> you ask to delete a table that doesn't exist.  The code will 
> work
> without it if the table exists, but will exit without creating 
> the
> table if not.
>
> Thanks for a useful addition to the Org babel SQLite
> documentation.  I agree with you that Org mode tables are a
> convenient way to enter SQL data, keeping in mind that table
> columns can't be rearranged without changes to the SQL code.
>
> All the best,
> Tom


--
Thomas S. Dye
http://tsdye.online/tsdye

next prev parent reply	other threads:[~2019-11-09 17:43 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2019-11-09 17:38 Finally figuring out some ob-sqlite stuff -- for worg? Thomas S. Dye
2019-11-09 17:43 ` Thomas S. Dye [this message]
2019-11-09 18:00   ` Fwd: " Eric Abrahamsen

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87zhh5ndxn.fsf@tsdye.online \
    --to=tsd@tsdye.online \
    --cc=emacs-orgmode@gnu.org \
    --cc=eric@ericabrahamsen.net \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).