#+TITLE: Tangling process ignores LOB? #+DATE: 2010-12-07 #+LANGUAGE: en_US
#+BABEL: :cmdline -S server -U user -P password -d database -n -w 700 :results output :exports both * Abstract References to named code blocks located in a LOB file seem to be ignored by the tangling process. * Example ** Common code These 2 SQL code blocks are, and will be, reused all over the place: #+srcname: set-count-off #+begin_src sql :eval never -- no longer display the count message SET NOCOUNT ON #+end_src #+srcname: defvar-now #+begin_src sql :eval never DECLARE @now smalldatetime SET @now = CONVERT(smalldatetime, CAST(YEAR(GETDATE()) AS char(4)) + '-' + CAST(MONTH(GETDATE()) AS char(2)) + '-' + CAST(DAY(GETDATE()) AS char(2)) + ' ' + CAST(DATEPART(hh, GETDATE()) AS char(2)) + ':' + CAST(DATEPART(mi, GETDATE()) AS char(2)) + ':' + '00', 120) -- ODBC canonical #+end_src ** Specific code For example, I use them here: #+begin_src sql :engine msosql :noweb yes <<set-count-off>> <<defvar-now>> SELECT TOP 5 @now AS now FROM table #+end_src #+results: | now | | ------------------- | | 2010-12-07 15:14:00 | | 2010-12-07 15:14:00 | | 2010-12-07 15:14:00 | | 2010-12-07 15:14:00 | | 2010-12-07 15:14:00 | | | And it works (see the /results/ table). But... * Problem If I put the *common code blocks* into some LOB file (i.e., I move them out of this file) and ingest it, then the specific code does not properly run anymore. In other words, it seems that the tangle process does not take into account the code blocks located in the LOB. 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