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 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.
