General information
Category:
Coding, syntax & commands
Title:
Displaying conditional results in a list box
In Foxpro 2.6 I displayed the contents of a quantity field conditionally using a calculated field in a browse window and IIF statements. The field is set to display 2 decimal places - 6,2. If the field contains a whole number it should be displayed as an integer. If it is 1.5 it should display like that and not 1.50 and if it is zero there should be nothing displayed. How do I achieve this with SQL statements that populate a list box.
Next
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