General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only