I connected a ComboBox to a sql view with some varchar and numeric columns. I noticed that that only the varchar columns where visible to select as display and search fields.
Please update the ComboBox so that you can also select the numeric fields.
Consider the output you get on adding this feature, should this be a textstring, value?
I this case I made a additional view where I convert the numeric values to a string type.
Found a better workaround so thought let's share it. User
AddColumns(YourDataSource, "IntText", Text(Int))
Now you can use the number column to display in your Combobox.
AddColumns won't work with large SQL data sets (more than 500 rows) as it can't be delegated.