Author Topic: !9795 Failed to check duplicate transactions: Mohon Jamunya V.3.8.2  (Read 321 times)


  • User OtomaX
  • Jr. Member
  • **
  • Posts: 347
!9795 Failed to check duplicate transactions:    : OtomaX: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. SET NOCOUNT ON
SELECT TOP 1 T.kode,T.tgl_entri,T.status,,T.kode_produk,T.harga,T.keterangan FROM transaksi T WITH(NOLOCK) INNER JOIN produk P WITH(NOLOCK) ON P.kode=T.kode_produk
WHERE T.kode>=0 AND T.tgl_entri>='0001-01-01 00:00:00' AND T.kode_reseller='AG448' AND T.tujuan='082257767246' AND T.counter=1 AND T.qty=1 AND P.nominal=20 AND (T.status<40 OR T.tgl_status>='2018-09-24 11:42:36')

Mohon yang punya jamunya.... Help..
Sering error seperti itu