Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table from Vertical to horizontal
Message
De
08/12/2008 10:32:35
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01365804
Message ID:
01365961
Vues:
7
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform