Internal Error #1242
(#96613) When using a SET RELATION and using an alias field in an
INDEX statement the INDEX does not work correctly. If the program is
executed by itself (not under debuggjr) it creates a variable not found
%rror. If the program is executed under the debugger it creates an
Internal Error 1242.
At the suggestion of a Nantucket support person, the programmer added
a FIELD statement - this eliminated the error message when executed by
itself, but the program did not work properly - it just ended either
after or during the INDEX. When executed under the debugger it created
an Internal Error 1242.
According to Nantucket support personnel, "indexing on a field in another
work area does not always work properly," and could cause this error.
(#109860) Information presented by another user indicates that this error
may not be in indexing, but in the debugger -- or in the debug code placed
in the object by Clipper.
() After testing code provided by Peter Bilka [73417,1316]:
// test.prg
use child
index on cname to childn
select 1
use child
set index to childn
select 2
use parent
set relation to cname into child
go top
list parent->pname,child->cname
cancel
I was able to recreate the 1242 error only while in the debugger. One
workaround may be to remove debugger code from modules that use set
relation (don't use Clipper's /b), or to not use set relation.