Data not visible in For each. But visible in Dump.

[nelsonbatistajr]

Hello everyone.
I have a connection via ODBC with a Mysql database, data is stored in Mysql base and later written based on my progress.
When trying to run a for each in a field of one of my tables, the field is displayed as "?" however when running a dump table, information is visible.


Would you like a hint of why this situation?! Codepage? what else?


The field in the database Mysql is a varchar x500 and x500 progress is a char.

 

[Reynold]

I believe you need to use format with some more width for that data in for each while display.
Is that data is char or date??? Progress usually returns "?" for unknown value in date or when the data is more in widht than the display width of that field.
you can use display field-name format x(40).
Just check that.