That is also my experience. I have had issues of all sorts over the years but
never had one with note/text fields.
Javier Valencia, PE
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: karentellef via RBASE-L <[email protected]>
Date: 1/16/17 8:51 AM (GMT-06:00)
To: [email protected]
Subject: Re: [RBASE-L] - Odd Report Action
Although I've heard that for years (decades), I have not yet separated any of
my Note columns into separate tables. Not one table in any database... Never
had an issue yet so "if it ain't broke", I'm not going to change mine yet.
Karen
-----Original Message-----
From: Tom Frederick <[email protected]>
To: '[email protected]' <[email protected]>
Sent: Mon, Jan 16, 2017 8:39 am
Subject: RE: [RBASE-L] - Odd Report Action
#AOLMsgPart_2_03aab290-286b-44a8-8230-9d8fc9178182 td{color: black;} @font-face
{font-family:Helvetica; panose-1:2 11 6 4 2 2 2 2 2 4;}@font-face
{font-family:Helvetica; panose-1:2 11 6 4 2 2 2 2 2 4;}@font-face
{font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;}@font-face
{font-family:"Lucida Console"; panose-1:2 11 6 9 4 5 4 2 2 4;}.aolReplacedBody
p.MsoNormal,.aolReplacedBody li.MsoNormal,.aolReplacedBody div.MsoNormal
{margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New
Roman","serif";}.aolReplacedBody a:link,.aolReplacedBody span.MsoHyperlink
{mso-style-priority:99; color:blue; text-decoration:underline;}.aolReplacedBody
a:visited,.aolReplacedBody span.MsoHyperlinkFollowed {mso-style-priority:99;
color:purple; text-decoration:underline;}.aolReplacedBody p
{mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in;
mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt;
font-family:"Times New Roman","serif";}.aolReplacedBody
p.MsoAcetate,.aolReplacedBody li.MsoAcetate,.aolReplacedBody div.MsoAcetate
{mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0in;
margin-bottom:.0001pt; font-size:8.0pt;
font-family:"Tahoma","sans-serif";}.aolReplacedBody span.EmailStyle18
{mso-style-type:personal-reply; font-family:"Calibri","sans-serif";
color:#1F497D;}.aolReplacedBody span.BalloonTextChar {mso-style-name:"Balloon
Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}.aolReplacedBody .MsoChpDefault
{mso-style-type:export-only; font-size:10.0pt;}@page WordSection1 {size:8.5in
11.0in; margin:1.0in 1.0in 1.0in 1.0in;}.aolReplacedBody div.WordSection1
{page:WordSection1;}
Jan and James
Thanks. This is one of those things I vaguely ‘knew’, but had not experienced
because everything worked. This one field ranges from 25 to 2,195 characters
depending on the writer so that variable length is a serious issue. One more
learning piece. Time to separate all NOTEs to their own tables.
Tom Frederick
From: 'James Bentley' via RBASE-L [mailto:[email protected]]
Sent: Sunday, January 15, 2017 9:03 PM
To: [email protected]
Subject: Re: [RBASE-L] - Odd Report Action
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 more
note fields. I experienced the problem many years ago when one of the main
tables in my
database 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.
--
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.
