Update: turns OUT that the .FRX was not in the path (thanks Al!) yes, "File not found" means the file cannot be found. What threw me off the track was that the error appeared ?during? (but actually immediately after) the data was committed, and the framework reported the error line as in the:

UPDATE sa!administration SET adm_lastssbenefitcheckrun=v_administration.adm_lastssbenefitcheckrun,adm_lastssbenbankacctfk=v_administration.adm_lastssbenbankacctfk,adm_lastssbenefitcheckrundescription=v_administration.adm_lastssbenefitcheckrundescription WHERE adm_pk=OLDVAL('adm_pk','v_administration')

line of code.

Normally I run reports via VMP, and it gives me a "nice" error message saying the FRX is missing.

This report is run via a REPORT FORM ... command, and, yes, the file WAS missing...READ THE ERROR MESSAGE!!!

Thanks for your input....it feels great to have you behind me...I'm on an island a thousand miles from home....

J

PS FYI, the UPDATE command is deep in the bowels of the VMP framework - I'm just doing a call to it's "SaveAction" method.


>[sorry if this is a repost...i have a flaky connection...]
>
>I am at a client site.
>
>We are trying to print checks. They have changed from using an Epson printer to laser checks.
>
>I compile check printing data into about 30 views. Then comit all the data at once. The code works on my computer WHEN I'M RUNNING IN VFP.
>
>If i run the exe, however, from Windows Explorer, when the views are being committed, i get an error: "FILE DOES NOT EXIST."
>
>Error information tells me that the error is on the line following line:
>
>UPDATE sa!administration SET adm_lastssbenefitcheckrun=v_administration.adm_lastssbenefitcheckrun,adm_lastssbenbankacctfk=v_administration.adm_lastssbenbankacctfk,adm_lastssbenefitcheckrundescription=v_administration.adm_lastssbenefitcheckrundescription WHERE adm_pk=OLDVAL('adm_pk','v_administration')
>
>I have looked and looked at this. yes the Administration.DBF file exists. It has a SINGLE record.
>
>All fields are updateable in the view v_Administration.
>
>As i said it works when running IN VFP, but not from an exe outside of VFP...any input/help is MUCH appreciated!
>
>Thanks, J