<< I know that the database design is horrible >>
If you apply the same model to SQL Server, you will also have less than adequate results on occasion.
If it's horrible now, fix it.
==Carl
Carl Warner
VFUG Officer, http://vfug.org:8080/
MS MVP, VFP
FoxCentral http://www.foxcentral.net/
At the VFUG site (http://vfug.org:8080/) is a file called FRX2Word that converts the output from a VFP Report (.frx) into an RTF format or a Word DOC format. Your choice.
The File Archive there is called frx2word.zip.
John Koziol, now with the MS Fox team, started this gem and it is currently...
I have never tried this.
Maybe you can spot something at the site that handles info about Win32 API Functions within VFP.
Try this URL first and go from there:
http://www.news2news.com/vfp/?group=49&=0
==Carl
Carl Warner
VFUG Officer, http://vfug.org:8080/
MS MVP, VFP
FoxCentral...
Look at the config file for the other FP application that works fine and look at the config.fpw for the one giving you the problems and see what difference may cause the delay.
Is that the DOS version or Windows version of FoxPro 2.5? I know you said you have Windows 98 and Windows XP PCs and the DOS stuff could run under that.
That product is obsolete but most of the programming language in it is still good to this day in newer versions of Visual FoxPro. It's just...
Since I don't know what OS you're using, I'll volunteer mine as the basis. I am using Windows 2000.
Under Control Panel...Scheduled Tasks, you can add a task
to execute the VFP .exe whenever you wish.
Besides the article referenced in that other thread, MS has an example file that details a 1 to many operation:
1ToMany.exe Form for One-to-Many Order Entry Application
http://support.microsoft.com/default.aspx?scid=kb;en-us;138041
==Carl
http://vfug.org:8080/
Are you running the report from data that has been queried as a snapshot or running it directly against live data that could be changing as you print it due to ongoing user input?
I can't tell from your description of "join" whether you're referring to a SQL SELECT involving JOINs or...
See the MS KB articles:
How to Highlight a Single Grid Field
http://support.microsoft.com/default.aspx?scid=kb;en-us;138655
HOWTO: Change the Color of the Active Cell in a Grid
http://support.microsoft.com/default.aspx?scid=kb;en-us;129280
Besides error trapping, I have just tested whether or not the wanted object is really an object.
** initialize object variable
oEx = CREATEOBJECT("Excel.application")
**** test validity of object
IF TYPE('oEx')="O"
ELSE
WAIT WINDOW "Problem using Excel on this...
Go to the MS KnowledgeBase link as listed below and download the sample file it shows.
Views.exe - One-To-Many Form Using a Parameterized View
http://support.microsoft.com/default.aspx?scid=kb;en-us;142974
==Carl
Carl Warner
VFUG Officer, http://vfug.org:8080/
Do you have both the workstation PC and the server using something like Norton Anti-Virus where both get to check each and every file when they are opened.
Many have seen performance increases by excluding certain file types or server folders from overscanning on the client side. Afterall, if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.