Mike - Try your BROWSE with LAYOUT OFF/ON see if that makes any difference. If it does, then delete the rows in SYS_LAYOUTS for this table. They could be corrupted.
Also - does it work if you SELECT * FROM table? Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 13214 W. 62nd Terr, #139 Shawnee KS 66216 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 2:56 PM Subject: RE: Table too big? -- Update - Razzak's Reply > 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 > > ================================================ 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
