StaffID,
StaffName,
LeaveTitle,
LvStartDate,
LvEndDate

EmplyID,
EmplyName,
Lv_Title,
Lv_Start_Date,
Lv_End_Date

StaffID=EmplyID
StaffName=EmplyName
LeaveTitle=Lv_Title
LvStartDate=Lv_Start_Date
LvEndDate=Lv_Start_Date

**notesDocument.ReplaceItemValue( itemName$, value )**

IF EXISTS (SELECT * FROM SYSTEM.PS_UNI_KP_CUTI WHERE EMPLID='011' AND TARIKH_MULA_CUTI = '16-Mar-12';)

    UPDATE SYSTEM.PS_UNI_KP_CUTI
    SET EMPLID = '011',
    JENIS_CUTI='Annual Leave',
    KUASA_MELULUS_CUTI='Approve',
    TARIKH_MULA_CUTI='16-Mar-12',
    TARIKH_TAMAT_CUTI='16-Mar-12';
    WHERE EMPLID ='011' AND TARIKH_MULA_CUTI='16-Mar-12'

ELSE

   INSERT INTO SYSTEM.PS_UNI_KP_CUTI(EMPLID,JENIS_CUTI,KUASA_MELULUS_CUTI,TARIK_MULA_CUTI,TARIKH_TAMAT_CUTI)

    VALUE('011','Annual Leave','Approve','16-Mar-12','16-Mar-12');