Hello,
thank you ,this is my code
SELECT 1
LOCATE FOR UPPER(NO)=UPPER(TRIM(THISFORM.TEXT1.VALUE)) .AND. UPPER(NAM)=UPPER(TRIM(THISFORM.TEXT9.VALUE))
IF !FOUND()
SCATTER MEMVAR blank
no=thisform.text1.value
nam=thisform.text2.value
desc=thisform.text3.value
unit=thisform.text4.value
total=thisform.text7.value
min=thisform.text6.value
GATHER MEMVAR
ELSE
IF THISFORM.TEXT1.VALUE=THISFORM.TEXT10.VALUE .AND. THISFORM.TEXT2.VALUE=THISFORM.TEXT11.VALUE
SCATTER MEMVAR blank
no=thisform.text1.value
nam=thisform.text2.value
desc=thisform.text3.value
unit=thisform.text4.value
total=thisform.text7.value
min=thisform.text6.value
GATHER MEMVAR
ELSE
=MESSAGEBOX("you have this number and name before")
ENDIF
ENDIF
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