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
