Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Show text instead of number
-
Pfigueredo
- Posts: 2
- Joined: Sat Feb 27, 2016 11:04 am
Show text instead of number
Hi, forgive my english is'n good. I have a Grid subform and a column has only 4 posible values disabled to edition. I want to show it in Display mode like text and i dont want to create a table only for this, in Display Tab i wrote "SELECT des,cod FROM ( SELECT '1' AS cod, 'ALTA' AS des UNION SELECT '2' AS cod, 'BAJA' AS des UNION SELECT '4' AS cod, 'MODIFICADO' AS des UNION SELECT '3' AS cod, 'DISPONIBLE' AS des) AS T1" and i dont know what put in WHERE clause because the field is neither index nor primary key. Thanks.