Sql Ganti tgl DI

Untuk berkas prosedur kombinasi : Misal Jual beli + Hak Tanggungan

{Update tgl Hak Tanggungan}
update d312c set d312cdat="18/12/2002" where d312cseq=436 and d312cyea=2003;
select * from d312c where d312cseq=436 and d312cyea=2003;

{update tgl DI 208}
update d208 set d208dat="18/12/2002" where d208seq=436 and d208yea=2003;
select * from d208 where d208seq=436 and d208yea=2003;


{update tgl DI 307}
update d307 set d307dat="18/12/2002" where d307seq=436 and d307yea=2003;
select * from d307 where d307seq=436 and d307yea=2003;


atau berdasarkan id berkas :

Untuk berkas prosedur tunggal, misal : Hak Tanggungan

Catat dulu id berkas dari no berkas (expecod dan expeyea)

1.Select * from expe where expecod=noberkas and expeyea=thnberkas;

Kemudian ubah tanggal dari Daftar Isian (DI) berdasarkan Id Berkas yang dicatat :

misal :
2.
update d312c set d312cdat="18/12/2002" where expeid=436;
select * from d312c where expeid=436;

update d208 set d208dat="18/12/2002" where expeid=436;
select * from d208 where expeid=436;

update d307 set d307dat="18/12/2002" where expeid=436;
select * from d307 where expeid=436;