Re: Integrating SQL Report writer & Forms

andyj_at_hfl.tc.faa.gov (andyj) writes:

>This works....HOST('RUNREP REPORT UN/PW PARAM = VALUE')
 

>This doesn't... HOST('RUNREP REPORT UN/PW PARAM =:BLOCK.VALUE')
 

>Respond to AJEFFERY_at_SMTPLINK.CTA.COM

Try declaring a local variable, putting the runrep call and all parameters in it, then calling that from the HOST command.

The following pseudo-example works for me:

declare

   work_text(2000);

begin

   work_text := 'runrep report un/pw param = ' || :block.value;    host(work_text);   

end;

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)