From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?utf-8?Q?S=C3=A9bastien_Vauban?= <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
Subject: [Babel] Tangling ignores LOB file?
Date: Tue, 07 Dec 2010 15:17:18 +0100
Message-ID: <80zkshfz0x.fsf@missioncriticalit.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode-mXXj517/zsQ@public.gmane.org>
List-Help: <mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org

#+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 :resu=
lts 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 =3D 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

--=20
S=C3=A9bastien Vauban


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