Re: SQR for PowerBuilder and iPlanet

[Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM>]

  Mike ,

   We successfully called an SQR from VB in the client server mode.  You
will have to have SQR availiable to the Client machine, you cant bundle it
with VB or PB , I think.
  But we simply used the command line statements , putting each part into a
variable then kicking of the API to run a shell commmand.  I dont know how
to do this in PB but I bet you can find out.    TRY www.planetsourcecode.com
for code on how to execute shell commands from PB.  GOOD Luck .. Let us know
your results


$A = "P:\FDM753\sqrbinw\SQRW.EXE"
$B = "C:\TEMP\USER\SQR\gls9002a.sqr"
$C = "FSRPT/fsrpt/fsrpt"
$D = "-ip:\FDM753\sqr\;"
$E = "C:\SCOTTs_DOCs\SQR's\GL_SQRs\"
$F = "-mp:\FDM753\sqr\allmaxes.max"
$G = "-fC:\Temp\"
$H = "-ZIFp:\FDM753\sqr\pssqr.ini"


  runsqr = $A + $B + $C + $D + $E + $F + $G + $H


  EXECUTE_SHELL_COMMAND (runsqr & sqrparameter)





-----Original Message-----
From: Mike Wheeler [mailto:Michael_Wheeler@PUTNAMINV.COM]
Sent: Tuesday, April 03, 2001 4:45 PM
To: SQR-USERS@list.iex.net
Subject: SQR for PowerBuilder and iPlanet


Hi,

I am researching what it will take to use SQR in a PowerBuilder 5.04
application.  The application will be running on a windows NT machine.  Is
it possible to trigger the SQR from the PowerBuilder app, and if so, how
would I do this.

I also am investigating how to use SQR with an iPlanet web-server.  I am
developing using Java 1.3.  Does anyone know how I can incorporate SQR in
my java code?  Or at least point me in a direction where I can read how to
do this.

Thanks,
Mike