Re: Print Notification

2015-04-24 Thread Stephen Weeks
Laurie, I have to do this same thing for example users can preview an invoice before printing but I don't want to update the invoice master tagging it as printed at this stage, so I put the 'Preview' checkbox next to the "Print Invoice" button so I csn establish if the invoice was printed or previ

Re: Performance measure

2015-04-24 Thread Gene Wirchenko
At 15:36 2015-04-23, Sytze de Boer wrote: I have a client who runs my invoicing/job centre system He has about 6,000 clients, 15,000 stock items and 500,000 history transactions My client is complaining about performance. I have other clients who have many more clients, stock items and 1.5 mill

Re: Performance measure

2015-04-24 Thread Kevin Cully
I agree with Tracy. Take the query that the client is complaining about and create an app that runs that query from a similar workstation (not from the server) once an hour and log the time it takes. I had a client where the network and/or server slowed down every 8am, 12pm, and 5pm. Yep, tha

RE: Performance measure

2015-04-24 Thread Kurt Wendt
Sytze - just an additional suggestion. Although logging into their system remotely might be helpful in checking it out. My suggestion - go on site and have the user SHOW you how or where its slow. Maybe seeing with your own eyes may help - and also help confirm if they are exaggerating the issue

Re: Print Notification

2015-04-24 Thread Laurie Alvey
I've had a look at SYS(2040) but can't see how to use it. Calling it after the report always results in "0", and calling a form method in the page footoer doesn't work. Puzzled. Laurie On 24 April 2015 at 13:33, Stephen Weeks wrote: > Sorry I am not having a good day :- > > if thisform.check1.va

Re: Print Notification

2015-04-24 Thread Stephen Weeks
Sorry I am not having a good day :- if thisform.check1.value=.t. report form myreport preview WasPrinted=.f. && as this is a preview else report form myreport to printer prompt noconsole WasPrinted=.t. endif On Fri, 24 Apr 2015, at 01:31 PM, Stephen Weeks wrote: > Sorry this got cut short >

Re: Print Notification

2015-04-24 Thread Stephen Weeks
Sorry this got cut short if thisform.check1.value=.t. report form myreport preview WasPrinted=.t. else report form myreport to printer prompt noconsole WasPrinted=.f. endif On Fri, 24 Apr 2015, at 01:29 PM, Stephen Weeks wrote: > I tend to put a checkbox "Preview" which the user ticks if onl

Re: Print Notification

2015-04-24 Thread Stephen Weeks
I tend to put a checkbox "Preview" which the user ticks if only to preview the report, this enabled me to carry out certain actions if the rteport is actually printed , which I believe is what you want :- if thisform.check1.value=.t. else endif On Fri, 24 Apr 2015, at 11:06 AM, Laurie Alvey wro

RE: Print Notification

2015-04-24 Thread Richard Kaye
Check out SYS(2024) and SYS(2040). -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, April 24, 2015 7:36 AM To: profoxt...@leafe.com Subject: RE: Print Notification Do you have a copy of the What's New in Nine book? Th

RE: Print Notification

2015-04-24 Thread Richard Kaye
Do you have a copy of the What's New in Nine book? There's a section using a reportlistener to monitor progress. IIRC I think there's also a SYS() function that indicates the preview vs. printed status. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On B

Re: Performance measure

2015-04-24 Thread Tracy Pearson
On April 23, 2015 6:52:48 PM EDT, Sytze de Boer wrote: >Tracy, I can only log into the *server* > > The server is always snappy, the performance issues are seen in the on the workstation. For years I never saw the performance issues our customers would mention. Recently we saw the issue in ho

Re: Print Notification

2015-04-24 Thread Tracy Pearson
On April 24, 2015 6:06:17 AM EDT, Laurie Alvey wrote: >When printing a report, I usually issue something like this: >REPORT FORM TO PRINTER PROMPT PREVIEW > >What I want to do is receive some sort of notification as to whether >the >report was actually sent to the printer or just previewed. Doe

Print Notification

2015-04-24 Thread Laurie Alvey
When printing a report, I usually issue something like this: REPORT FORM TO PRINTER PROMPT PREVIEW What I want to do is receive some sort of notification as to whether the report was actually sent to the printer or just previewed. Does anyone have any ideas? (I've looked at vfp2c32 but it looks h

Re: Weird Performance Issue

2015-04-24 Thread Man-wai Chang
I would first look at the queries. Are they SQL, SCAN...ENDSCAN, or DO WHILE...ENDDO? Then I will look at indexes, notably the index expressions. Make sure that they are Rushmore-optimized! On Fri, Apr 24, 2015 at 1:30 AM, Gene Wirchenko wrote: > One of the options is whether to process non

Re: Posting from My New Job

2015-04-24 Thread Man-wai Chang
1. Fox Wikis 2. Universal Threads On Fri, Apr 24, 2015 at 1:07 AM, Gene Wirchenko wrote: > > I disagree on that. ProFox is quite useful, but so is foxite.com. > (Feel free to add to the list.) > It would be sad if ProFox were the last holdout of FoxPro coders. -- .~. Might, Courage,