Hi Cetin!

There's no eof() method. Sorry for the confusion (sometimes I still think in Clipper, which is a bit more "oopish" in aliasing expresions.

What I meant is that if I navigate programmatically to a record in the parent table, when I check eof() condition for the child (? eof( "books")), I get .T..

When I navigate the parent table through a browse window (by clicking on a record), the browse window for the child table shows the right children (no eof() there).

Alex


>>Hi Everybody, happy new year!
>>
>>I ran into something interesting today and am intrigued by it...
>>
>>I need to establish a relation between tables that belong to different databases.
>>
>>The code looks something like this:

use dbc1!authors
>>use dbc2!books in 0
>>select authors
>>set relation to AuthorID into books

When I run the above, and open a browse window for each table and move around in the parent, the child's browse updates correctly, showing only records that are children of the record selected in the parent table.
>>
>>However, if I do the following in the command window, it doesn't work:

select authors
>>goto 5
>>? books.eof() && This one yields .t. - it's as if the record pointer stays at eof() in the child area.

>>
>>Any ideas?
>>
>>Thanks!
>
>Alex,
>What is the code in eof() method?
>Cetin