Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a loading message for a form...
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00485020
Message ID:
00487213
Views:
9
Kevin,
The rv's for an as400 ARE slow to load. Each one can take between 5 -20 seconds even if I try it as you suggested from the command line with the nodata command. Some the reports I create require 12-14 views to get all the information needed. Part of the reason the connection is slow is that the as400 programmer has put our ODBC connection to a batch status so that we don't interfere with active users. This was necessary because when I originally starting doing these reports the ODBC would grab all the as400 resources and freeze the user input screens. With batch status no one notices that the reports are being run. I now have 7 users that access these reports. Some are here in our LA office, and some coming in across a frame relay from Nevada (the as400 access across the frame relay is reallllllly slowwww.)

I haven't worried about the delay before because instead of using bizobj's I was calling the views from a program triggered by the click event, so the delay was after the user interaction. Now I'm converting the reports to an MM project and giving the views bizobjs & data sessions to manage them. In the project they are loading without data (the MM default) and when I need them I requery.

These views aren't being edited, they're being used to gather information for reports. Would it help if I put an event object for the reports on the form and then had the event object load the bizobjects after the user has entered the required parameters, or does the event object call the bizobj's when the form loads?...which would mean the user delay is still there.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform