Mengganti jumlah Pemecahan

Mengganti jumlah Pemecahan


1. Lihat di sql pada tabel grre,
kemudian ubah grrenumsu_ (Nomor GSSU Genarate) dan grrenumpar (Nomor Persil Generate)
Gunakan perintah dibawah ini :

update grre set grrenumsu_="14"
where expecod=93 and expeyea=2003 and indetyp="G";
select * from grre where expecod=93 and expeyea=2003 and indetyp="G";

update grre set grrenumpar="14"
where expecod=93 and expeyea=2003 and indetyp="G";
select * from grre where expecod=93 and expeyea=2003 and indetyp="G";

2. Lanjutkan berkas di penggambaran seperti biasa

3. Kalau seandainya sudah dibuat gambar dan keluar NO GIS Sementara,
hapus No GIS Sementara tersebut dengan SQL

delete from grre where expecod=93 and expeyea=2003
and grregiscod=1401388;

select * from grre where expecod=93 and expeyea=2003
and grregiscod=1401388;

delete from grre where expecod=93 and expeyea=2003
and grregiscod=94499;

select * from grre where expecod=93 and expeyea=2003
and grregiscod=94499;