The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Datagrid using picklist column type
Posted: 29 Apr 08 7:53 AM
|
| I have a data grid with 4 integer fields that represent text data. I would like to create a picklist where the users sees the text data but the system stores the integer value. I have tried different variations of the picklist (i.e. code is the integer value and item text data / code as the text value and item as the integer value) and nothing seems to work. The system always displays the text data (which is good) but gives an error indicating I'm trying to store non-numeric data in an integer field (this is bad). I have also tried various settings for the Text Type in the PickList properties screen to no avail. What am I doing wrong??? |
|
|
|
Re: Datagrid using picklist column type
Posted: 29 Apr 08 10:02 AM
|
Desgn time grid or RUn time grid?
Any edit views with this grid? Why dont you have one and edit the info there and let this grid be a RO grid.
how are you saving data to the tables? Script or using the active grid saving it automatically? |
|
|
| |
|
Re: Datagrid using picklist column type
Posted: 29 Apr 08 10:04 AM
|
| It's a design time grid. I'm not using an edit grid that I know of. I'm using active grid to save automatically. I'm very new to this so any help is appreciated. |
|
|
|
Re: Datagrid using picklist column type
Posted: 12 Mar 10 3:57 PM
|
| I had the same problem. I got around it by using a 1-character text field instead of an integer. Apparently datagrids panic whenever they see text headed for a numeric field, even if it will end up with a picklist code instead of the displayed text. |
|
|
|