General information
Category:
Coding, syntax & commands
>>If these are the only codes you have, you can write a small CarCodeToCarName function and call it in your SQL statement:
>
>Vlad,
>
>That approach will blow upi if the data is ever moved to a storage system other than VFP. Making a validation table for the codes and using a join to it will translate to any relational databse system.
This is only one of the reasons I said that having that validation table is a better solution! :)
Vlad
Previous
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