2016 ?irketinde Sipari? Üst bilgilerden Kalem bilgilerine geçi?te a?a?ydaki hata ile kar?yla?maktayym. Nerden kaynaklandy?yny bulamadym ...
Null alany stringe çeviremiyormu? ancak hangi null alany stringe çevirmeye çaly?ty?y belirsiz ??
Could not convert variant of type (Null) into type (String)
sql sorgu ve dondurdu?u sonuç a?a?ydaki gibidir.
SELECT *
FROM SIPATRA WITH(NOLOCK)
WHERE (STHAR_FTIRSIP = '6'
AND STHAR_GCKOD = 'C'
AND STHAR_BGTIP IN ( 'I','I')
AND FISNO = '000000000000009'
AND STHAR_ACIKLAMA = '120 07 001'
AND SUBE_KODU = 0)
STOK_KODU FISNO STHAR_GCMIK STHAR_GCMIK2 CEVRIM STHAR_GCKOD STHAR_TARIH STHAR_NF STHAR_BF STHAR_IAF STHAR_KDV DEPO_KODU STHAR_ACIKLAMA STHAR_SATISK STHAR_MALFISK STHAR_FTIRSIP STHAR_SATISK2 LISTE_FIAT STHAR_HTUR STHAR_DOVTIP PROMASYON_KODU STHAR_DOVFIAT STHAR_ODEGUN STRA_SATISK3 STRA_SATISK4 STRA_SATISK5 STRA_SATISK6 STHAR_BGTIP STHAR_KOD1 STHAR_KOD2 STHAR_SIPNUM STHAR_CARIKOD STHAR_SIP_TURU PLASIYER_KODU EKALAN_NEDEN EKALAN EKALAN1 REDMIK REDNEDEN SIRA STRA_SIPKONT AMBAR_KABULNO FIRMA_DOVTIP FIRMA_DOVTUT FIRMA_DOVMAL UPDATE_KODU IRSALIYE_NO IRSALIYE_TARIH KOSULKODU ECZA_FAT_TIP STHAR_TESTAR OLCUBR INCKEYNO VADE_TARIHI LISTE_NO BAGLANTI_NO SUBE_KODU MUH_KODU S_YEDEK1 S_YEDEK2 F_YEDEK3 F_YEDEK4 F_YEDEK5 C_YEDEK6 B_YEDEK7 I_YEDEK8 L_YEDEK9 D_YEDEK10 PROJE_KODU FIYATTARIHI KOSULTARIHI SATISK1TIP SATISK2TIP SATISK3TIP SATISK4TIP SATISK5TIP SATISK6TIP EXPORTTYPE EXPORTMIK ONAYTIPI ONAYNUM KKMALF STRA_IRSKONT YAPKOD MAMYAPKOD OTVFIYAT
10061 000000000000009 10.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 96.66600000 96.66600000 0.00000000 18.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 30.000000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 1 1 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 77 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
0905 000000000000009 30.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 7.08884000 7.08884000 0.00000000 8.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 2.200000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 2 2 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 78 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 3534015 NULL 0.00000000
0403 000000000000009 48.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 12.88880000 12.88880000 0.00000000 18.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 4.000000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 3 3 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 79 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
0404 000000000000009 1.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 241.66500000 241.66500000 0.00000000 18.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 75.000000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 4 4 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 80 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
0541 000000000000009 20.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 64.44400000 64.44400000 0.00000000 8.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 20.000000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 5 5 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 81 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
0503 000000000000009 10.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 83.77720000 83.77720000 0.00000000 18.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 26.000000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 6 6 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 82 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
0760 000000000000009 10.00000000 0.00000000 0.00000000000000 C 2016-01-05 00:00:00.000 2.57776000 2.57776000 0.00000000 18.00 1 120 07 001 0.00020000 0.00000 6 20.00000000 0 H 2 0 0.800000000000000 0 0.00000000 0.00000000 0.00000000 0.00000000 I 0 NULL NULL 120 07 001 NULL NULL NULL NULL NULL 0.00000 0 7 7 NULL 0 0.00000000 0.00000000 NULL NULL 2016-01-05 00:00:00.000 NULL 0 2016-01-05 00:00:00.000 0 83 2016-01-05 00:00:00.000 NULL 0 0 NULL NULL NULL 0.00000000 0.00000000 0.00000000 NULL 0 0 0 2016-01-05 00:00:00.000 1 2016-01-05 00:00:00.000 NULL 0 0 0 0 0 0 0 0.00000000 A 0 0.00000000 0 NULL NULL 0.00000000
|