Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Results differ between developing environment and exe ditto
Dear All,
I have the following problem: When I run the code below (The code is to produce a list of week no's
with the two last figures in the corresponding year as a prefix)
CREATE CURSOR curWeekNo(weekno N(4,0))
SELECT 'curWeekNo'
FOR i=1 TO 6
REPLACE curWeekNo.weekno WITH ;
ROUND(VAL(SUBSTR(ALLTRIM(STR(YEAR(DATE()+7*(-6+i)))),3))*100+;
WEEK(DATE()+7*(-6+i),0,2),0)
NEXT
Today (6th of January 2012) in the VFP developing environment I get the correct result as follows
1148
1149
1150
1151
1152
1201
When I run the same code in the exe-file I receive the result
1149
1150
1151
1152
1101
1202
Any idea?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement