If you break the notes out into another table, the occasional broken pointer will probably go away or at least move to the note table. If you don't edit notes, the borken pointers will most likely completly go away. I have found editing notes has a much higher probability of causing problems. If your note table has over 100,000 rows, I wouldn't allow editing of the notes, but just re-insert the note and flag the old one to get deleted and then delete all of the flagged notes in batch at night.
Troy ===== Original Message from [EMAIL PROTECTED] at 6/05/02 10:45 am >Razzak, Troy, Javier - > >Thanks so much for the tech tips - you folks have been a great help in >time of need! > >Troy, separating out notes to another table a good idea, as occasional >fix of broken pointers on this table not possible with automatic setting >in R:scope. Thanks again! > >Best regards, >Brad > >"A. Razzak Memon" wrote: > >> At 11:35 AM 6/4/2002 -0700, Brad Davidson wrote: >> >> >RBase 2000 DOS 6.5++ Bld 1.851xRT03 - >> > >> >.. Is there a way to select those rows by column WO where the note >> >field Work_Accomplished exceeds a predetermined value, say > 100kb? >> >> Brad, >> >> Option 01: >> >> SELECT * FROM TableName WHERE (SLEN(TextNoteColName)) > 4096 >> >> Option 02: >> >> SELECT (MAX(SLEN(TextNoteColName))) FROM TableName >> >> Option 03: >> >> SELECT (MAX(SLEN(TextNoteColName))) INTO v1 INDIC iv1 FROM TableName >> >> Hope that helps! >> >> Very Best Regards, >> >> Razzak. >> >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: INTRO rbase-l >> ================================================ >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> ================================================ >> TO SEARCH ARCHIVES: >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
