replace spaces with underscore, e.g.
select distinct strtran(subject," ","_") as Subject from myTable
then follow the original logic.
>Dear Naomi
>here is what I got as paremter
>"lcsubject=, Math I"
>
>When I ignoring the error I got another error on line 18 "Variable subject is not found"
>and I think they are related
>sorry to bother you again
>
>
>Select distinct subject from Report into cursor c_UniqueSubjects nofilter
>
> local lcSubjects, lnCount
> lcSubjects = ""
> select c_UniqueSubjects
> lnCount = 0
> scan
> lcSubjects = ", " + Subject + "I"
> local &lcsubjects "here I am getting the same error" command not recognized"
> endscan
>
> create cursor c_FinalResult (iID I, cStudentName C(40) &lcSubjects)
> index on iID tag iID
>
> select Report
> set order to StudentID
> scan
> if not seek(StudentID, 'c_FinalResult')
> insert into c_FinalResult (iID, cStudentName) values (Report.STUDENTID, Report.Name)
> endif
> store Report.Mark to ( "m." + Subject)
> replace (Subject) with ("m." + Subject) in c_FinalResult "Variable subject is not found"
>
> endscan
If it's not broken, fix it until it is.
My Blog