Troubleshooting
Problem
Yes/No Fields are not populating correctly, when importing YES/No field data from a spreadsheet
Symptom
A spread sheet containing 'x's for 'Yes' values (an 'x' signifying a positive response) fails to import correctly into iBase
Cause
https://www.ibm.com/docs/en/i2-ibase/9.0.5?topic=data-yes-no-fields
When importing Yes/No fields from a text file into SQL Server databases, blank values are interpreted as ‘No’.
This is useful where a Yes/No field is left blank for ‘No’
But on the flip side you must make sure you submit either a Y/y or a 1 to satisfy the requirements for a tick/Yes.
Diagnosing The Problem
Following an import of Yes/No field data into iBase, you observe that the Yes/No data is incorrect.
(Whilst you can set the default value to be = Yes, it is more likely/usual to set the default to be No.
Verify the default setting (if used) in iBase designer)
Hence where you are expecting a positive/yes/tick, should you not see a positive/yes/tick; then you should check your import source data and verify that the value submitted is a Y/y or a 1, not anything else like an 'x'
Resolving The Problem
Submit either a Y/y or a 1 to satisfy the requirements for a tick/Yes.
Was this topic helpful?
Document Information
Modified date:
27 October 2021
UID
ibm10731777