>When running the VFP application in Windows 7 on Novell Client 2, Zenworks 7, I am getting a blue screen sometimes when a sql insert statement is trying to execute. Sometimes the computer freezes and you can not even do a ctrl-alt-del. You have to turn the computer off. When the problem occurs, it is always during the insert statement in different forms.
>
>Previously, I had the insert in the referential integrity set to restrict for many of the tables in the dbc. Since this problem occurred, I have since changed the insert in the ri to ignore. Even after doing this, we are still getting the blue screen.
>
>The same VFP application runs fine in Windows XP.
>
>I have reindexed all the tables. I also deleted all the index tags and recreated them for all the tables in the dbc. This problem has just started occurring. Prior to this the application ran fine in windows 7.
A few ideas:
- If you're accessing data tables and index files on a network server or otherwise over the network, try working against a copy of the tables on your local C: drive
- Temporarily disable any real-time antivirus scanning on your local computer
- Create a bootable CD or USB stick and test your RAM memory with MemTest86+:
http://www.memtest.org/- Make sure your hardware drivers are up-to-date and exactly correct for your hardware, especially video adapter. Printer drivers are also sometimes problematic but if you're hitting the problem on a SQL command I don't believe that would be your issue
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