Hi All,
I have a fruit table which contains the following...
ID Items
-- -----
1 apple
2 pear
3 banana
4 cherry
.
.
13 watermelon
14 orange
15 mango
and I want to return the Items (description) based on the id stored in this format -> n:m:o:p.
Here is an example, when I used the ATC(alltrim(fruit.id),"13:14:15"), with fruit id = 1 (starting with the first record), VFP returns the following...
apple
watermelon
orange
mango
instead of 'Apple'
Is there a way to return the item description based on the exact match? Is there other ideas or suggestons using "13:14:15" format?
TIA
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