I have a very simple Bit button that allows the sales individual to
print a specific report based on their filling out the WHERE builder.  

The command is below. It was suggested I use a Variable List View as a
means of allowing them to choose the specific orders rather than typing
them into a WHERE clause.  I would like to do just that.  I have never
used the Variable List View and have tried to figure it out but the HELP
has not given me much information.  Is there a thread I could read to
help me understand how to use it properly?

 

Jim

 

-- Print Outsource PO by a list of Control#. --

CLEAR VAR vchoice, vcount, vin0

SET VARIABLE vchoice TEXT = NULL

SET VAR vcount INTEGER = 0

SET ERROR MESSAGE 2045 OFF

CHOOSE vchoice FROM #WHERE IN Orders

SELECT COUNT (*)  INTO vcount IND vin0 FROM Orders &vchoice

IF vcount > 0 THEN

  PRINT KayParkOutsourcePO &vchoice +

  OPTION SCREEN|WINDOW_STATE MAXIMIZED +

  |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 100

ELSE

  PAUSE 2 USING 'No Matching Records Found!'

ENDIF

CLEAR VAR vchoice, vcount, vin0

SET ERROR MESSAGE 2045 ON

RETURN

Reply via email to