Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lowest Number of 4 fields
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01142110
Message ID:
01142130
Views:
12
>Hi Kirk
>
>>I have a record that has four numeric fields, I need to use the lowest value of those four fields. Is there an easy way to do this without having to code a if than else if then type structure?
>
>How about:
>
wait window MIN(MIN(fld1, fld2), MIN(fld3, fld4))
Intermidiate MINs are not necessary. The MIN() can accept more than 2 parameters.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform