Solved

InfoMaker chops off Long Character fields

Posted on 2004-03-27
6
463 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:BudDurland
  • 3
  • 2
6 Comments
 
LVL 15

Expert Comment

by:namasi_navaretnam
Comment Utility
Within datawindow, you will need to increase that char limit of the corresponding fields. In addtion enable 'auto resize' property to true on the datawindow field itself and the detail band.

regards-
0
 
LVL 15

Expert Comment

by:namasi_navaretnam
Comment Utility
Also if using stored procedure make sure TEXTSIZE OPTION is set to a higher value or zero as the default.

SET TEXTSIZE     Specifies the maximum size (in bytes) of text or image type data to be returned with a select statement. The @@textsize global variable stores the current setting. To reset to the default size (32K), which is also the maximum setting, use the command:

set textsize 0

I am assuming that data is retrieved but not displayed because char limit property has not been increased on datawindow field. But setting 'auto resize' property on band and field is also important.

regards-
0
 
LVL 17

Author Comment

by:BudDurland
Comment Utility
This is not a PowerBuilder datawindow; it's an InfoMaker report.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 15

Expert Comment

by:namasi_navaretnam
Comment Utility
Yes. But the same idea applies.

Click on the report field. Select Edit tab from the Properties pane. You will see limit property. You can increase the Limit to match the table definition.

Regards-
0
 
LVL 17

Author Comment

by:BudDurland
Comment Utility
I had tried seting all the character size limits I could find before askign the question, do no avail.

I did, however, find the answer.  Dropping the field from the report, and removing it from the SQL SELECT statement took care of the problem.  It didn't work on the first try though --  I had to remove the field, saved the report, restart Infomaker, then re-add the field
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
Comment Utility
User resolved; points (250) refunded and question closed.

Netminder
Site Admin
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now