Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FDOW doesn't work for me
Message
 
À
25/01/2006 16:37:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01090273
Message ID:
01090317
Vues:
11
Thanks Rich for your reply. But the version is FVP 9.

>According to the Hacker's Guide for VFP 7 (hope it's ok to quote it here)
>
>nFirstDayofWeek
> Omitted
> Use Sunday as the first day. This is for compatibility with older versions of FoxPro.
>
>
>
>>Sergey and Yuri
>>
>>? DOW(DATE(), SET("FDOW"))
>>
>>works perfect
>>But I read the help. I don't find DOW() function is not affected by SET FDOW
>>This is in my help
>>
>>Returns a numeric day-of-the-week value from a Date or DateTime expression.
>>
>>DOW(dExpression | tExpression [, nFirstDayOfWeek])
>>
>>Parameters
>>dExpression
>>Specifies the Date expression from which DOW( ) returns the day number.
>>
>>tExpression
>>Specifies the DateTime expression from which DOW( ) returns the day number.
>>
>>nFirstDayOfWeek
>>Specifies the first day of the week. nFirstDayOfWeek may be one of the following values.
>>
>>nFirstDayOfWeek  Description
>>0
>> DOW( ) uses whatever day is currently selected in the Week Starts On list box, which appears on the Regional Tab in the Options dialog box.
>>
>>1 Sunday. This is the default when nFirstDayOfWeek is omitted, and is the first day of the week used in earlier FoxPro versions.
>>2 Monday
>>3 Tuesday
>>4 Wednesday
>>5 Thursday
>>6 Friday
>>7 Saturday
>>
>>Yes [, nFirstDayOfWeek] is parameter but why I need to use this parameter while i have SET FDOW TO? or this is dummy SET ??? unusable may be
>>
>>>According to help, the DOW() function is not affected by SET FDOW. The following should work for you
>>>? DOW(DATE(), SET("FDOW"))
>>>
>>>
>>>>I read thread#1090152 and I try this code
>>>>
>>>>*** today is Wednesday
>>>>clear
>>>>SET FDOW TO
>>>>? DOW(DATE()) &&& result is 4  = true
>>>>SET FDOW TO 2 &&& Monday is the first day
>>>>? DOW(DATE()) &&& result is again 4. Why ? Today is Wednesday must by 3
>>>>
>>>>What do I wrong?
>>>>TIA
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform