Hmmmm ...
Now I'm getting curious.
Can you pkzip the file and send to mailto:[EMAIL PROTECTED]
I want to see what is going on with the ccPublisher table.
Very Best R:egards,
Razzak.
At 03:10 PM 9/26/2003 -0500, Charlie Parks wrote:
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
> > >
