Creating a VFP application as a service:

Sometimes it’s useful to make your application run as a service. A service can run without any user logged in, can automatically start upon reboot, and can survive user logoffs. It can also run as a different user with different access rights.

Normally, Creating a service is fairly complex, but creating a VFP application as a service is fairly straightforward, thanks to a pair of tools called INSTSRV.EXE and SRVANY.EXE that come with the Windows Resource Kit. INSTSRV.EXE takes 2 parameters: the name of the new service to install, and the full path to the SRVANY.EXE file.

For example, to create a service called “VFPSrv”, I ran this on my Windows XP machine:

C:\Program Files\Windows Resource Kits\Tools>instsrv VFPSrv "d:\Program Files\Windows Resource Kits\Tools\srvany.exe"

SRVANY provides all the main work to pretend to be a service, and it will look in the registry to find what EXE file to run to implement the service. The EXE name, the starting directory, and any optional parameters are found in the registry.

Copy/paste the following to a file named VFPSRV.REG (change the paths as necessary: note the double back-slashes) and dbl-click the .REG file to add these entries to the registery.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VFPSrv\Parameters]

"AppDirectory"="d:\\fox90\\test"

"Application"="d:\\fox90\\test\\vfpsrv.exe"

"AppParameters"="myparm1 myparm2"

You can use the VFP command window to control the service:

!net start vfpsrv

!net stop vfpsrv

or the DOS command window:

net start vfpsrv

The sample service code below executes a file called “vfpsrvrtn.prg” when the timer fires. However, this code is not built into the EXE. This means you can change the service’s behavior dynamically, without having to stop/rebuild/start the service.

The code executes the timer event every 5 seconds, aligned to the 5 second real time clock (so that it occurs at exactly :00, :05, :10, … seconds past the hour).

If you run the prg below, it will run as a normal VFP PRG, but it will also build VFPSRV.EXE.

To start it as a service, use the control panel->Administrative Tools->Services or “net start vfpsrv”

Open the log file in an automatically refreshing editor, such as Visual Studio, from another machine and then log off the main machine. You can still hear the beeps and see the log file changing when no user is logged in.

(using older versions of SRVANY or on older versions of Windows, you may need to use SYS(2340) )

*Save this content to a file called VFPSRV.PRG

LPARAMETERS parm1,parm2

CLEAR

* https://msdn.microsoft.com/library/default.asp?url=/library/en-us/tools/tools/service_control_utility.asp

* https://www.microsoft.com/msj/1097/WINNT.aspx

*To get SrvAny and SrvInst: go to https://www.microsoft.com/downloads, enter Windows 2003 Resource Kit Tools in the Keywords field, and click Go.

*Then, click the Windows Server 2003 Resource Kit Tools Download button at the Windows Server 2003 Resource Kit Tools

*Web page to download rktools.exe-which contains the most recent versions of Instsrv and Srvany-and run the executable to install the tools on your system.

#define TIMERINT 5 && # of seconds for timer interval. Also syncs to TIMERINT seconds for time of day

PUBLIC oService

oService=NEWOBJECT("vfpsrv")

oService.logstr("Starting Service: got some params: "+TRANSFORM(parm1)+" "+TRANSFORM(parm2))

IF _vfp.StartMode>0 && if we’re running as an EXE

      READ events && message loop

ENDIF

*Create VFPSRVRTN.PRG that just beeps

SET TEXTMERGE TO vfpsrvrtn.prg

      \LPARAMETERS oTimer,oService

      \oService.logstr("")

      \Messagebeep(0)

SET TEXTMERGE TO

*RETURN

BUILD PROJECT vfpsrv from vfpsrv

MODIFY PROJECT vfpsrv nowait

STRTOFILE("screen=off"+CHR(13)+CHR(10),"config.fpw") && to hide the VFP runtime desktop

_vfp.ActiveProject.Files.Add("config.fpw")

_vfp.ActiveProject.Close

BUILD EXE vfpsrv FROM vfpsrv

ERASE config.fpw

DEFINE CLASS vfpsrv AS form

      PROCEDURE Init

            this.logstr(CURDIR())

            DECLARE integer MessageBeep IN WIN32API integer

            this.AddObject("mytimer","mytimer")

            WITH this.mytimer

                  .enabled=.t.

                  .interval=1000 && start it in a sec

            ENDWITH

      PROCEDURE Destroy

            ?PROGRAM()

            MessageBeep(32)

      PROCEDURE logstr(str as String)

            str=TRANSFORM(DATETIME())+" "+str+CHR(13)+CHR(10)

            ??str

            STRTOFILE(str,"c:\vfpsrv.log",.t.)

ENDDEFINE

DEFINE CLASS mytimer AS timer

      PROCEDURE timer

            DO ("vfpsrvrtn" ) with this,oService

            CLEAR PROGRAM

            dtNow=DATETIME() && read datetime() and seconds() close to the same instant

            nsec=SECONDS()

            nsec=CEILING((nsec+.5)/TIMERINT)*TIMERINT && target is # of seconds since midnight + a little for calculation time

            dtTarget=DTOT(DATE())+nsec

            this.interval=(dtTarget-dtNow) * 1000

ENDDEFINE

45776