Hello,
Here is the Org file is use to illustrate my saying:
--8<---------------cut here---------------start------------->8---
* 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
--8<---------------cut here---------------end--------------->8---
Here the "problems" (details, though) I've observed:
- srcname must be in column 0 for the highlighting to be correct.
- *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:
--8<---------------cut here---------------start------------->8---
-- generated by org-babel-tangle
-- [[id:d7557df2-6921-428f-8433-68fad551abec][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 << OK
pfiAuth = 1 << not
AND SUBSTRING(etpCPNum, 1, 3) = "111" << not
ORDER BY pfiID
-- CP111.sql ends here
--8<---------------cut here---------------end--------------->8---
Best regards,
Seb
--
Sébastien Vauban
_______________________________________________
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
