Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILE DOES NOT EXIST - I'm desperate
Message
 
 
To
19/04/2007 03:51:46
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01217628
Message ID:
01217723
Views:
7
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
Previous
Reply
Map
View

Click here to load this message in the networking platform