Browse Query

[Emma]

Using Progress 9.1.C on NT 4.0.

I have a table with more than one record having the same value in a given field, ie.

Records...

             Field 1    Field 2
1            fruit        east
2            fruit        west
3            fruit        south
4            turkey    west
5            chicken  east

I want only records 1,4 and 5 to display in the browser.  Can this be done without the use of a temp table?

Thanks

 

[mra]

I can't imagine how!! :blue:


Regards
Mike

 

[Unregistered]

Try using a find trigger on the buffer you use in the browse.

on find of <buffer-name>:

def buffer b for <buffer-name>.

if can-find(first b where .....) then
return error.

end.

Chris Kirkham
Kial Consultants Ltd
chris.kirkham@kial.co.uk