SQL cetak spasial SU transaksi dibatalkan

Waktu mencetak Surat Spasial keluar peringatan TRANSAKSI DIBATALKAN

sOLUSI :
sle

1. Lihat ditabel GRRE status END grreflgorg tidak boleh "G"

select * from grre where expecod=142 and expeyea=2002 and grreflgorg="G" order by grrenum;

2. Update

update grre set grreflgorg="N" where opercod="END" and expecod=142 and expeyea=2002;

3. lihat kode kode gis di parc

select * from grre where expecod=142 and expeyea=2002;


catat kode gis nya

4. update

update grre set grregiscod=63163 where expecod=142 and expeyea=2002 and grrenum=8;
update grre set grregiscod=63163 where expecod=142 and expeyea=2002 and grrenum=8;


{select parc_temp.* from gspa_temp, parc_temp where gspa_temp.expecod=142 and gspa_temp.expeyea=2002 and gspa_temp.parcgiscod=parc_temp.parcgiscod;}

update grre set grregiscod=63163 where expecod=142 and expeyea=2002 and grrenum=8;

update grre set grregiscod=21496 where expecod=142 and expeyea=2002 and grrenum=8;


{
select * from gspa_temp, grre where grre.expecod=142 and grre.expeyea=2002 and gspa_temp.gssugiscod=grre.grregiscod; }
{select * from gspa_temp where expecod=142 and expeyea=2002;}