Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
10 types of people
Message
From
10/10/2003 10:22:41
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00836301
Message ID:
00837390
Views:
32
>I did:
>
select distinct ttod( a.from ) from ( lcFile ) into array laTmp
>
>Since the table currently only has values 10-10-2003, this should have given:
>
laTmp[1]  "10-10-2003"
>but it gave:
>
laTmp[1]  "02-02-2003"
>I did a lot of debugging, couldn't explain what was happening and we thought with a laughter "well, maybe it's an easter egg, translating bin 10 to dec 02". :)
>
>In fact, what was the cause?! I forgot to specify the a behind lcFile. And there was a similar table open in workarea a! The record over there indeed had 02-02-2003.
>

Just want to point out that using A as an alias is generally not a good idea. Much better to use the actual alias.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform