General information
Category:
Coding, syntax & commands
Title:
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only