>here is my sql text
>UPDATE TB_FFCONSOL SET
>TR_ACTIVITY = 'EA ',
>TR_CONSOLNO = 21943,
>TR_DEPT = 'EA',
>TR_AGENT_CODE = 'MYL0001 ',
>TR_SHIPPER_CODE = 'GOUDREAU ',
>TR_ISSUED_CODE = 'GOUDREAU ',
>TR_MAWB_MBL = '08678334362 ',
>TR_DEPART_PORT = 'YUL',
>TR_TRANSIT1_PORT = 'LAX',
>TR_TRANSIT2_PORT = 'BNE',
>TR_ARRIVAL_PORT = 'BNE',
>TR_DEPART_CARR = 'NZ ',
>TR_TRANSIT1_CARR = 'NZ ',
>TR_TRANSIT2_CARR = 'NZ ',
>TR_FLIGHT = 'AC797',
>TR_TRANSIT1_FLGHT = 'MZ05 ',
>TR_TRANSIT2_FLGHT = 'MZ135',
>TR_ETD = ?IIF(EMPTY(CUR_FFCONSOL.ETD),NULL,DTOS(CUR_FFCONSOL.ETD)),
>TR_TRANSIT1_ETD = ?IIF(EMPTY(CUR_FFCONSOL.TRANSIT1_ETD),NULL,DTOS(CUR_FFCONSOL.TRANSIT1_ETD)),
>TR_TRANSIT2_ETD = ?IIF(EMPTY(CUR_FFCONSOL.TRANSIT2_ETD),NULL,DTOS(CUR_FFCONSOL.TRANSIT2_ETD)),
>TR_ETA =?IIF(EMPTY(CUR_FFCONSOL.ETA),NULL,DTOS(CUR_FFCONSOL.ETA)),
>TR_ETD_TIME = '10:00',
>TR_TRANSIT1_TIME = '10:00',
>TR_TRANSIT2_TIME = '10:00',
>TR_ETA_TIME = '18:00'
>WHERE TB_FFCONSOL.TR_IDWF = 80003
>
>the TR_ETD_TIME,TR_TRANSIT1_TIME,TR_TRANSIT2_TIME,TR_ETA_TIME does not update and i want to know why :)

Robert,
Forgive my ignorance on previous post but does this really work w/o an error and your only problem is those fields are not updating (while others do)???
Cetin