Solved

InfoMaker chops off Long Character fields

Posted on 2004-03-27
6
466 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
ID: 10697591
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
ID: 10697598
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
ID: 10703623
This is not a PowerBuilder datawindow; it's an InfoMaker report.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 10704069
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
ID: 10709956
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
ID: 10710660
User resolved; points (250) refunded and question closed.

Netminder
Site Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are many Password Managers (PM) out there to choose from. PM's can help with your password habits and routines, but they should not be a crutch you rely on too heavily. I also have an article for company/enterprise PM's.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

895 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

15 Experts available now in Live!

Get 1:1 Help Now