RE: Lianja anyone?
If someone else is in the program with the tables open, reports will be slow, and the client interface will be slow. It's a network share thing. Some of our customers see this when their data gets above 3000 records. I deal with legacy code that came from the original clipper code base. You know the kind that does a SCAN ... ENDSCAN to build the report data. YMMV, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, August 23, 2018 5:19 PM To: profoxt...@leafe.com Subject: Re: Lianja anyone? On 2018-08-22 12:27, Alan Bourke wrote: > On Wed, 22 Aug 2018, at 3:51 PM, > mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: >> On 2018-08-17 10:08, Dave Crozier wrote: > >> They've got 500MB of data in some centers with 20+ years of data > > Not *that* big in Fox terms ... > >> running some reports takes FOREVER on the client machines at their >> learning centers > > Are they on the same LAN as the server with the DBFs? I agree...not huge for VFP but for reasons I can't explain, it's slow. Of course the tech folks at Corporate think it's pulling the entire dbf file etc over the LAN (and maybe they've done analysis to support that with SysInternals...not sure), but I've seen it to be slow. Many lines of legacy code that weren't written for full optimizations, so it is what it is. Yes, I believe the same LAN. Workstations connecting to the inhouse Corporate server box...which then communicates with the MotherShip and sends all their data back there too. I believe the servers are underpowered and not configured correctly but of course that's off-limits to anybody but The Man at Corporate. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601d43b2a$be4c1770$3ae44650$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Lianja anyone?
On 2018-08-22 12:27, Alan Bourke wrote: On Wed, 22 Aug 2018, at 3:51 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-08-17 10:08, Dave Crozier wrote: They've got 500MB of data in some centers with 20+ years of data Not *that* big in Fox terms ... running some reports takes FOREVER on the client machines at their learning centers Are they on the same LAN as the server with the DBFs? I agree...not huge for VFP but for reasons I can't explain, it's slow. Of course the tech folks at Corporate think it's pulling the entire dbf file etc over the LAN (and maybe they've done analysis to support that with SysInternals...not sure), but I've seen it to be slow. Many lines of legacy code that weren't written for full optimizations, so it is what it is. Yes, I believe the same LAN. Workstations connecting to the inhouse Corporate server box...which then communicates with the MotherShip and sends all their data back there too. I believe the servers are underpowered and not configured correctly but of course that's off-limits to anybody but The Man at Corporate. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/62c9b6a65b4d76dddfdc6a5178615...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it
Have you tried putting the following on the Page Activate: This.Refresh DoDefault() * Return Dave Crozier Software Development Manager Flexipol Packaging Ltd. ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E dcroz...@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. - Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: ProFox On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: 22 August 2018 16:40 To: ProFox Email List Subject: Re: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it On 2018-08-22 11:21, Richard Kaye wrote: > Is the chart container magically zooming when you activate the 2nd > page? If so, what code is executing at that time? I used EVENTTRACKING to tell me. I set ET on in the pag1.Deactivate and turned it back off in the pag1.Activate (so when I navigated back to page1 it would shut off). Here's the pickup from page2's tracking: 41830.801, frmhelpdeskcharts.pgf.pag2.Activate() 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.title.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.subtitle.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.xaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.scalelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.axislegend2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.shapelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.sidelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.tooltip.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.chartcanvas.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.cmdchartoptions.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.title.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.subtitle.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.xaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.scalelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.axislegend2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.shapelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.sidelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.tooltip.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.chartcanvas.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.cmdchartoptions.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.UIEnable(.T.) 41830.802,
Re: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it (SOLVED)
I was going to suggest .lockscreen but I see you already found it :) The .lockscreen approach will usually take care of a lot of visual oddities (I used it frequently with OCX components). Recall that VFP "draws" its own display, and does not use the underlying Windows "controls", etc. So, yeah, in a way it is kind of a kludge, but it's probably more of a specific need because Foxpro was bought, not developed, by MS. -Charlie On 8/22/2018 12:18 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-08-22 10:43, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 using FoxCharts (1.37 and 1.46beta) I've got FoxCharts working somewhat in my testing so far, but I can't get the first showing page to fully resize automatically and some trickery I've tried is driving me nuts. See 20-second demo showing my frustration: https://www.screencast.com/t/jmTkdEl2xN ... Solved it with this kludge in the form.init: this.LockScreen = .T. this.pgf.ActivePage = 2 this.pgf.ActivePage = 1 this.LockScreen = .F. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a7741464-ed32-6045-5e79-0892fc4ff...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.