Records Locking up Compter from desktop shortcut.

[DaleFrench]

Hello, I have unzipped some data sent to me by one of my customers. Some of the records Lock the computer up when printing any reports for that particular record. The strange thing is When I run the program from my Foxpro 2.6 for windows, the same records will run fine. When I run the program from a desktop shortcut they lock up. The start in directory and the 'set default to' directories are the same. I tried to use different executables that use the data the same way and still same results. I tried foxfix and deleting the indexes and recreating them. My question Whey are the same records not locking up when I am running the program from Foxpro 2.6 for Windows?

Any help would be great appreciated. And Thanks in advance.

 

[rgbean]

First, are you sure you are using the same update as their runtime files? (e.g. 2.6 vs. 2.6a) Are your MEMLIMIT and MVCOUNT values the same in the respective CONFIG.FPW files? Are you using the same OS? (Are the FILES and BUFFERS settings equivalent?) Are they using data off a file server vs. you working on a local drive?

There are a lot of possibilities for "differences".

Rick

 

[DaleFrench]

Rick, Thanks for the reply. Let me explain my question further.

First this is all happening on my local machine(non networked) with data that was sent to me. I have a directory called c:\base\wc in which all the data, the executable, and other files are stored. I mapped a shortcut on the desktop of my windows xp machine to that executable(eda_wc.exe). When I double click on that shortcut to access the program is when these (certain) records are locking up during a printing of a report. There is no SQL involved, it is just printing out the feilds of that record.

Second, the config.fpw file in my c:\fpw26 directory and my c:\base\wc directory are exactly the same.

Lastly, when I open up my Foxpro 2.6a program. And do 'set default to c:\base\wc' from the command window and then type 'do eda_wc(the program)' to access the program, While I am in that mode running the same program from the same directory with the same data, the records will not lock up. My question is why? And how can I resolve this?

Thanks again for your response )

Dale

 

[rgbean]

First, I'd make sure your shortcut explicitly uses (points at) the proper config file. i.e.:
c:\base\wc\my.exe -cc:\base\wc\config.fpw

There are ways that without this explicit reference, FP can find and use another CONFIG.FPW file. I always include an information screen that shows the location of all the critical files/paths in use.
SYS(2019) - Config File
SYS(2005) - Resource File (FOXUSER)
SYS(2004) - Foxpro Start Directory
etc.

Rick