I have a read-only view created for reporting purposes. I have some functions which are only run by the view and added them to a stored procedure. Runs fine from the project manager but they can't be found from within my app so I've added the functions to my procedure file.
My VFP5 manual says the stored procedures should only be used for giving default values and validating fields at field level.
Is there a way I can move my functions back to the database and not have them as separate programs?
Sarah King
pcpropertymanager.com