I did an UNLOAD ALL and then ran the unload file to get a clean start. Still have the same problem. I can browse any group of records from this table as long is it does not exceed 40. I have another table that has over 200 columns in it, 200 of which are double data types. When I do a BROWSE ALL from this table R:Base only displays 12 rows at a time, no crashes.
In the problem table most of the columns use underscores in the names. I thought on the outside chance that this might be a problem I recreated a test table structured the same way except without the underscores, reloaded the table and -- ended up with the same problem. Still searching. Thanks -- Mike Ramsour -----Original Message----- From: Troy Sosamon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 3:24 PM To: [EMAIL PROTECTED] Subject: RE: Table too big? -- Update - Razzak's Reply I would do it like this: >DISCONNECT >SET MULTI OFF >SET MESSAGES ON >SET ERR MESS ON set static off set error var er >CONNECT Concomp >RELOAD Boncomp >-- watch for any -ERRORS- if er <> 0 then -- errors occured during reload write 'Errors During reload - DID NOT COMPLETE' WHITE ON RED BLINK PAUSE 2 RETURN endif >DISC >DEL Concomp.RB? >REN Boncomp.RB? Concomp.RB? >SET MULTI ON >CONN Concomp >BROWSE TableName WHERE ... > Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 1/02/02 12:46 pm >At 02:34 PM 1/2/2002 -0500, Mike Ramsour wrote: >> >>Any other suggestions? > > >Mike, > >Make sure to RELOAD (not PACK) your database! > >Example: > >DISCONNECT >SET MULTI OFF >SET MESSAGES ON >SET ERR MESS ON >CONNECT Concomp >RELOAD Boncomp >-- watch for any -ERRORS- >DISC >DEL Concomp.RB? >REN Boncomp.RB? Concomp.RB? >SET MULTI ON >CONN Concomp >BROWSE TableName WHERE ... > >Have Fun! > >Very Best Regards, > >Razzak. > >===================================-============================ >R:BASE Developers's Conference: http://www.rbase.com/conference >Official R:BASE List Server: mailto:[EMAIL PROTECTED] >RBTI Events/Training: http://www.rbase2000.com/events >R:DCC Members: http://www.rbase2000.com/rdcc >================================================================ >R:BASE, Oterro & R:Tango are registered trademarks of RBTI. >==================================-============================= > >================================================ >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 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 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
