is there a recommended way in FPW 2.6 to add a line to the end of a memo field? I have been using : replace memo_field with memo_field + new_line and every once in a while the FPT file blows up to a large size (2 or 3 times normal size). I'm guessing it blows up because someone uses a utility to add a line to a large number of records at once.
Is there a command that prevents the bloat?
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
On 28/04/2017 10:15, Michael Madigan wrote:
is there a recommended way in FPW 2.6 to add a line to the end of a memo field? I have been using : replace memo_field with memo_field + new_line and every once in a while the FPT file blows up to a large size (2 or 3 times normal size). I'm guessing it blows up because someone uses a utility to add a line to a large number of records at once.
Is there a command that prevents the bloat?
You can reduce the bloat with (backup first of course) USE myfile EXCLUSIVE PACK MEMO
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
Hi Michael,
in fact each time you modify a memo field, its previous space is marked as 'unused' and a new space is created on the HDD. I think that the only way to avoid the size to grow is to PACK MEMO the table at the end of the update (or perhaps during the update if the size'grow (is it understandable ?) may reach the HDD size).
HTH The Foxil
Thank you
From: Jean MAURICE jsm.maurice@wanadoo.fr To: profox@leafe.com Sent: Friday, April 28, 2017 5:39 AM Subject: Re: is there a proper way in FPW 2.6 to add a line to the end of a memo?
Hi Michael,
in fact each time you modify a memo field, its previous space is marked as 'unused' and a new space is created on the HDD. I think that the only way to avoid the size to grow is to PACK MEMO the table at the end of the update (or perhaps during the update if the size'grow (is it understandable ?) may reach the HDD size).
HTH The Foxil
[excessive quoting removed by server]
-
Jean MAURICE -
Michael Madigan -
Peter Cushing