Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
10 types of people
Message
De
10/10/2003 10:22:41
 
 
À
10/10/2003 08:28:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00836301
Message ID:
00837390
Vues:
30
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform