I can't tell you how many times I have missed the same thing! Whenever I have a select like this that does not work, I try it in a code file:
SELECT SC,XREF,TDATE,(RJS(CTXT(AMOUNT),10)),DESCRIPT from tablename whereclause Your original would have errored. You can then edit the code file until it works, then cut and paste the part you need. This is a trick I have always used when creating CHOOSE commands. Choose command ofter say "no records returned" instead of "syntax error" in a case like this. Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 26, 2008 9:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: List Box and List View not doing what I want Dennis: Don't let anyone tell you your eyes are failing! Nice pickup! I missed the width! I forgot that a simple RJS won't work! Now this works. I still can't get the multi-select list view to work, though .... But for now this will work! And thanks Razzak -- I'm sure you'll soon tell me the same solution to my "problem"! Karen Karen, You missed nn in your RJS SC,XREF,TDATE,(RJS(CTXT(AMOUNT),10)),DESCRIPT Dennis McGrath
