Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error#2034 Date/DateTime evaluated to an invalid value
Message
De
09/07/2009 07:13:14
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01411068
Message ID:
01411103
Vues:
44
ChristofWollenhaupt,

RE:this happens when SET DATE is either LONG or SHORT and the year of the date is less than 1600. Typically this happened when the user enters birth dates like 1958 and misses the first digit or clicked on digit to far. This ends up with 958 or 195 in the table.

I remember reading something about that. This is not occuring during data entry I don't think - it is during index created INDEX ON statements and during sql selects that do select and DTOC on existing fields in the free foxpro 2.6 format table. When I try to put a 01/01/1500 in a date field it says "invalid date" messagebox and doesn't let me continue - so unless this is not just a data entry thing but a sql select or index thing I think I'm ok on that - no users have run into data entry of values errors like this that I am aware of yet.

thanks for the advice!

From: Ed
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform