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,",")