Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILE DOES NOT EXIST - I'm desperate
Message
From
19/04/2007 04:16:16
 
 
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:
01217630
Views:
16
This message has been marked as the solution to the initial question of the thread.
>[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

What is SET("PATH") in your dev environment? If there's a path in your dev environment that's not also set in your .EXE that could explain it.

SWAG, but you never know - If you're updating from cursors, you might want to make sure you're creating them with a NOFILTER clause.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform