I agree with Dennis' approach and often use a similar implementation with regard to NOTE and/or variable-width data types.
As Dennis implies, once one uses a structure like this, it doesn't take a lot of imagination to see how to extend its applicability. For example, a generic table structure : OPEN_END_NOTES(FK_ID,Relates_To_Field,In_Table,InsertedByUserID,InsertedOnDT TM,Comments,...) Could contain NOTEs related to multiple fields in MULTIPLE tables. This is probably too limited to be robust in a production system, but it should illustrate some of the possibilities. Steve in Memphis ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 12:56 PM Subject: [RBASE-L] - RE: Note Data Type > Also, maximum width of a row in a table is 4092 characters. The note > field will expand only to what is left from that limit. > > I like to put note fields in a separate table with a foreign key link > to the master table. That way, I only use storage I need, and my notes > can be over 4000 characters each. This will not change as the master > table is modified. > > Also I can have more than one note per row in the master table which > can be handy. > > In addition, if the master table gets corrupted, repair is lots easier. > > Dennis McGrath > > > > --- Javier Valencia <[EMAIL PROTECTED]> wrote: > > Steve: > > Make sure that your note field is not defined as being 200 in length. > > Right > > click on the table in question, select columns and check the length > > for this > > field. > > Javier, > > > > Javier Valencia, PE > > President > > Valencia Technology Group, L.L.C. > > 14315 S. Twilight Ln, Suite #14 > > Olathe, Kansas 66062-4578 > > Office (913)829-0888 > > Fax (913)649-2904 > > Cell (913)915-3137 > > ================================================ > > Attention: > > The information contained in this message and or attachments is > > intended > > only for the person or entity to which it is addressed and may > > contain > > confidential and/or privileged material. Any review, retransmission, > > dissemination or other use of, or taking of any action in reliance > > upon, > > this information by persons or entities other than the intended > > recipient > > is prohibited. If you received this in error, please contact the > > sender and > > delete the material from all system and destroy all copies. > > ====================================================== > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > > Fogelson, > > Steve > > Sent: Thursday, March 25, 2004 10:15 AM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Note Data Type > > > > I am trying to edit a Note data type column. I am trying to insert > > data into > > this field and it is only letting me put in 200 characters. > > > > I am editing while using the R:Base browse command and double > > clicking on > > the field. > > > > I thought this data type would got to over 4,000 characters. > > > > Thanks for any help. > > > > Steve Fogelson > > Internet Commerce Solutions > > >
