Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql server insert problem
Message
From
12/09/2006 10:10:16
 
 
To
12/09/2006 09:58:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01152996
Message ID:
01153018
Views:
27
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 :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform