RE: Help! View is converting empty date to 1899!

2007-05-17 Thread Michael Hawksworth
is converting empty date to 1899! Ted Roche wrote: What are you thinking about for a work-around? Replacing the empty dates with NULLS, which works fine: OPEN DATABASE tadb SET DATABASE TO TADB =ADBOBJECTS(aFiles, TABLE) FOR ni = 1 TO ALEN(afiles) cFile = afiles[ni] IF FILE(cfile

Re: Help! View is converting empty date to 1899!

2007-05-17 Thread Vince Teachout
Michael Hawksworth wrote: What about editing the view field to use an evl(fieldname,null) when returning that field? WAY to many fields in too many files to make that practical. Thanks, though. -- Vince Teachout Caracal Software www.caracal.net 518-733-9411

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Vince Teachout
Vince Teachout wrote: The dates show up as 12/31/1899. Correction: 12/30/1899 -- Vince Teachout Caracal Software www.caracal.net 518-733-9411 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Ted Roche
On 5/15/07, Vince Teachout [EMAIL PROTECTED] wrote: I'm using vfp9 (sp1 on that particular machine) and this is a remote view on local vfp data (don't ask, and no, I can't change that) Well, then, I won't ask. This behavior is by design. http://support.microsoft.com/kb/157424 -- Ted Roche

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Vince Teachout
Ted Roche wrote: On 5/15/07, Vince Teachout [EMAIL PROTECTED] wrote: I'm using vfp9 (sp1 on that particular machine) and this is a remote view on local vfp data (don't ask, and no, I can't change that) Well, then, I won't ask. This behavior is by design.

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Ted Roche
On 5/15/07, Vince Teachout [EMAIL PROTECTED] wrote: !! Thanks, Ted. :-( You're welcome. :) What are you thinking about for a work-around? There's a reason why you are using a remote view to access local Fox data, but I can't ask. It's too bad, because the answer to

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Vince Teachout
Ted Roche wrote: What are you thinking about for a work-around? Replacing the empty dates with NULLS, which works fine: OPEN DATABASE tadb SET DATABASE TO TADB =ADBOBJECTS(aFiles, TABLE) FOR ni = 1 TO ALEN(afiles) cFile = afiles[ni] IF FILE(cfile+.dbf) USE

Re: Help! View is converting empty date to 1899!

2007-05-15 Thread Ted Roche
Okokokok - it's because it's a legacy system already deployed in about 40 different locations. ... The system is so simple, that it actually works remarkably well. That's a really good reason to do it that way! -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com