Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Small adjustment needed on recycle approach
Message
From
07/05/2003 11:43:29
 
 
To
07/05/2003 00:42:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00785663
Message ID:
00785853
Views:
21
Hello Michel

i remember there was a lengthy thread aubout this exact subject a few weeks ago here on ut. the endresult of this discussion, i believe, was that everytime you make a change, or add to a memo field, vfp completely rewrites/adds the entire contents of that field to the memo file. vfp completely ignores the 'old' stuff in the file, and you end up with blowding memo files.


>I need a small adjustment in this recycle approach. Basically, it recycles. It's just that the memo file keeps increasing. I can't seem to find what I'm missing here.
>
>
>IF NOT tlRecycle
>   INSERT INTO (ALIAS()) (Numero) VALUES (GetNumero(ALIAS()))
>   ELSE
>   SET DELETED OFF
>   LOCATE FOR DELETED()
>   SET DELETED ON
>   llFound=FOUND()
>   IF llFound
>      RECALL
>      BLANK
>      REPLACE Numero WITH GetNumero(ALIAS())
>      ELSE
>      INSERT INTO (ALIAS()) (Numero) VALUES (GetNumero(ALIAS()))
>   ENDIF
>ENDIF
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform