I have the following code:
SELECT 0
USE Table2
INDEX ON ALLTRIM(Field1) + ALLTRIM(Field2) TO MyIndex
SELECT 0
USE Table1
SET RELATION TO ALLTRIM(Field1) + ALLTRIM(Field2) INTO Table2
SCAN
SCATTER MEMVAR
IF NOT EOF("Table1")
SCAN
** some code here
ENDSCAN
ENDIF
ENDSCAN
Everything seems to work fine. The tables and index are set up ok, and the
relation is fine.
Except that when I run it, all records in the the child table are being hit.
If I browse Table2, I dont see the matching records until I browse Table1, but the data session window shows the relation. It's almost as if browsing them refreshes it somehow.
What gives?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people