0 Replies - 216 Views - Last Post: 05 February 2013 - 02:08 AM Rate Topic: -----

#1 Guitora Kuronato  Icon User is offline

  • New D.I.C Head

Reputation: -7
  • View blog
  • Posts: 28
  • Joined: 02-December 12

Updatecod

Posted 05 February 2013 - 02:08 AM

Anyone please tell me the meaning of these code at update.
I dont know how to edit it
UPDATE       NFTB
SET                TIME_IN = '@REMARK', TIME_OUT = '@TIME_OUT', CHECKED_IN = ?, CHECKED_OUT = ?, IN_ON = ?, OUT_ON = ?, APP = ?, REMARKS =
WHERE        ([S/N] = ?) AND (? = 1 AND NOTIF IS NULL OR
                         NOTIF = ?) AND (? = 1 AND EMP_NO IS NULL OR
                         EMP_NO = ?) AND (? = 1 AND EMP_NAME IS NULL OR
                         EMP_NAME = ?) AND (? = 1 AND [POSITION] IS NULL OR
                         [POSITION] = ?) AND (? = 1 AND APP_DATE IS NULL OR
                         APP_DATE = ?) AND (? = 1 AND APP_DT_FROM IS NULL OR
                         APP_DT_FROM = ?) AND (? = 1 AND APP_DT_TO IS NULL OR
                         APP_DT_TO = ?) AND (? = 1 AND APP_TIME IS NULL OR
                         APP_TIME = ?) AND (? = 1 AND APP_TIME_FROM IS NULL OR
                         APP_TIME_FROM = ?) AND (? = 1 AND APP_TIME_ON IS NULL OR
                         APP_TIME_ON = ?) AND (? = 1 AND REASONS IS NULL OR
                         REASONS = ?) AND (? = 1 AND REMARKS IS NULL OR
                         REMARKS = ?) AND (? = 1 AND TIME_IN IS NULL OR
                         TIME_IN = ?) AND (? = 1 AND TIME_OUT IS NULL OR
                         TIME_OUT = ?) AND (? = 1 AND CHECKED_IN IS NULL OR
                         CHECKED_IN = ?) AND (? = 1 AND CHECKED_OUT IS NULL OR
                         CHECKED_OUT = ?) AND (? = 1 AND IN_ON IS NULL OR
                         IN_ON = ?) AND (? = 1 AND OUT_ON IS NULL OR
                         OUT_ON = ?) AND (? = 1 AND APP IS NULL OR
                         APP = ?) AND (? = 1 AND APP_MAIL IS NULL OR
                         APP_MAIL = ?) AND (? = 1 AND APP_OWN IS NULL OR
                         APP_OWN = ?)



Is This A Good Question/Topic? 0
  • +

Page 1 of 1