Calling a program for field validation

[shenlon]

How can I set up my app so that when I enter a number into a specific field (a VIN check in this case) the app calls a program I have written to validate the VIN?

 

[DSummZZZ]

You can either put the code in the valid event of that control, or make a UDF out of the program using the valid event.
In your startup prg or the form's INit event, add this:

SET PROCEDURE TO MyPrg ADDITIVE

Then in the valid method:

IF MyProc(cVIN)
   RETURN 1
ELSE
   RETURN 0
ENDIF

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[darrellblackhawk]

If the table is part of a database, you can also set field
level validation that calls on code in either a stored
procedure or an external program.

Darrell

 

[jimoo]

As we find with so things fox, there are many ways to do it. Others include.

1. Make it seperate prg (not part of the Set procedure code) and execute it in the valid.

Do myprog.prg


2. Make it a method on your session object.
goApp.myMethod()

3. If the rules are solid, unlikely to change, you can create a seperate dll file and call the method in the dll.



Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com