Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Results differ between developing environment and exe ditto
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Results differ between developing environment and exe ditto
Miscellaneous
Thread ID:
01532279
Message ID:
01532279
Views:
79
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
Map
View

Click here to load this message in the networking platform