The field you are choosing needs to be text or else embed it in the ctxt function: (ctxt(someIntField))
Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Parks Sent: Friday, September 26, 2003 7:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Choose syntax The error actually seems to be table specific. I tried this choose on another table in the same database and it worked fine. What would be a good way to find out why it is not working on one table but works on another? -----Original Message----- From: Dennis McGrath [mailto:[EMAIL PROTECTED] Posted At: Friday, September 26, 2003 8:15 AM Posted To: RB6-L Conversation: [RBASE-L] - Re: Choose syntax Subject: [RBASE-L] - Re: Choose syntax Does it only fail in trace mode? Or does it always fail? Try RStyle on the code to see it it can tell you what is wrong with the structure of your code. The choose command looks ok to me. If nothing else helps try SET VAR vQ = '''' SET VAR vTmp = ('Press' & .vQ + ('[Esc]') + .vQ & 'to Return to Menu') CHOOSE vsub + FROM #VALUES + FOR publisher + FROM publishers + ORDER BY publisher + TITLE .vTmp + CAPTION 'Choose Publisher' + LINES 20 Dennis McGrath --- Charles Parks <[EMAIL PROTECTED]> wrote: > Is the following the correct syntax for a choose statement? > > CHOOSE vsub + > FROM #VALUES + > FOR publisher + > FROM publishers + > ORDER BY publisher + > TITLE 'Press ''[Esc]'' to Return to Menu' + > CAPTION 'Choose Publisher' + > LINES 20 > > For some reason when I am in trace mode and execute this command it > gives an error message about Endwhile. I have recently rebuilt my > database and it still gives that error. > > What am I doing wrong? > > Thanks, > Charlie >
