Simple Sports2000 browse example?

Posted by James Palmer on 04-Oct-2016 14:50

Don't suppose anyone's got a simple browse example against the Sports2000 database where different columns have different colours? I want to show off the translucent selection line feature in a talk and I'm getting myself tied up in knots! 

All Replies

Posted by Matt Gilarde on 04-Oct-2016 14:59

You just need to add COLUMN-BGCOLOR to the fields:

DEFINE BROWSE BROWSE-2
  QUERY BROWSE-2 NO-LOCK DISPLAY
      Customer.CustNum FORMAT ">>>>9":U COLUMN-BGCOLOR 10
      Customer.Name FORMAT "x(30)":U COLUMN-BGCOLOR 13
      Customer.City FORMAT "x(25)":U
      Customer.State FORMAT "x(20)":U
  WITH SEPARATORS MULTIPLE SIZE 72 BY 11.91 FIT-LAST-COLUMN.

Posted by James Palmer on 05-Oct-2016 14:28

Yes of course! Definitely left my brain behind somewhere there. Thanks.
 

This thread is closed