Path: utzoo!attcan!utgpu!news-server.csri.toronto.edu!mailrus!cs.utexas.edu!samsung!munnari.oz.au!bunyip!uqvax.decnet.uq.oz!wattle!zlcbeowen
From: zlcbeowen@qut.edu.au
Newsgroups: comp.databases
Subject: Clipper and lost memo records ... HELP!
Message-ID: <13220.26b95be0@qut.edu.au>
Date: 3 Aug 90 11:11:28 GMT
Organization: Queensland University of Technology
Lines: 26

We have a clipper application for journal control within the library.  It
was installed some months ago and we are still in the data entry phase.
After some months of operation, a .DBT file has grown to 16M, and now
we are having problems ...
 
Now when calling up the memo field of any record in the file using MEMOEDIT(),
the memo field is deleted on returning (by printing, modifying, or just
escaping back without change).  The offending line of code is:
 
    REPLACE biblio WITH MEMOEDIT(biblio,tr+1,tc+2,br-1,bc-2,.t.,"memo_func",;
        "","",init_row,init_col,init_rel_row,init_rel_col)

Re-indexing didn't help, but after repacking the .DBT file, the file shrank
to 10M and the problem disappeared.  The Clipper version is Summer '87.
 
Both the developer and our Clipper programmer are at a loss to explain why
this is occurring.  I suspect that MEMOEDIT() may be returning a blank 
record, but I don't really know anything about Clipper.

Has anyone else experienced this problem, or have any idea of where to look
for a solution?

Chris Owen                           | c_owen@qut.edu.au
Computer Based Education             | voice +61 7 223 2582
Queensland University of Technology  | FAX   +61 7 229 0874
Brisbane, Australia