General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I am haveing trouble with a select statement. One of the fields is a calculated field -cfnos(dm_released,noofshts) As noofshts-. If the variable dm_released evaluates to a temporary change value the value returned is a 1, otherwise the value returned is noofshts. My problem is if the first returned value is 1 it sets the field width to one charactor and any two digit values appear as an asterisk. If the first value is two digits all is well. Thanks for the help.
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