Error when Using Select Expert to select an Alphanumeric field
Posted on 2009-04-13
I am getting an errpr - Failed to retrieve data from database when I use the Select Expert to select specific records from an IBm iseries database.
If I use a numeric field with the Select Expert it works fine.
I am trying to select all records with CC in a field (DPTNO). The error returns : - Numeric Constant 0xCC not valid.
When I view the SQL, I am seeing the statement - WHERE "DPTNO" = 0xCC
The field size in the file is 4 Character. and the actual data is CC.