SQL HATASI

Konu başlatıcı

BENİN SORUNUM NEBİM WINNER MUHASEBE ENTEGRASYONDA İŞLEM YAPTIGIMDA AŞAIDAKİ HATALARI VERİDYOR NEDEN ACABA;

Hata Alan Istemcide Tarih : 29/1/2010
Hata Alan Istemcide Saat : 12:36:35
Mesaj                     :
Hata No                   : -2147217900
Module                    : nebADO :
Procedure                 : executeSQL
================================================================================
Açıklama                  :
207 - [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'nHesapID'.
SQL : --firma icin hesap
update #tempFaturaEntegrasyon set nHesapID = tbFirma.nHesapId
   From tbFirma
   where #tempFaturaEntegrasyon.nFirmaID = tbFirma.nFirmaID
         and bPesinMi = 0
         and sSatirTipi = '1 - NetTutar'

Hata Alan Istemcide Tarih : 29/1/2010
Hata Alan Istemcide Saat : 12:36:47
Mesaj                     :
Hata No                   : -2147217900
Module                    : nebADO :
Procedure                 : makeRSReadOnly
================================================================================
Açıklama                  :
207 - [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'nHesapID'.
207 - [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'nHesapID'.
SQL :
select dteFisTarihi,
       sFisTipi = case convert(char(1),bPesinMi) when '1' then (case when nGirisCikis in (2,3) then '1' else '2' end) else '3' end,
       0 as lFisNo,
       tbHesapPlani.sKodu as sHesapKodu,
       tbHesapPlani.sAciklama as sHesapAdi,
       substring((case when nGirisCikis in (2,4) then 'İade ' else '' end)+'Fatura:' + rtrim(convert(char,#tempFaturaEntegrasyon.lFisNo)) + '\' + sFirmaAdi,1,60) as sSatirAciklamasi,
       lBorcTutar as lBorcTutar, lAlacakTutar as lAlacakTutar,
       (lGirenMiktar * convert(char(1),tbHesapPlani.bMiktarVar)) as lGirenMiktar,
       (lCikanMiktar * convert(char(1),tbHesapPlani.bMiktarVar)) as lCikanMiktar,
       sHareketTipi,
       sMasrafMerkezi,
       '' as sKasaKodu,
       0 as nStokFisiID,
       #tempFaturaEntegrasyon.lFisNo as lFaturaNo,
       sSatirTipi,
       nGirisCikis,
       #tempFaturaEntegrasyon.nHesapID as nHesapID,
       'Alış Faturaları' + ' - ' + (case when nGirisCikis in (2,4) then 'Iade' else 'Normal' end) as sFisAciklama1,
       '' as sFisAciklama2,
       '' as sFisAciklama3,
       '' as sFisAciklama4,
       '' as sFisAciklama5
       ,sDovizCinsi, lDovizKuru, lDovizMiktari = case when lBorcTutar <> 0 then (case when lDovizKuru<>0 then lBorcTutar/lDovizKuru else 0 end ) else (case when lDovizKuru<>0 then lAlacakTutar/lDovizKuru else 0 end ) end
from tbHesapPlani, #tempFaturaEntegrasyon
where tbHesapPlani.nHesapID = #tempFaturaEntegrasyon.nHesapID
order by dteFisTarihi, nGirisCikis, sHareketTipi, convert(char(1),bPesinMi), lFaturaNo, sSatirTipi

Hata Alan Istemcide Tarih : 29/1/2010
Hata Alan Istemcide Saat : 12:36:56
Mesaj                     :
Hata No                   : 9
Module                    : frmEntFatura
Procedure                 : Form_Goster
================================================================================
Açıklama                  :
Subscript out of range