Further to this, if you’ve been making a lot of changes to forms and/or reports, the .RB4 will grow since each time you save the form it will take new space at the end of the file.
Try this: OUTPUT dbname.all UNLOAD ALL OUTPUT SCREEN RENAME dbname.rb* olddbname.rb* RUN dbname.all This will remove the dead space from your .RB4. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, April 01, 2009 4:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Searching for large VARCHAR in database Aren't the 7.x forms and reports stored in the .rb4 file? That could be where all your space is being used up... You can always set form compression on if you want. Karen I don't know how many tables and VARCHAR fields are in the database but the following command might help locate the rows. Select UniqueIdentiferColumn (SLEN(varcharColumn)) from Table where (SLEN(varcharColumn)) >2000 You can play with the threshold number to reduce the data set. I believe you need 7.6 and up to use SLEN with VARCHAR. Jim >>>"Heffelfinger, Duane" <[email protected]> 3/31/2009 3:28 PM >>> Good afternoon, Is there a way with R:Scope or a select trick to figure out what table is holding a large chunk of data in the .rb4 file? Even better can I figure out what table and row would be holding large VARCHARs values in the .rb4? Someone, somewhere has added several very large VARCHAR data chunks into the .rb4 and I would really like to know what table and row it’s attached to. Thanks for any ideas. Duey
