Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date Problem
Message
 
 
À
30/11/2000 09:05:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00447282
Message ID:
00447301
Vues:
12
Paul,
As Sergey said, it has to do with the SET STRICTDATE setting. SET FILTER transforms your nice neat date format into what VFP terms an ambiguos date reference. If you SET STRICTDATE to 0 (turn off STRICTDATE), you are basically reverting back to FPW settings.

Here is some code I posted earlier that helped me when I wanted STRICTDATE set to 2 and had this problem:
lcdate = set('date')
set date to british
lcfilter = set('filter')
set date to &lcdate
set filter to
[do some code here]
lcfilter = strtran(lcfilter,"{","{^")
set filter to &lcfilter
>Hi All,
>
>Please help me to identify this problem if you could.
>
>cFilter=iif(empty(m.From),'','EVENT_DATE) >= {'+dtoc(m.From)+'}')
>
>for example :
>
>m.from = 2000/11/28
>
>event_date = 2000/11/30
>
>
>used to work fine with Foxpro for windows 2.6 BUT gave me an error
>
>with VFP 6.0 when I tried to run my report.
>
>Thank you in advance,
>Paul
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform