Fwd: Re: Finally figuring out some ob-sqlite stuff -- for worg?

["Thomas S. Dye" <tsd@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