I've saved some data into a STRING field of an SQLite3 database. Then I retrieve that data with a SELECT DISTINCT statement to fill a TCombobox. All works well until the first data is a number, like 105, then the TCombobox fills with all zeros, even though 105 was saved to the database as a string.
I've tried testing the data with IsNumber(), then converting it to a string with IntToStr before sending it to the TCombobox, but haven't gotten IsNumber to work yet. But it seems the data should already be a string anyway.
Update 1: The problem doesn't seem to be with the TCombobox because I can display the first record, 105, in a TLabel.Caption indicating it is indeed a string, but when I try to display the second record, which is alpha, in TLabel.Caption it displays a 0.
Update 2: If I change the datatype in the database to Char or Text, it works. Numbers will fill TCombobox as well as alpha. Which is best to use, since I want to be able to store numbers as well as alphanumeric characters.