A test with a created sample ( a combination of UNIQUE and RELATION ).
The same effect :
On 1. click in browser 2 on row 4 < Acker > ( selected in browser 1 ),
the 1. row is shown as selected ( moved )
On 2. click ( same row ) the selected row stays activated.
The effect is shown only on FIRST CLICK !!!
Selecting another name in browser 1 and going back to < Acker >
the same effect happens.
The sample includes 2 DBF's with the same names
In DBF 2, Acker is defined 4 times testing RELATION
The UNIQUE - test-button shows < Fuller > defined twice in browser 1 only once
Download :
http://www.pflegeplus.com/DOWNLOADS/Relation1.zip
USE customer1 NEW SHARED ALIAS CUST1 VIA 'DBFCDX'
ORDCREATE( ,"CUST1", "UPPER(LAST)", ;
{|| UPPER(LAST) } , .F. )
ORDCREATE( ,"CUST2", "UPPER(LAST)", ;
{|| UPPER(LAST) } , .T. ) // .T. = UNIQUE
DBSETORDER("CUST1")
USE customer2 NEW SHARED ALIAS CUST2 VIA 'DBFCDX'
ORDCREATE( ,"CUST3", "UPPER(LAST)", ;
{|| UPPER(LAST) } , .F. )
DBSETORDER("CUST3")
--------
DBSELECTAREA( "CUST1" )
("CUST1")->(DBSETORDER( "CUST1" ))
("CUST1")->( ORDSETRELATION( "CUST2", { || UPPER(LAST) }, "UPPER(LAST)" ) )
("CUST1")->( DBGOTOP() )
@ 10,10 XBROWSE oBrw1 ;
COLUMNS 'Last', 'Age', 'Salary' ;
OF oDlg ;
SIZE 220, 100 PIXEL ;
PICTURES nil, '999.99 %' ;
ALIAS 'CUST1' ;CELL LINES AUTOSORT NOBORDER FOOTERS
...
...
@ 150,10 XBROWSE oBrw2 ;
COLUMNS 'Last', 'Age', 'Salary' ;
OF oDlg ;
SIZE 220, 100 PIXEL ;
PICTURES nil, '999.99 %' ;
ALIAS 'CUST2' ;CELL LINES AUTOSORT NOBORDER FOOTERS
best regards
Uwe
