I posted this question in another forum and they told me to try here.... Let's try.
Hello there,
I'm not a Progress developer, but I'm using Progress from some .Net applications through ODBC connection and having some problems.
I need to query the _File table, and when I'm querying
select "_File-name", "_Desc" from pub."_File"
I have the error:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210012
:Column Desc in table PUB.File has value exceeding its max length or precision.
(This happens in SQL Explorer too).
When I export a .df from this database, I notice that the DESCRIPTION of one table is ~200 chars. In the dictionary this field has 144 chars. Anyway to workaround this problem without doing some modifications to the database?
Is there any way to truncate the field without taking this error? Or to set the SQL Width through ODBC?
Thanks in Advance,
Eric Lemes
Have a look at the DBTOOL utility in the Database Administration doc, though, I don't know how it will work with the schema tables.
http://www.psdn.com/library/entry.jspa?externalID=1913&categoryID=462
http://www.psdn.com/library/servlet/KbServlet/download/1913-102-2616/dmadm.pdf
Reference Chapter > Other Database Administration Utilities > DBTOOL utility
HTH