VS 2.2 text fields

[Ruslan Zasukhin]

On 2/24/06 7:15 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:

Hi Martin,

First of all it is good idea to DIAGNOSE your 1.x db.

If it have problems then do XML dump/load into 1.x db again.

After that convert to 2


> My database is 350MB at the moment. I tried to reduce it by removing 3 of
> the 4 table and had some other problems - maybe related to the one below.
> 
> First I removed the 3 of 4 tables, this worked fine. I can re-open the
> database and it all looks OK - although the .blb file is still 310MB.
> 
> So I then re-index the db and its still OK - but the .blb file is still
> 310MB.
> 
> Then I Defragment the database and the .blb file is down to 3MB - But all
> the data in the fields with datatype 'text' is gone.
> 
> If I do the same process as above but 'Compact' insread of 'Defragment' I
> get the same result - no data in the fields of datatype 'Text'.
> 
> Any ideas?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]