Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grrrrr... I hate dates....
Message
From
12/08/1999 15:29:44
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00253146
Message ID:
00253174
Views:
24
I don't have SP3 (yet)

It only happens when I tableupdate(0) into the server.

My program does:
mydate = .null.
insert into tablea from memvar
tableupdate(0)

(this is just the relevant commands, there is a lot more to it, but I can throw a C5 error with the above code.)

>>>tablea.date -- I never populate it, it goes fine (by default, has a null value)
>>>tablea.date -- I put in .null. -- program throws a C5 error
>>>tablea.date -- I put in an empty date -- ODBC returns ivalid datetime type
>>>tablea.date -- I put in a valid date, it works fine.
>>>
>>>Grrr... I just spent two hours trying to figure that all out!
>>
>>Hi Todd,
>>
>>Interesting. I did a CREATE CURSOR FOO (mydate D), APPEND BLANK, and REPLACE mydate WITH NULL and didn't get a C5. What I did get was an error message saying that the field didn't accept null values. So I tried ISNULL() on the field and it returned .F. EMPTY(), however, returned .T.
>
>Addendum to this. This is with VFP 6.0 SP3.
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform