From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Thomas S. Dye" <tsd@tsdye.online>
Subject: Fwd: Re: Finally figuring out some ob-sqlite stuff -- for worg?
Date: Sat, 09 Nov 2019 07:43:16 -1000
Message-ID: <87zhh5ndxn.fsf@tsdye.online>
References: <871ruhosqd.fsf@tsdye.online>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:470:142:3::10]:59341)
 by lists.gnu.org with esmtp (Exim 4.90_1)
 (envelope-from <tsd@tsdye.online>) id 1iTUlf-0004pR-C3
 for emacs-orgmode@gnu.org; Sat, 09 Nov 2019 12:43:24 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <tsd@tsdye.online>) id 1iTUld-0003XM-Vs
 for emacs-orgmode@gnu.org; Sat, 09 Nov 2019 12:43:23 -0500
Received: from gateway32.websitewelcome.com ([192.185.145.171]:42259)
 by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
 (Exim 4.71) (envelope-from <tsd@tsdye.online>) id 1iTUld-0003WX-R5
 for emacs-orgmode@gnu.org; Sat, 09 Nov 2019 12:43:21 -0500
Received: from cm17.websitewelcome.com (cm17.websitewelcome.com [100.42.49.20])
 by gateway32.websitewelcome.com (Postfix) with ESMTP id 0C1E7545B7D
 for <emacs-orgmode@gnu.org>; Sat,  9 Nov 2019 11:43:21 -0600 (CST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <https://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
 <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Eric Abrahamsen <eric@ericabrahamsen.net>
Cc: emacs-org list <emacs-orgmode@gnu.org>

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