Depending on the Index Expressions, what I said might be the problem.
INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName] [FOR lExpression]
For example you could have a problem with a Blank record if the active Index were containing something like:
Code:
INDEX ON Field2 TAG Fld2 [B]FOR !EMPTY(Field2)[/B]
or
INDEX ON [B]!EMPTY(Field2)[/B] TAG Fld2
And I agree with Olaf above, get rid of using references to Workspaces (
SELECT 3).
Instead use the Alias name such as:
Code:
SELECT ThisDBF && Replacing old code - SELE 3
APPEND BLANK
GATHER MEMVAR
It will better ensure that you are working on the expected table and not, by accident, on another table.
Another item to check is what you are using for your SCATTER MEMVAR source. If the source data is not really as expected, then, after the GATHER MEMVAR, the record contents might not be as intended and the Index might be preventing the new record from being seen.
To test out where the problem might be...
1. Make a copy of your data table and do the following Test work on the copy, not the original.
2.
Code:
USE DBFCopy in 0
SELECT DBFCopy
* --- Test First with No Active Index ---
SCATTER MEMVAR
APPEND BLANK
GATHER MEMVAR
3. BROWSE
4. Examine the results. Record #1 should look the same as the last record.
If everything works in this non-index test, then the problem is either the source of the MEMVAR data or it is a problem with the Index.
Good Luck,
JRB-Bldr