Hi,

thank you very much for your explanations about properties inheritances, I didn't know much about them.

So I managed to solve my problem buy using a property drawer ~header-args:sql:~ so it doesn't override my ~#+PROPERTY~ that I set globally.

I'll give some tries with org-eldoc, seems an interresting package I didn't know about.

Thank you very much again for your help!

2017-06-30 13:46 GMT+09:00 Kaushal Modi <kaushal.modi@gmail.com>:
On Thu, Jun 29, 2017 at 11:30 PM cedric simon <simonced@gmail.com> wrote:
Hi everyone,

I work with org mode for writing all my documentation and use source code blocks extensively.
I don't know if I found a bug or something, but I encounter a strange behavior with SQL source blocks.
Despite the settings I apply, they are always evaluated if I have ":exports both" set.

I made a reproducible document, it's on gist, if you have time please have a look:

From what I understand, the values you set in "#+PROPERTY: header-args" is not inherited further down once you use a ":header-args:" property drawer (even when org-use-property-inheritance is set to t).

I made up an elaborate example and have put it up here[1], that explains when the header-args values set in #+PROPERTY or PROPERTY drawer are effective. 
 
In addition, using the org-eldoc package[2] (in Org contrib) helps a lot in seeing the effective header-args values for a given source block. Just put the cursor on the BEGIN_SRC line and you will see it all :)

Example:

image.png

 
--

Kaushal Modi




--
Cedric Simon