That part worked. It display the list of publishers. -----Original Message----- From: A. Razzak Memon [mailto:[EMAIL PROTECTED] Posted At: Friday, September 26, 2003 2:02 PM Posted To: RB6-L Conversation: [RBASE-L] - Re: Choose syntax - Razzak's Reply Subject: [RBASE-L] - Re: Choose syntax - Razzak's Reply
Charlie, What happens when you use the following syntax: SELECT Publisher FROM ccPublisher GROUP BY Publisher Very Best R:egards, Razzak. At 01:54 PM 9/26/2003 -0500, Charlie Parks wrote: >I just tried both of those and they both failed. What should I look for >in relationship to a possible corrupted table? This is the only time this >choose command syntax would not work for me. > >The syntax works for other tables in the same database. It is just this >one particular table that is not working. > >-----Original Message----- >From: A. Razzak Memon [mailto:[EMAIL PROTECTED] >Posted At: Friday, September 26, 2003 1:16 PM >Posted To: RB6-L >Conversation: [RBASE-L] - Re: Choose syntax - Razzak's Reply >Subject: [RBASE-L] - Re: Choose syntax - Razzak's Reply > > > >Charlie, > >Try the following: > >CLEAR VAR vSub >SET VAR vSub TEXT = NULL >CHOOSE vSub FROM #VALUES + >FOR Publisher + >FROM ccPublisher + >GROUP BY Publisher > >OR > >CLEAR VAR vSub >CHOOSE vSub FROM #VALUES + >FOR Publisher + >FROM ccPublishers + >GROUP BY Publisher + >TITLE 'Press [Esc] to Return to Menu' + >CAPTION 'Choose Publisher' LINES 20 > >Have Fun! > >Very Best R:egards, > >Razzak. > >At 01:09 PM 9/26/2003 -0500, Charlie Parks wrote: > > >It is still failing on me with this syntax: > > CHOOSE vsub FROM #VALUES + > > FOR DISTINCT (CTXT(publisher)) + > > FROM ccPublishers + > > ORDER BY Publisher > > > > > >-----Original Message----- > >From: Troy Sosamon [mailto:[EMAIL PROTECTED] > >Posted At: Friday, September 26, 2003 9:11 AM > >Posted To: RB6-L > >Conversation: [RBASE-L] - Re: Choose syntax > >Subject: [RBASE-L] - Re: Choose syntax > > > > > >Take everything off after the order by clause and see if it works. > > > >Troy > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles > >Parks > >Sent: Friday, September 26, 2003 7:58 AM > >To: RBASE-L Mailing List > >Subject: [RBASE-L] - Re: Choose syntax > > > > > >This is currently how I have the code: > > > > SET WALKMENU ON > > CHOOSE vsub FROM #VALUES + > > FOR DISTINCT (CTXT(publisher)) + > > FROM ccPublishers + > > ORDER BY Publisher + > > TITLE 'Press [Esc] to Return to Menu' + > > CAPTION 'Choose Publisher' LINES 20 > > > >Publisher is text 40. > > > >Still, it seems to not be working. > > > >-----Original Message----- > >From: Troy Sosamon [mailto:[EMAIL PROTECTED] > >Posted At: Friday, September 26, 2003 8:41 AM > >Posted To: RB6-L > >Conversation: [RBASE-L] - Re: Choose syntax > >Subject: [RBASE-L] - Re: Choose syntax > > > > > >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 > > >
