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 > > > > > > >
