CODING MENAMPILKAN DATA GURU DI GRID ( tahun ajaran dan mata pelajaran)
*===============================================================
`
thisform.grdtbmapelampu.RecordSource="SELECT tbmapelampu.thnajaran, tbmapelampu.nip,;
tbguru.nguru FROM dbsiakad!tbmapelampu inner join dbsiakad!tbguru ;
on tbguru.nips=tbmapelampu.nip;
WHERE
ALLTRIM(tbmapelampu.kdmapel)+ALLTRIM(tbmapelampu.thnajaran)=ALLTRIM('"+alltrim(thisform.txtKdmapel.Value)+alltrim(thisform.combo1.value)+"');
INTO CURSOR 'xcursor' "
thisform.grdtbmapelampu.Refresh
*===============================================================
thisform.grdtbmapelampu.RecordSource="SELECT tbmapelampu.thnajaran, tbmapelampu.nip,;
tbguru.nguru FROM dbsiakad!tbmapelampu inner join dbsiakad!tbguru ;
on tbguru.nips=tbmapelampu.nip;
WHERE
ALLTRIM(tbmapelampu.kdmapel)+ALLTRIM(tbmapelampu.thnajaran)=ALLTRIM('"+alltrim(thisform.txtKdmapel.Value)+alltrim(thisform.combo1.value)+"');
INTO CURSOR 'xcursor' "
thisform.grdtbmapelampu.Refresh
No comments:
Post a Comment