Local laCalificaciones[1], ;
laField[1], ;
lcMatricula As String, ;
lcMes As String, ;
lnFields As Number, ;
lnMateria As Number, ;
lnMes As Number
Create Cursor Calificaciones (Matricula C(5), Alumno C(10), Espanyol N(2), Matematicas N(2), Ciencias N(2), Mes N(2))
Insert Into Calificaciones Values ("12345", "Juan", 10, 8, 7, 1)
Insert Into Calificaciones Values ("12345", "Juan", 8, 9, 7, 2)
Insert Into Calificaciones Values ("12345", "Juan", 9, 8, 7, 3)
lcMatricula = "12345"
lnFields = Afields(laField, "Calificaciones")
Select * ;
From Calificaciones ;
Where Matricula == m.lcMatricula ;
Order By Matricula, Mes ;
Into Array laCalificaciones
Create Cursor curCalificaciones (Matricula C(5), Alumno C(10), Materia C(15), Mes1 N(2), Mes2 N(2), Mes3 N(2))
For lnMateria = 1 To 3
Insert Into curCalificaciones ;
Values ( m.laCalificaciones[m.lnMateria, 1] ;
, m.laCalificaciones[m.lnMateria, 2] ;
, m.laField[m.lnMateria + 2, 1] ;
, 0, 0, 0)
For lnMes = 1 To 3
lcMes = "Mes" + Transform(m.lnMes)
Replace (m.lcMes) With m.laCalificaciones[m.lnMes, m.lnMateria + 2] ;
In curCalificaciones
Endfor
Endfor
Select curCalificaciones
Browse