Re: Re: [babel] Tiny "problems"

["Eric Schulte" <schulte.eric@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 1587 bytes --]

Sébastien Vauban <wxhgmqzgwmuf@spammotel.com> writes:

> Hi Eric,
>
> "Eric Schulte" wrote:
>> Sébastien Vauban <wxhgmqzgwmuf@spammotel.com> writes:

[...]

>>> - *after* =C-c '= forth and back, all the blank lines in my source block (in
>>>   my example, the one between "SET NOCOUNT ON" and "SELECT TOP 10") are filled
>>>   with an amount of whitespaces (and, in my Emacs config, highlighted as
>>>   useless spaces).
>>>
>>> - the condition block is not indented properly in the tangled output file;
>>>   only the first line is:
>>>
>>
>> Maybe the above two issues could be fixed by setting the
>> `org-src-preserve-indentation' variable's value to t. Since I only need this
>> in some org-mode buffers I set it as a buffer local variable by placing a
>> line like the following at the top of these buffers.
>>
>> # -*- org-src-preserve-indentation: t -*-
>>
>> again this should/will be in the documentation somewhere...
>
> That's not it (already tried before posting). That variable, when set, makes
> Org removes the minimum common number of whitespaces.
>
> That does not fix the problem of useless whitespaces in blank lines, and has
> no impact on the indentation of tangled blocks:
>

Hi Seb,

I misunderstood your indentation issue earlier.  Currently I don't think
we support indentation to the level of the noweb reference in the
original source-code block.  At first glance that does however seem to
be a better default behavior.  I'll look into this.  As a work-around
you may want to try the attached version of your file


[-- Attachment #2: seb.org --]
[-- Type: application/octet-stream, Size: 734 bytes --]

# -*- org-src-preserve-indentation: t -*-

* Test file

  Here is the main SQL script.

#+srcname: CP111.sql
      #+begin_src sql :tangle CP111.sql
          -- no longer display the count message
          SET NOCOUNT ON
          
          SELECT TOP 10
                 etpNom,
                 etpID,
          FROM etp
          WHERE etpID
              IN (SELECT actID
                  FROM actions
                  WHERE actID = 338)
              AND
          <<Condition>>
          ORDER BY pfiID
      #+end_src

  And here the extra condition:

#+srcname: Condition
      #+begin_src sql
              -- extra condition
              pfiAuth = 1
              AND SUBSTRING(etpCPNum, 1, 3) = "111"
      #+end_src

[-- Attachment #3: Type: text/plain, Size: 43 bytes --]


which results in this following sql file


[-- Attachment #4: CP111.sql --]
[-- Type: application/octet-stream, Size: 559 bytes --]

-- generated by org-babel-tangle
-- [[file:~/Desktop/seb.org::*Test%20file][CP111.sql]]
          -- no longer display the count message
          SET NOCOUNT ON
          
          SELECT TOP 10
                 etpNom,
                 etpID,
          FROM etp
          WHERE etpID
              IN (SELECT actID
                  FROM actions
                  WHERE actID = 338)
              AND
          -- extra condition
              pfiAuth = 1
              AND SUBSTRING(etpCPNum, 1, 3) = "111"
          ORDER BY pfiID
-- CP111.sql ends here

[-- Attachment #5: Type: text/plain, Size: 14 bytes --]


Best -- Eric

[-- Attachment #6: Type: text/plain, Size: 201 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode