Le 02/02/2014 21:09, Thomas S. Dye a écrit : > Aloha all, > > I'm expecting column names in the "foo( )" part of the INSERT statement. > > I've done my best to understand > http://orgmode.org/worg/org-tutorials/multitarget-tables.org.html but > appear to have failed. > > Can someone help? > > *** Experiment with orgtbl-sqlinsert > > #+name: test-table > | one | two | > |-----+--------| > | 1 | Buckle | > | 2 | Shoe | > | 3 | Open | > | 4 | Door | > > #+name: test-bed > #+header: :var x=test-table > #+begin_src emacs-lisp > (require 'orgtbl-sqlinsert) > (orgtbl-to-sqlinsert x '(:sqlname "foo" :fmt (1 "%s"))) > #+end_src > > #+results: test-bed > : BEGIN TRANSACTION; > : INSERT INTO foo( ) VALUES ( 1 , 'Buckle' ); > : INSERT INTO foo( ) VALUES ( 2 , 'Shoe' ); > : INSERT INTO foo( ) VALUES ( 3 , 'Open' ); > : INSERT INTO foo( ) VALUES ( 4 , 'Door' ); > : COMMIT; > > All the best, > Tom Hi Thomas.
I don't understand this behavior yet. But here is a workaround: try the #+ORGTBL: SEND feature: 1- Add a #+ORGTBL: SEND line 2- Add a BEGIN RECEIVE ORGTBL block 3- Type C-c C-c with cursor on the first pipe of the table --8<--------------------------->8-- #+ORGTBL: SEND faraway orgtbl-to-sqlinsert :sqlname "foo" :fmt (1 "%s") | one | two | |-----+--------| | 1 | Buckle | | 2 | Shoe | | 3 | Open | | 4 | Door | ;; BEGIN RECEIVE ORGTBL faraway BEGIN TRANSACTION; INSERT INTO foo( one, two ) VALUES ( 1 , 'Buckle' ); INSERT INTO foo( one, two ) VALUES ( 2 , 'Shoe' ); INSERT INTO foo( one, two ) VALUES ( 3 , 'Open' ); INSERT INTO foo( one, two ) VALUES ( 4 , 'Door' ); COMMIT; ;; END RECEIVE ORGTBL faraway --8<--------------------------->8--