HowardHammerman
Instructor
Hi gang,
I got called in to help a client who had a major application written by a programmer in DBASE 2000. The program works great, mostly. Unfortunately the programmer took sick and may be dying. I don't think he left the source code, at least I could not find the major *.prg files.
Here is the problem:
I got into DBASE using the command window and looked at the various tables. I made no changes to the tables.
We tried to run a routine that imported data from a remote location. During the input run the computer got hung. We terminated the program using the task manager. The client's operating system is Windows 2000.
When the program starts it runs a "startup" routine that
opens each of the eight tables using exclusive mode and then packs it. I was able to find the 'maintain.prg' that does that.
Now when we start the program the maintain program cannot find the table. When we click 'ignore' we get a chance to point to the table. We do so and then it says that the table is in use by another and it cannot pack because it cannot get exclusive use.
OK. I don't know what I did. I know messing with someone else's program is dangerous, but I did it.
I imagine that some flag is set that the tables are open. Is there a way to re-set them? We tried re-booting, no help.
Also, is the source code stored somewhere other than in *.prg files? Can we 'de-compile' the *.exe?
thanks a bunch!!! Howard Hammerman,
Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com
800-783-2269
I got called in to help a client who had a major application written by a programmer in DBASE 2000. The program works great, mostly. Unfortunately the programmer took sick and may be dying. I don't think he left the source code, at least I could not find the major *.prg files.
Here is the problem:
I got into DBASE using the command window and looked at the various tables. I made no changes to the tables.
We tried to run a routine that imported data from a remote location. During the input run the computer got hung. We terminated the program using the task manager. The client's operating system is Windows 2000.
When the program starts it runs a "startup" routine that
opens each of the eight tables using exclusive mode and then packs it. I was able to find the 'maintain.prg' that does that.
Now when we start the program the maintain program cannot find the table. When we click 'ignore' we get a chance to point to the table. We do so and then it says that the table is in use by another and it cannot pack because it cannot get exclusive use.
OK. I don't know what I did. I know messing with someone else's program is dangerous, but I did it.
I imagine that some flag is set that the tables are open. Is there a way to re-set them? We tried re-booting, no help.
Also, is the source code stored somewhere other than in *.prg files? Can we 'de-compile' the *.exe?
thanks a bunch!!! Howard Hammerman,
Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com
800-783-2269