RE: Import From Excel

2013-02-17 Thread John Weller
Thanks to all who replied. Automation is obviously the way to go and the replies will help a great deal. Unfortunately a series of minor domestic issues have meant that I've not been able to look at the problem for a few days but hope to get on to it soon. Regards John John Weller 01380

Re: VFP9: Windows 8

2013-02-17 Thread Man-wai Chang
Take a look at Control Panel\Appearance and Personalisation\Fonts\Font settings On Sun, Feb 17, 2013 at 10:01 PM, Desmond Lloyd desmond.ll...@gmail.com wrote: Got an odd one, maybe it's a momentary lapse of reason. In any event. Client just got some new Windows 8 machines. The application I

Re: [NF] Government Software Controls

2013-02-17 Thread Ken Dibble
In any case, having a unique data type for dates precludes the value from being treated as anything other than a date. One can't do math on a VFP date value and get a result that can be interpreted as currency, unless one is completely clueless as a programmer. (ldEndDate - ldStartDate) *

Re: [NF] Government Software Controls

2013-02-17 Thread Ken Dibble
Jeez. The hits just keep on coming. My email client fritzed out and corrupted/truncated the message I intended to send. Here is the correct message. Please ignore the previous one. In any case, having a unique data type for dates precludes the value from being treated as anything other than

Re: [NF] Government Software Controls

2013-02-17 Thread Ken Dibble
G It still cut off my last few paragraphs.. Here they are: As an advocate for people with disabilities who works for an agency that bills Medicaid in NY, I'm very sensitive to the issue of public officials mislabeling honest mistakes as fraud and using these events to get publicity

SLEEP?

2013-02-17 Thread jerry foote
Sleep In Win32API Integer nMilliseconds Sleep((60*1000)*15) If I issue this sleep function in a procedure how long is it in scope. Do I have to release it before I call it again, or can I just issue Sleep((60*1000)*15) again? Hope this makes sense. Jerry --- StripMime

RE: SLEEP?

2013-02-17 Thread jerry foote
I have a form that I run with a timer event that fires every 15 minutes, I check to see if the time is between 10:00pm and 10:20pm, if so I call a routine to do some daily dusting and cleaning. I only want this to fire once a day so I am using the sleep to insure that the time will only fall once

Re: [NF] Government Software Controls

2013-02-17 Thread Paul McNett
On 2/16/13 5:00 AM, Ted Roche wrote: In addition, few DBMS do a good job of tracking timezones. TZ are a hard problem, as there are dozens of changes to what location has which timezone every year, so it's difficult to calculate if it is not captured at the time. Why would the DBMS need to

Re: SLEEP?

2013-02-17 Thread Fred Taylor
I don't understand. Sleep just pauses your executable, it's still running. It only comes back to a live state when the Sleep duration has expired. Maybe you really want to run a scheduled task? Fred On Sun, Feb 17, 2013 at 12:59 PM, jerry foote jer...@footegroup.com wrote: I have a form

RE: SLEEP?

2013-02-17 Thread jerry foote
Fred I don't really understand what I'm doing with Sleep In Win32API Integer nMilliseconds That is what I am basing my question on. I also don't understand what I have to do to run a scheduled task? Thanks Jerry -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf

Re: SLEEP?

2013-02-17 Thread Fred Taylor
A scheduled task is a Windows thing. There is a Task Scheduler, that will run any kind of Windows program or batch file at a predetermined time and/or frequency. The major thing you may have to watch out for for a VFP scheduled task is if it depends on mapped drive letters, as the task is

Re: [NF] Government Software Controls

2013-02-17 Thread Dan Covill
On 02/17/13 09:00 AM, Ken Dibble wrote: From the report: For example, many claims we reviewed were subjected to the eMedNY edit Medicare/MCO Payer Amounts Not Reasonable. However, the edit was set to pay (as opposed to pend or deny) a questionable claim. If this edit was set to pend or deny

Re: 64-bit DEFINE CLASS

2013-02-17 Thread Dan Covill
On 02/15/13 09:21 AM, Kelly Dezotell wrote: SET PROCEDURE TO MakeClass.prg ADDITIVE loClass = CREATEOBJECT(MyClass)'MyClass' is the class defined in MakeClass.prg In XP, this process works just fine. In Win7, any operation using the LoClass variable after these lines returns an

Re: [NF] Government Software Controls

2013-02-17 Thread Paul McNett
On 2/17/13 3:13 PM, Ted Roche wrote: Um. Gee, I thought I had a use case when I made the statement, but I'm drawing a blank. I seem to recall I had a case where I had user-entered data and needed to capture the time zone, but I can't recall the details. I thought of one: West-coast user

Re: [NF] Government Software Controls

2013-02-17 Thread Ken Dibble
I've designed more than a few systems with the shoot yourself in the foot feature as insisted by the client, despite my grave and repeated warnings. I have that pattern! :) What a silly way to run a health care system. We must be the laughing stock of the civilized world. Pretty much,

Re: [NF] Government Software Controls

2013-02-17 Thread Dan Covill
On 02/17/13 03:43 PM, Paul McNett wrote: West-coast user entering stuff on East-coast user's calendar (would want to see that calendar in the other user's timezone). Wait, that's still a client problem as the dates would still be UTC on the server, and I guess there'd be some sort of user

Re: [NF] Government Software Controls

2013-02-17 Thread Paul McNett
On 2/17/13 4:37 PM, Dan Covill wrote: On 02/17/13 03:43 PM, Paul McNett wrote: West-coast user entering stuff on East-coast user's calendar (would want to see that calendar in the other user's timezone). Wait, that's still a client problem as the dates would still be UTC on the server, and

Re: [NF] Government Software Controls

2013-02-17 Thread Dan Covill
On 02/17/13 05:53 PM, Paul McNett wrote: On 2/17/13 4:37 PM, Dan Covill wrote: Dave Taylor posted on this topic at some length last week. It's not an easy problem, from a Data standpoint, from an Application standpoint, or from a User standpoing. It's a tricky problem yes. Just another