>Example of a problem I found yesterdaqy which probably is a bug, but could not make repro code. In a grid in the AfterRowColchange
>
>
SELECT SomeTable
>IF !EOF() AND RECNO() > 0
> GO RECNO() IN someTable
>ENDIF
>
>No filters in effect, One active non filtered index, via the debugger I found no other code running besides this, but it was erroring on a newly added record (Tablebuffered). I spend two hours to find the exect cause, but eventually found a workarround to the problem.
I think the essence of this bug is that recno() still refers to recno() of the currently selected alias, not of SomeTable, despite the "in sometable" designation. If it would work with GO RECNO("sometable") IN someTable, then I think that's it. The bug is in what we were led to believe, that anything we put in a command with "in sometable" will work as if we have selected that table - but it may be not so. This needs to be further poked... Fabio? :).