Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: Asa Creative on May 05, 2016, 11:24:50 PM

Title: HAPUS DATA RS SELALU GAGAL
Post by: Asa Creative on May 05, 2016, 11:24:50 PM

Bos.. help dong..
Kenapa Hapus RS dengan cara ini udah ga bisa lagi ya,

DECLARE @kodereseller varchar(20)

SET @kodereseller = 'KODE YG MAU DIHAPUS'

DELETE FROM TRANSAKSI WHERE kode_reseller=@kodereseller
DELETE FROM MUTASI WHERE kode_reseller=@kodereseller
DELETE FROM RESELLER WHERE kode=@kodereseller

hasilnya :

Msg 208, Level 16, State 1, Line 5
Invalid object name 'TRANSAKSI'.

padahal otomax versi dahulu masih lancar lancar aja...
ada yang punya solusi nggak ?
terima kasih..

Title: Re: HAPUS DATA RS SELALU GAGAL
Post by: maxpulsa on May 06, 2016, 12:19:40 AM

USE OTOMAX
DECLARE @kodereseller varchar(20)

SET @kodereseller ='KODE YG MAU DIHAPUS

DELETE FROM TRANSAKSI WHERE kode_reseller=@kodereseller
DELETE FROM MUTASI WHERE kode_reseller=@kodereseller
DELETE FROM RESELLER WHERE kode=@kodereseller


COBA ITU BOS.....

Title: Re: HAPUS DATA RS SELALU GAGAL
Post by: mabruk on May 06, 2016, 08:20:54 AM

Saya tes ini masih bisa

DECLARE @kodereseller varchar(20)

SET @kodereseller = 'MP1101'

DELETE FROM TRANSAKSI WHERE kode_reseller=@kodereseller
DELETE FROM MUTASI WHERE kode_reseller=@kodereseller
DELETE FROM RESELLER WHERE kode=@kodereseller

hasil
(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

Title: Re: HAPUS DATA RS SELALU GAGAL
Post by: Asa Creative on May 15, 2016, 12:48:31 PM

Disaya masih gagal bos..

Msg 208, Level 16, State 1, Line 5
Invalid object name 'TRANSAKSI'.



jamunya apa ya..