Hey all,

I can try to go into detail if need be, but the bottom line is that today we accomplished what I thought impossible. A single workarea had two aliases attached to it. i.e., the following expression was true:

SELECT('') = SELECT('')

HOW IS THIS POSSIBLE?

The error manifested itself as an "Illegal recursion in rule evaluation", number 1887, and of course that was happening, because as I was on my NUMBER table doing a LOCATE for a next key, Fox thought I was on a completely different alias!! We are using VFP 6.0 with SP3 installed.

Here is the wackiest bit...when we finally got the thing isolated and were able to view the work areas in the data session window, whenever we would highlight one area, it's partner area would be highlit as well!?!?!?! Has anyone seen anything like this before? We have nothing special going on...one work area was a view and another was the number table getting the next key when adding a record to that view (actually, TABLEUPDATEing the view, causing the table trigger to fire, etc.)

Any enlightenment would be appreciated.

Joe Kaufman
ENCOMPASS Health Mgmt. Systems
jkaufman@encompas.com