Execture PVSW SPROC from batch file

[LesWright]

Hi,

I have used Btrieve and PVSW for many years, but just simple to complex queries.

I have created a SPROC that is an update, but want to execture this without having to log into PVSW Control Center to do so.

How can I get a batch file or something to do this?

Tx
Les

PVSW 8 WKGRP

Here is my SPROC:

CREATE PROCEDURE TEST1() AS

BEGIN

Update "INVENTORY" i SET i.wholesale = (SELECT i2.wholesale FROM "INVENTORY" i2 where i2.whse = '00' and i.code = i2.code),
i.bvrtlprice01 = (SELECT i2.bvrtlprice01 FROM "INVENTORY" i2 where i2.whse = '00' and i.code = i2.code) where i.whse <> '00' and i.code = (SELECT i2.code FROM "INVENTORY" as i2 where i2.whse = '00' and i.code = i2.code) ;

END;

 

[LesWright]

Figured it out from mirtheil's post at

http://www.tek-tips.com/viewthread.cfm?qid=910070

Thanks Mirtheil!
Les