[RBG7-L] - Re: Check Box

[A. Razzak Memon]

At 10:15 AM 8/25/2004 -0400, Joe Solomon wrote:

Does anyone know how to use a check box to select multiple records in a
table?  I need to check or select more than one item from a list and then
use the selections in an application.

I'm assuming you are talking about CheckBox in CHOOSE command.

If that is the case, try the following syntax:

CLS
CHOOSE varname FROM #VALUES FOR (columns),retcol +
FROM tblview +
WHERE whereclause +
ORDER BY orderclause +
CHKBOX n +
TITLE 'tile text here' +
CAPTION 'caption text here' +
LINES n +
FORMATTED +
OPTION WINDOW_CAPTION SMALL +
|TITLE_BACK_COLOR WHITE +
|TITLE_FONT_NAME TIMES NEW ROMAN +
|TITLE_FONT_SIZE 24 +
|TITLE_FONT_COLOR TEAL +
|TITLE_BOLD OFF +
|TITLE_ITALIC OFF +
|TITLE_UNDERLINE OFF +
|TITLE_STRIKEOUT OFF +
|LIST_BACK_COLOR TEAL +
|LIST_FONT_NAME VERDANA +
|LIST_FONT_SIZE 12 +
|LIST_FONT_COLOR WHITE +
|LIST_BOLD OFF +
|LIST_ITALIC OFF +
|LIST_UNDERLINE OFF +
|LIST_STRIKEOUT OFF +
|WINDOW_BACK_COLOR WHITE +
|BUTTON_OK_CAPTION OK +
|BUTTON_CANCEL_CAPTION Cancel +
|BUTTONS_BACK_COLOR WHITE +
|BUTTONS_SHOW_GLYPH ON

Where CHKBOX n is the number of items allowed.

CHKBOX without assigning a number will give you what you want!

For complete syntax, samples and templates, use R:Docs:

R:Docs| Build Syntax for CHOOSE Command
or
R:Docs| Templates

Have fun!

Very Best R:egards,

Razzak.