Subject solved DataModule issue From edward racht <e.racht@gmail.com> Date Tue, 18 Sep 2018 05:38:22 -0400 Newsgroups dbase.getting-started Mervyn and Tim, > The DMD does not respond to the "distinct" request in the canGetRow. > It lists both the O and R values. > Using the dmd for the "distinct O" loads both the O and the R values.       canGetRow = {||not empty( this.fields[ "CE" ].value ) AND ;                      upper( this.fields[ "ORP" ].value ) == upper( "O" ) AND ;                      empty( this.fields[ "OW" ].value )} This code works for querying on a distinct "O" value in a dmd. ed