Prev: Management wars
Next: COPY statement
From: PAM. on 13 Sep 2005 23:22
Not sure if this place is the right place but it's all I've got :-(

I'm trying to set up a command in SPFPC so that when I type SQL, it will
invoke SQL-server 2000's isqlw.exe
Not I have it working OK. However, it's in foreground and I'd like it in
background so I can run other apps.
My command line is
SELECT PGM("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe")

I've done this before and got it working (a couple of years ago on another
PC), and I can't seem to think how to do it now.

Any help would be appreciated.

Peter


From: Binyamin Dissen on 14 Sep 2005 09:00
On Wed, 14 Sep 2005 15:22:56 +1200 "PAM." <JunkMail(a)FishnChips.com> wrote:

[Posted and mailed]

:>Not sure if this place is the right place but it's all I've got :-(
:>
:>I'm trying to set up a command in SPFPC so that when I type SQL, it will
:>invoke SQL-server 2000's isqlw.exe
:>Not I have it working OK. However, it's in foreground and I'd like it in
:>background so I can run other apps.
:>My command line is
:>SELECT PGM("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe")
:>
:>I've done this before and got it working (a couple of years ago on another
:>PC), and I can't seem to think how to do it now.
:>
:>Any help would be appreciated.

SELECT PGM("COMMAND /C C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\isqlw.exe")

?

--
Binyamin Dissen <bdissen(a)dissensoftware.com>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.
From: PAM. on 14 Sep 2005 16:30
"Binyamin Dissen" <postingid(a)dissensoftware.com> wrote in message

> SELECT PGM("COMMAND /C C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\isqlw.exe")

Nope. However, checking some documentation I had at home, I found this,
which works

SELECT BACKPGM("C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\isqlw.exe")

I'm sticking this in here so I can search through Google later on if I need
to do this again
:-)

Cheers
Peter


 | 
Pages: 1
Prev: Management wars
Next: COPY statement