Thanks Razzak. But when I use this coding I have a problem. The varname in the CHOOSE command gives me a list of the selected items separated by comma's. For example, empid is the retcol and I get (245, 257, 289). How can I use this data to access the employee records for each of those that were selected?
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 10:24 AM Subject: [RBG7-L] - Re: Check Box > 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. >
