Tom,Including note fields along with other fields complicate autofix
capabilities of R:Base.This occurs because the table record become a variable
length when you have one or morenote fields. I experienced the problem many
years ago when one of the main tables in mydatabase became corrupted. Recovery
was very painful. Since then When I nee note fields i make a
separate table with a primary key that references the parent table as a foreign
key.
Jim Bentley, American Celiac Society 1-504-305-2968
From: jan johansen <[email protected]>
To: [email protected]
Sent: Sunday, January 15, 2017 5:16 PM
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]>
To: <[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].
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.
--
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.
