Thank you Tore
It makes sense, however:
SELECT prog_long works fine, but SELECT chrtran(prog_long,",","") result error message "variable prog_long not found"
Do you think a select command does not accept so many instructions ?
Moises
>chrtran(prog_long,",","")
>
>>Tore
>>
>>thisform.days.value is working
>>
>>The variable not found is prog_long if treated with GETWORDNUM()
>>
>>I am just trying to remove the comma from prog_long as suggest by Rich.
>>
>>It there another way to do it inside the select command ?
>>
>>Moises
>>
>>
>>
>>
>>>Replace thisform.days.value with a variable.
>>>
>>>>Hi Rich
>>>>
>>>>I replaced it as you said:
>>>>
>>>>SELECT GETWORDNUM(Prog_long,1,",") , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>>>>
>>>>But I got the error message "variable not found".
>>>>
>>>>It seems the command is not accepted in a line, or am I doing something wrong ?
>>>>
>>>>Moises
>>>>
>>>>
>>>>>>I am using the code below to group results,but the problem is that some records have a comma which duplicates some results
>>>>>>
>>>>>>eg:
>>>>>>
>>>>>>Yellow
>>>>>>blue
>>>>>>blue,
>>>>>>green
>>>>>>red
>>>>>>red,
>>>>>>
>>>>>>Is there a way to remove the comma only from the the result of the code below without removing the commas from the original table ?
>>>>>>
>>>>>>
>>>>>>SELECT Prog_long , COUNT(*) AS Quant FROM reembolso GROUP BY prog_long where reembolso.date > DATE()-thisform.days.value INTO CURSOR crsReemb ORDER BY quant DESC
>>>>>
>>>>>Try......
>>>>>
GETWORDNUM(myfield,1,",")