InfoMaker chops off Long Character fields
Posted on 2004-03-27
We have an ASA 8.02 database hosted on WIn2K server. The database is used by our ERP software. The software vendor recently changed several note fields to "long VarChar". With the ERP app, we can enter & retrieve lengthly notes in the new fields.
We use InfoMaker 8 to create custom reports. The problem we're having is that when InfoMaker fetches the field, it seems to only get the first 100 or so bytes of text. We use ODBC to connect to the database. When I connect using the ERP app, or Excel, or WinSQL, or Crystal Reports (all through ODBC) the entire contents of the field are returned, so I'm lead to believe that the problem is with InfoMaker.
Can anyone shed some light on this?