捷信达会员卡删除历史往来明细

select * from gsprofile where RFCardNo ='0451870484'

update gsprofile SET Balance ='0',defaultcharge ='0',BaseAmtBalance ='0',IncAmount ='0'  where RFCardNo ='0451870484'

select * from gsmbrcard where CardNo ='000016'

select * from gsProfileCA where MbrCardNo ='000016' and PaymentDesc = '26' -- PaymentDesc ='18'

delete from gsProfileCA where MbrCardNo ='000016' and PaymentDesc = '18'

landv / landv.github.io

捷信达会员卡删除历史往来明细 #56