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

2020-02-12 Thread Bastien
Hi Eric, Eric Abrahamsen writes: > This is about putting some more example stuff on Worg about using Org > and SQLite... Please go ahead and add this -- no need to ask for permission, Worg is not too sensible :) Thanks, -- Bastien

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

2019-11-10 Thread Eric Abrahamsen
Stefan Nobis writes: > Eric Abrahamsen writes: > >> I was confused in part because the "where exists (select *..." looks >> like its main purpose is to return rows. > > Indeed that's the purpose: Restrict the set of rows upon which update > acts on. Here I tried to reformat the statement a bit

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

2019-11-10 Thread Eric Abrahamsen
Stefan Nobis writes: > Eric Abrahamsen writes: > >> I was confused in part because the "where exists (select *..." looks >> like its main purpose is to return rows. > > Indeed that's the purpose: Restrict the set of rows upon which update > acts on. Here I tried to reformat the statement a bit

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

2019-11-10 Thread Stefan Nobis
Eric Abrahamsen writes: > I was confused in part because the "where exists (select *..." looks > like its main purpose is to return rows. Indeed that's the purpose: Restrict the set of rows upon which update acts on. Here I tried to reformat the statement a bit in order to emphasize its

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

2019-11-09 Thread Eric Abrahamsen
"Thomas S. Dye" writes: > Cancel that, I was looking at a cached version of the page. I guessed that was what happened :)

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

2019-11-09 Thread Eric Abrahamsen
Stefan Nobis writes: > Eric Abrahamsen 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? > > Yes, very necessary. Without it, all

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

2019-11-09 Thread Thomas S. Dye
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

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

2019-11-09 Thread Thomas S. Dye
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

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

2019-11-09 Thread Stefan Nobis
Eric Abrahamsen 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? Yes, very necessary. Without it, all ratings would be changed - the two

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

2019-11-09 Thread Eric Abrahamsen
"Fraga, Eric" writes: > This looks quite useful and would be nice to have on Worg. Thanks. 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?

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

2019-11-08 Thread Eric Abrahamsen
"Thomas S. Dye" writes: > Aloha Eric, > > Good news. Yes, please feel free to update the Worg SQLite page. > > IIRC, you can get permission from Bastien to push changes and then you > can edit Worg at will. Cool! Bastien, can you help me get write access to Worg? Thanks, Eric

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

2019-11-07 Thread Thomas S. Dye
Aloha Eric, Good news. Yes, please feel free to update the Worg SQLite page. IIRC, you can get permission from Bastien to push changes and then you can edit Worg at will. All the best, Tom -- Thomas S. Dye http://tsdye.online/tsdye

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

2019-11-07 Thread Fraga, Eric
This looks quite useful and would be nice to have on Worg. Thanks. -- Eric S Fraga via Emacs 27.0.50, Org release_9.2.6-552-g8c5a78