Windows 7 Blue Sceen When Running VFP 9 During Insert Statement

[lr145]

When running a VFP 9 application on a windows 7 professional system it seems that sometimes when the application tries to perform an sql insert record into the table from within a form, I am getting a blue screen (memory dump). Other times windows 7 freezes completely and you can not even do ctrl-alt-del to get to the task manager. I do not have any problems running this same application on Windows XP. The table I am trying to insert the record in has the referential integrity set up on the insert in the database container.

Any suggestions?

 

[DSummZZZ]

Your problem is most likely permissions or a corrupted index file.
First I would check to make sure there are full permissions set wherever the tables are located, be it some data folder or virtual store.


-Dave Summers-

Even more Fox stuff at:

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

 

[lr145]

Thanks for your reply! Would Foxpro indicate if the index file was corrupted? I have not gotten any corrupted index files messages through Foxpro. I am just trying to determine which index file could possibly be corrupted. Thanks.

 

[Mike Lewis]

I can't imagine that there's anything special about the INSERT command that would cause this behaviour.

Are you sure the crash always occurs at exactly that point? Have you tried removing teh INSERT and seeing of the crash still occurs?

That said, I can't really suggest anything else. Dave might be right about the corrupted indexes or permissions.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[JRB-Bldr]

The Windows Blue Screen Of Death is most often caused by hardware problems within the workstation. Most notably over-heating and/or memory card problems.

I cannot say about Win 7 if this is the same or not, but I would guess that it was. Nor can I say if this is the situation that you are experiencing, but historically I have personally seen it to be the cause most times.

However, if you should think that this is somehow related to the VFP application, then you should execute the code in the Development environment and with SET STEP ON, executing the code line-by-line. If, within the TRACE Window, you see this problem occurring at a particular line of code, then you can investigate things like are mentioned above.

But since you say " Other times windows 7 freezes completely and you can not even do ctrl-alt-del to get to the task manager.", I'd guess that the real cause of the problem might reside elsewhere.

Good Luck,
JRB-Bldr

 

[Jerim65]

Perhaps you could run your application on another PC with Win 7 installed?

If you upload a zip with enough files to allow it to run I could run it here and see the result.

My public folder for FTP anonymous is

twohundredandthree dot onehundredandtwentytwo dot 240.185

regards

Coldan