Hi Jil,
The OLDVAL usage struck me here as a bit strange. I would try
pcAdm_Pk = v_Administration.PK
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 = ?m.pcAdm_PK
And I may also use variables for all other fields in Update, e.g.
UPDATE sa!administration ;
SET adm_lastssbenefitcheckrun= m.lcadm_lastssbenefitcheckrun, ;
adm_lastssbenbankacctfk= m.ladm_lastssbenbankacctfk, ;
adm_lastssbenefitcheckrundescription=m.lcadm_lastssbenefitcheckrundescription ;
WHERE adm_pk = ?m.pcAdm_PK
>[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
If it's not broken, fix it until it is.
My Blog