Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: arpserver on January 25, 2019, 09:32:33 PM

Title: Tarik KOMISI
Post by: arpserver on January 25, 2019, 09:32:33 PM

Mohon Bantuannya RS tarik komisi status Pending, komisi hilang dan tidak masuk ke Saldo :
Terjadi kepada Beberapa RS saja, Help me :

di verificator muncul :
Error while proccessing inbox 110002922: Tukar.all.252525
SET NOCOUNT ON
UPDATE komisi WITH(ROWLOCK) SET tukar=3 WHERE kode_reseller='MS0009' and tukar=0
SELECT sum(jumlah) FROM komisi WITH(NOLOCK) WHERE kode_reseller='MS0009' and tukar=3
UPDATE komisi WITH(ROWLOCK) SET tukar=1 WHERE kode_reseller='MS0009' and tukar=3

Title: Re: Tarik KOMISI
Post by: madkios on January 26, 2019, 10:43:35 AM

Quote from: arpserver on January 25, 2019, 09:32:33 PM

Mohon Bantuannya RS tarik komisi status Pending, komisi hilang dan tidak masuk ke Saldo :
Terjadi kepada Beberapa RS saja, Help me :

di verificator muncul :
Error while proccessing inbox 110002922: Tukar.all.252525
SET NOCOUNT ON
UPDATE komisi WITH(ROWLOCK) SET tukar=3 WHERE kode_reseller='MS0009' and tukar=0
SELECT sum(jumlah) FROM komisi WITH(NOLOCK) WHERE kode_reseller='MS0009' and tukar=3
UPDATE komisi WITH(ROWLOCK) SET tukar=1 WHERE kode_reseller='MS0009' and tukar=3

OTOMAXNYA versi berapa bos ?

Title: Re: Tarik KOMISI
Post by: arpserver on January 27, 2019, 12:16:17 AM

381