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
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
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:
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
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.
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
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
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
8 matches
Mail list logo