如何更新2个异议数据? [英] How can i update 2 opposition data ?
问题描述
我的问题是这样的,我有货币表需要更新彼此的费率基础
--------------------- ----------
|货币| SGD | MYR | USD |
-------------------------------
| SGD | ### | 3.00 | 1.30 |
-------------------------------
| MYR | 3.00 | ### | 4.20 |
-------------------------------
|美元| 1.30 | 4.20 | ### |
如果我更新第1行货币SGD TO MYR是3.00所以同时程序会自动更新第2行价值MYR至新币3.00 >
有什么想法可以解决我的问题吗?
我尝试了什么:
i已经尝试使用数据网格视图但是不能满足我的情况
my problem is like this i have currency table need to update the rate base on each another
-------------------------------
|currency | SGD | MYR | USD |
-------------------------------
|SGD | ### | 3.00 | 1.30|
-------------------------------
|MYR | 3.00 | ### | 4.20|
-------------------------------
|USD | 1.30 | 4.20 | ### |
if i update row 1 currency SGD TO MYR is 3.00 so at the same time program will auto update row 2 value MYR To SGD 3.00
any idea to solve my problem ?
What I have tried:
i have try use data grid view but cannot meet my case
推荐答案
表在数据库表中?只需进行两次更新,将MYR列更新为3,货币为SGD,并将SGD列更新为3,货币为MYR。
Table as in a database table? Just do two updates, update the MYR column to 3 where the currency is SGD, and update the SGD column to 3 where the currency is MYR.
这篇关于如何更新2个异议数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!