Deleted Records in Foxpro 2.6a

[reidkr]

I have an application running under Foxpro for Windows 2.6a that manages inventory for a company. In the config.fpw file I have set deleted on, but the deleted records still appear in the reports. If I browse the table the deletion mark shows up beside the record and it is visible no matter whether deleted is set to on or off. Is this a bug in Foxpro for Windows 2.6a? Is there a way around it without packing the table each time someone requests a report on the table?

 

[DSummZZZ]

I have to chuckle a little. Fox 2.x has been around for years. A bug like that would most certainly not have just arisen.

Are you saying your config file reads that way?

SET DELETED ON

I believe it shoud read

DELETED=ON

However, if the config file is syntactically correct, there is either something in the application itself changing that setting or the app isn't seeing your config file.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[reidkr]

My config.fpw reads DELETED=ON and display status shows that deleted is on but the browse command shows deleted records with the deleted indicator highlighted. I haven't been able to find any line in the application that changes the status of the deleted command. When I start Foxpro and bypass the application and go straight to the command windows the display status shows that deleted is on but my deleted records still appear.

 

[cricket]

Are you using a VIEW as in SET VIEW TO myview?

If so, go to WINDOW -->VIEW and check the ON/OFF tick boxes.
If the DELETED box is unticked, it will override all previous setting.

Use the Debug window when running your program (SET DISP to VGA50) and key in the word DELETED() in the left window. You can then see if the value is switching and where in your program it is switching it.