HAPUS DATA RS SELALU GAGAL

[Asa Creative]

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..

[maxpulsa]

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.....

[mabruk]

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)

[Asa Creative]

Disaya masih gagal bos..

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



jamunya apa ya..