更新MS数据库中的某些项目 [英] Update certain Item in MS database
问题描述
我正在创建一个图书馆系统,该系统的一部分将计算任何滞纳金.现在需要将系统为会员计算的滞纳金添加到会员记录中,我该如何实现.
例如,发生了会员ID 1的滞纳金£2.40,现在必须将此费用添加到他的记录中,该记录包括其会员ID,姓名,地址,电话号码和滞纳金..
必须在记录的滞纳金部分中更新这2.40英镑
如何实现这一目标,我似乎无法解决.
有人可以指导我实现这一目标吗?
感谢
Im creating a library system and part of the system calculates any late fees. Now the late fee that the system calculates for the member needs to be added to the members record, how can i achieve this.
For e.g Member ID 1 has occured a late fee of £2.40 now this fee must be added to his record which consists of their member id, name, address, telphone number and late fees..
The £2.40 must be update in the late fees part of the record
how can this be achieved i cant seem to work it out.
can someone kindly direct me to achieving this
thanks
推荐答案
不确定,您到底在寻找什么.如果是伪代码,则在下面列出:
Not sure, what exactly you are looking for. If it is psudeo code, then it is listed below:
if (lateFee applicable for MemberID) then
UPDATE libraymaster
SET latefees=2.40
WHERE memberid = MemberID
end if
这篇关于更新MS数据库中的某些项目的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!