Form freezing system (System - Not responding)

[fmasin]

Hi,

I have a multi-tab form. When I log into the system, the first form loads fine. The main form loads fine too. However, when I click one of the tabs on the main form, everything just freezes - when I go into the Windows task manager, I get the message - "System - Not Responding".

I have looked at the source code but can not tell what the problem might be...Please, could someone kindly assist.

Thanks and regards,

Francis

 

[fmasin]

Sorry - my system runs VFP version 7...

Thanks and regards,

Francis

 

[bborissov]

First try to RECOMPILE your form.
If this not help, open form as a table, pack it reindex, pack memo (DO A BACKUP first).
Delete FOXUSER*.* in the current folder and/or in HOME() dir of VFP.
If this not help, I don't know. It is very difficult to say what happens not knowing your code.
Please open Class Viewer -> Open form, click on View Source code, Copy it and paste it here between
[ code ] [ /code ] tags (w/o spaces)

Borislav Borissov

 

[fmasin]

Borislav,

Many thanks indeed for your reply. I have not used VFP in a long time and I have a bit rusty - could you kindly give some guidelines step by step on how to do the above...

How do I recompile a form?
How do I open a form as a table?

Thanks and regards,

Francis

 

[bborissov]

1. Recompile your form:

COMPILE FORM FullPathToYourForm

2. Open as a table (Make a backup first)

USE FullPathToYourForm.SCX EXCLUSIVE
PACK
PACK MEMO
REINDEX
USE
COMPILE FORM FullPathToYourForm

Borislav Borissov

 

[fmasin]

Borislav

I have tried the above procedure and nothing happens...still getting the same problem.

What is funny is: when I change the Data source to the Demo environment, everything works fine. When I revert to the Live environment things start falling apart! I copied the LIve database to a local machine and testing the form it worked fine.
The live database is running on the server on the local intranet. I thought that some of the files were too large to cope with the traffic - so deleted some unwanted records from the last two years - but still same problem. What could be going wrong?

Thanks and regards,

Francis

 

[bborissov]

It is hardly to say. Did yo have many controls on that form?
Did you use SQL Statements for RecordSource? May be the Data you want to show is too big. Is there some AciveX controls you fill programaticly (like TreeView)? How big is your PATH?
Try to change it to something smaller i.e.
SET PATH TO OnlyToYourDataBaseResidence ,Look in the system path also, VFP Search the files in whole PATH environment.
Try to remove controls one by one to see which cause the problem.
DEBUG your form.

In the load Event of the form put:
SET ASSERTS ON
ASSERT .f.
and the debug the form step by step.

Unfortunately I use VFP 8 & 9 so I think I couldn't be in help if you send me the form with the data (if the data is is not confiodential of course), but we can try

email: borisb at mail dot bg,


Borislav Borissov