Project

General

Profile

Bug #667

Cập nhật giá trị NULL của PL_TRADETAIL về 0 (Fix lỗi không cộng được với giá trị NULL)

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
11/24/2020
Due date:
% Done:

0%

Estimated time:

Description

UPDATE PL_TRADEDETAIL SET AMT_EXE =0 WHERE AMT_EXE IS NULL
UPDATE PL_TRADEDETAIL SET AMT_ETM=0 WHERE AMT_ETM IS NULL
UPDATE PL_TRADEDETAIL SET AMT_APP=0 WHERE AMT_APP IS NULL
UPDATE PL_TRADEDETAIL SET AMT_TF=0 WHERE AMT_TF IS NULL
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF=0 WHERE AMT_RECEIVE_TF IS NULL

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF