FPW 2.6 in Win2000 , W98 environmemnt (terminating the program )

[santhu]

Dear friends , Please look in to the following problem and I would appreciate if anybody could help me out.

My application is developed in FPW 2.6 , running on a Win2000 advanced server , clients are W9x and Win2000 .

The issue is , the application is teminating automatically , or sometime it get stuck (when press CTRL+ALT+DEL gives the message that 'program not responding). This is not happening always and also not from a perticular option as well , for eg. some time after printing two three reports this may happen , the user has to reload the appication each time.
This occures two or three times (some days it is more ) daily with each user depends on the volume of usage ie. different options and printing being used.

Thanking You

Santhu

 

[dgrewe]

To help us out a little, can you answer a few questions first.
1. How old in this application? (in years)
2. Has it run before under other operationing systems (NT4, NetWare, etc) with no problems?
3. Does it run OK in a Standalone mode on a local computer not connected to a network?
4. When was the last time you deleted all the indexes and rebuild them?

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[santhu]

Thank You Very Much Mr.David for your response to FPW issue I posted ,

1, Application is 6 year old , it was started with Windows 3.1

2 . Application was running under Netware first and changed to NT4 later . With NT4 I had this problem very
rarely , not as frequent as now .
3. Stand alone it works without any problem as far as I checked .

4. I Never completely remove all index and recreate , I am using CDX , and some times use reindex command to rebuild indexes.

Thank You again and looking forward to get a solution

Santhu

 

[dgrewe]

Since the application ran fine under 3.1 and for the most part under NT. I have a feeling you might gave a header problem in your DBF, FPT and CDX files. Remember FPW2.6 is a 16 bit application and does not know what to do with the HPFAT used on Win2000. Needless to say Win2000 has a low tolerance level for 16bit files also.

I would start by looking for the COPY command in all your programs. One trick to speed up application was to copy databases to local drives, do a lot of heavy work and then copy the dbf back to the server. Or copy the DBF to a local drive , reindex it and copy the dbf and CDX back to the server. When you do this you change the header type of the file when the FAT (File Allocation Tables) of the two systems are not the same.

I would then find any case where a DBF is opened exclusive and work on the DBF is performed off the servers hard drive.

If you find any occurance of these two items above, I would
1. reprogram the application so all work that requires the DBF to be opened exclusive to be performed on the servers drives.
2. or upgrade all your computers to the same type operating system as your file server.
3. or do both

Then I would record all the indexes on the DBF's , deleted the CDX file, open the DBF exclusive, Fox copy the DBF to another location on the servers hard drive, use that temp file exclusive and fox sort it back to the original location, and recreate all the CDX files.

You will never get the problem to go away because of MicroSofts FAT's.
At the very least I would recommend you do the following:
1. Get a copy of VFP.
2. Convert all the DBF's to VFP free tables.
3. Convert/redesign all your report forms to VFP.
4. Run your application under VFP after you do the converts.

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[santhu]

Thank You Mr.David W. Grewe

When Convert intro VFP , does it required to redesign all forms or only reports to be converted ?


Thanking You

Santhosh

 

[dgrewe]

VFP will run all FPW2.6 code. The only thing you have to convert is the Database and the report forms. The windows anf screens do not have the nice clean new look if the visual forms, but they work.
This fix will stop you problem until you can redesign/rewrite it in VFP. David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644