Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ambiguous date
Message
De
12/02/2000 23:16:48
 
 
À
12/02/2000 22:48:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00331435
Message ID:
00331465
Vues:
14
>>Thanks for the reply. You have hit on a subtle but important difference. With strictdate set to 1, when I assign a value to the memory variable with the name of the view parameter, (i.e., vp_dDate = {^2000-01-31}), in the command window, the browse for the view works fine. If you release the variable and put the same value in the view parameter dialogue box, you get the "Ambiguous date/datetime constant" error. There seems to be a problem with the dialogue box. I have tried this with several simple views on a test basis and get the same result every time. I am wondering if it is only me or is it with Foxpro. (using Ver 6.0 SP3).
>
>
>It strikes me that perhaps you're complicating things by using the strict datewrapper here. The dialog knows that it's accepting a data. If it's accepting a string, I don't have to wrap it in quotes. What happens if you just enter a non-ambiguous date in whatever the current system form is, less the strict date notation? I just tried a test, and entering the date in the form {^2000-02-12} gave me the error, but 2000-02-12 did not.


I have tried several combinations of date format. Firstly, by using say 2000-02-12, it at least does not give an error, and produces a browse. However, nothing comes up in the browse, records: None. But the date I use has matching records, so it is not reading the date properly. No matter which form of the date I used, it would not come up with the records related to the date. I think when strictdate is set to 1, the dialogue box is not functional for dates.
Notwithstanding, it is most likely that the value of the view parameter can be set from a variable, and the dialogue box is unnecessary. This would avoid the problem. Unfortunately, in testing data and parameters, I was using the dialogue box and got stopped. I think that MS might look at this dialogue at some point, if it doesn't work.

Thanks for your help on this.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform