This is one of those areas where you do not think about the affect of a field unless it messes a report. I have some note fields in separate tables but others within main tables. Good notes to keep for the future, just in case.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Sunday, January 15, 2017 5:17 PM To: [email protected] Subject: Re: [RBASE-L] - Odd Report Action Tom, I moved to separate NOTE tables. If I remember correctly, NOTE can be 4096. However it is limited by the other fields in the row. Just a thought. Jan -----Original Message----- From: "Tom Frederick" <[email protected]<mailto:[email protected]>> To: <[email protected]<mailto:[email protected]>> Date: Sun, 15 Jan 2017 15:55:00 -0600 Subject: [RBASE-L] - Odd Report Action I have a large, complicated report with has 20 sections based on 12 view based subreports. It has run correctly for several years. I can repeatedly run this report for any number of people and create a complete 20 section report. Recently I had one person where this report built everything except sections XI/XII. After many attempts, I tracked down the field in a record that was causing the problem for that one person. The field was a NOTE that had about 100 characters. It is the only NOTE in this table. There were no strange characters that I could see. Simply rewriting the NOTE ended the problem. This same field in other rows often had over 1400 characters so NOTE works. Using RBXE latest updates. So I have two questions: 1. Is there some way to identify when non-text items are in a field? 2. I used to have many NOTEs in tables. Most of those got changed to TEXT based how much users actually wrote over time. Numerous RBase examples have Notes in the associated Tables. Is this print problem an indication that I need to completely move to separate NOTE tables? Tom Frederick -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
