Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grrrrr... I hate dates....
Message
De
12/08/1999 15:29:44
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00253146
Message ID:
00253174
Vues:
25
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform