Re: Host command in SQLFORMS3.0

Johanne Duhaime (Johanne_Duhaime_at_IRCM.UMontreal.CA) wrote: : Good day  

[Quoted] : Anyone familiar with the HOST command?  

: I cannot compile the following:
: host({'toprint' | NAME_IN('{:app.app_numero}')});  

: where I want to execute the script toprint with the value in the field
: :app.app_numero. (I took the example in the sqlforms but it does not
: work).

I think it will work if you remove the curved brackets.

I recommend using the no_screen option for a host command like this. You may also want to append a '&' to the command string. That will make the command run as a background process - if your os is some kind of unix.

: Thank you in advance.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


+   Christian Mondrup                                                     +

+   Computer Programmer                                                   +

+   Scandiatransplant, Skejby Hospital, University Hospital of Aarhus     +

+   Brendstrupgaardsvej                                                   +

+   DK 8200 Aarhus N                                                      +

+   Denmark                                                               +

+                                                                         +

+   Phone:   +49 89 49 53 01                                              +

+   Telefax: +45 89 49 60 07                                              +


+   E-Mail:  scancm_at_biobase.dk                                            +


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++