Hello,

The following code:

#+name: dl
#+begin_src sqlite :db 250602.db :var el="Fe"
  select 3*(select avg(s_b) from bremen_$el)/(select I_std from wds_elements 
where Element='$el') * (select mass from wds_elements where Element='$el');
#+end_src

works as desired when called from a table like this:
| Element | oxide  d.l.        |
|---------+--------------------|
| Fe      | 0.0134662859436555 |
#+tblfm: @2$2='(org-sbe "dl")

It does not work when called thus:
| Element | oxide  d.l. |
|---------+-------------|
| Fe      | #ERROR      |
#+tblfm: @2$2='(org-sbe "dl" (el '@2$1'))

I have tried various ways of quoting the reference to the cell in column
1 to no avail.

Could some one please tell me the correct invocation?

Thanks,
Roger
GNU Emacs 30.1 (build 2, amd64-portbld-freebsd13.4, GTK+ Version
3.24.48, cairo version 1.18.2)
Org mode version 9.8-pre (release_9.7.20-241-g3218d3.dirty @
/home/rmason/.emacs.d/org-git/lisp/)


Reply via email to