ayni dll ile ben kullaniyorum bir sikinti yok. bildigim kadariyla netsisin bu hatayi vermesinin sebebi veritabanindan veri esitlemesi yapamadigi için. sql profiler kaydini bi kontrol et derim. tblparam table i sorun yaratabilir. dogrusu
USE [SIRKET]
GO
/****** Object: Table [dbo].[TBLPARAM] Script Date: 01/27/2010 19:46:55 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[TBLPARAM](
[SUBE_KODU] [dbo] .[TDBSMALLINT] NOT NULL,
[LOCAL_DEPO] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PROMOSYON] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIAT_SISTEMI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HES_SEV_SAB] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HS_SEV] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER1] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER2] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER3] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER4] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER5] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER6] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER7] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER8] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER9] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[SEVIYELER10] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[BIRDEN_FAZLA_KASA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIRMA_DOV_TIPI] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[PLASIYER_VAR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DOVIZ_TAKIBI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DOVIZ_CEVRIM] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[LOG_TUTULACAK] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CRAPKOD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ENT_KAYIT_TAR] [dbo] .[TDBDATETIME] NULL,
[MH_HES_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MSEN_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MSEN_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[MCEK_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MCEK_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[BSEN_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSEN_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[BCEK_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BCEK_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[MUH_MUSTD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MUH_SATD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MUST_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[SAT_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[ALIS_HES_DET] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALIS_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[IADEAL_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[SATIS_HES_DET] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[IADESAT_HES_KOD] [dbo] .[TDBMUHKOD] NULL,
[SAT_HES_KOD1] [dbo] .[TDBMUHKOD] NULL,
[SAT_HES_KOD2] [dbo] .[TDBMUHKOD] NULL,
[SAT_HES_KOD3] [dbo] .[TDBMUHKOD] NULL,
[SATIS_FATURA_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALIS_FATURA_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPO_TRANS_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OKOD1_SATMUHKODD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_KOD_ADEDI] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[KODUN_DEGERI_1] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KODUN_DEGERI_2] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KODUN_DEGERI_3] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KODUN_DEGERI_4] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_KODU_1] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_KODU_2] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_KODU_3] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATIS_KODU_4] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SAT_ISK_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALIS_ISK_ENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OZELKOD2DEGISIM] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OZELKOD2DEGERI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALIS_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[ALIS_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[ALIS_HES_KOD_3] [dbo] .[TDBMUHKOD] NULL,
[ALIS_HES_KOD_4] [dbo] .[TDBMUHKOD] NULL,
[ALIS_HES_KOD_5] [dbo] .[TDBMUHKOD] NULL,
[VERISK_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[VERISK_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[VERISK_HES_KOD_3] [dbo] .[TDBMUHKOD] NULL,
[VERISK_HES_KOD_4] [dbo] .[TDBMUHKOD] NULL,
[VERISK_HES_KOD_5] [dbo] .[TDBMUHKOD] NULL,
[ALISM_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[ALISM_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[SATISM_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[SATISM_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[MIK_MUHA_GECSIN] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SAT_ISK_AL_DEGIS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BIRDEN_FAZLA_KDV] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KAC_KDV] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[KDV_ORAN_1] [dbo] .[TDBKDVORAN] NULL DEFAULT (0),
[KDV_ORAN_2] [dbo] .[TDBKDVORAN] NULL DEFAULT (0),
[KDV_ORAN_3] [dbo] .[TDBKDVORAN] NULL DEFAULT (0),
[KDV_ORAN_4] [dbo] .[TDBKDVORAN] NULL DEFAULT (0),
[KDV_ORAN_5] [dbo] .[TDBKDVORAN] NULL DEFAULT (0),
[IND_KDV_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[IND_KDV_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[IND_KDV_HES_KOD_3] [dbo] .[TDBMUHKOD] NULL,
[IND_KDV_HES_KOD_4] [dbo] .[TDBMUHKOD] NULL,
[IND_KDV_HES_KOD_5] [dbo] .[TDBMUHKOD] NULL,
[TAHED_KDV_HES_KOD_1] [dbo] .[TDBMUHKOD] NULL,
[TAHED_KDV_HES_KOD_2] [dbo] .[TDBMUHKOD] NULL,
[TAHED_KDV_HES_KOD_3] [dbo] .[TDBMUHKOD] NULL,
[TAHED_KDV_HES_KOD_4] [dbo] .[TDBMUHKOD] NULL,
[TAHED_KDV_HES_KOD_5] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVIND_1] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVIND_2] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVIND_3] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVIND_4] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVIND_5] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVODE_1] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVODE_2] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVODE_3] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVODE_4] [dbo] .[TDBMUHKOD] NULL,
[IADEKDVODE_5] [dbo] .[TDBMUHKOD] NULL,
[MALBAZINDA_ISKONTO] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HANGI_ISKONTO] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALISK_MBAZ] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATISK_MBAZ] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALISK_HANGI_SATKOD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SATISK_HANGI_SATKOD] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HANGI_MIKTAR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MALBAZKDV] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KF_ENT_BORCKOD] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KF_ENT_ALACKOD] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YUVARLAMA_KODU] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORTAKISLEMTIP] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USER_SOR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAKET_KULLANICI_SAY] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[CONCURRENT_USER_CNT] [dbo] .[TDBBYTE] NULL DEFAULT (0),
[OTOMATIK_ISLEM_TIPI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARIH_KILIT_SIFRE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK1] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK2] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK3] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK4] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK5] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK6] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK7] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK8] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK9] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK10] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK11] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK12] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK13] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK14] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK15] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK16] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK17] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK18] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK19] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK20] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[YEDEK21] [dbo] .[TDBBYTE] NULL,
[YEDEK22] [dbo] .[TDBBYTE] NULL,
[YEDEK23] [dbo] .[TDBBYTE] NULL,
[YEDEK24] [dbo] .[TDBBYTE] NULL,
[YEDEK25] [dbo] .[TDBBYTE] NULL,
[YEDEK26] [dbo] .[TDBSMALLINT] NULL,
[YEDEK27] [dbo] .[TDBSMALLINT] NULL,
[YEDEK28] [dbo] .[TDBSMALLINT] NULL,
[YEDEK29] [dbo] .[TDBSMALLINT] NULL,
[YEDEK30] [dbo] .[TDBSMALLINT] NULL,
[YEDEK31] [dbo] .[TDBINTEGER] NULL,
[YEDEK32] [dbo] .[TDBINTEGER] NULL,
[YEDEK33] [dbo] .[TDBINTEGER] NULL,
[YEDEK34] [dbo] .[TDBINTEGER] NULL,
[YEDEK35] [dbo] .[TDBINTEGER] NULL,
[YEDEK36] [dbo] .[TDBDATETIME] NULL,
[YEDEK37] [dbo] .[TDBDATETIME] NULL,
[EPOSTAVAR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
) ON [PRIMARY]
SET ANSI_PADDING ON
ALTER TABLE [dbo].[TBLPARAM] ADD [SMTPSNAME] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [SMTPUNAME] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[TBLPARAM] ADD [SMTPUPWD] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ILERIGUVENLIKSISTEMI] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [WORKPLACEVARMI] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [FORMBAZIGUVENLIK] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [HIZLIREHBERKULLAN] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [OKOD1_ALMUHKODD] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODU_1] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODU_2] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODU_3] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODU_4] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODUN_DEGERI_1] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODUN_DEGERI_2] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODUN_DEGERI_3] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ALIS_KODUN_DEGERI_4] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [ISLTIPBAZHESKODDEGISIM] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [SCRIPTSYSTEM] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ('H')
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK60] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK61] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK62] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK63] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK64] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK65] [dbo].[TDBBYTE] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK66] [dbo].[TDBBYTE] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK67] [dbo].[TDBBYTE] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK68] [dbo].[TDBINTEGER] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [YEDEK69] [dbo].[TDBINTEGER] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [KDV_ORAN_6] [dbo].[TDBKDVORAN] NULL DEFAULT ((0))
ALTER TABLE [dbo].[TBLPARAM] ADD [KDV_ORAN_7] [dbo].[TDBKDVORAN] NULL DEFAULT ((0))
ALTER TABLE [dbo].[TBLPARAM] ADD [IND_KDV_HES_KOD_6] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [IND_KDV_HES_KOD_7] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [TAHED_KDV_HES_KOD_6] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [TAHED_KDV_HES_KOD_7] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [IADEKDVIND_6] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [IADEKDVIND_7] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [IADEKDVODE_6] [dbo].[TDBMUHKOD] NULL
ALTER TABLE [dbo].[TBLPARAM] ADD [IADEKDVODE_7] [dbo].[TDBMUHKOD] NULL
/****** Object: Index [TBLPARAM_PKEY] Script Date: 01/27/2010 19:46:55 ******/
ALTER TABLE [dbo].[TBLPARAM] ADD CONSTRAINT [TBLPARAM_PKEY] PRIMARY KEY CLUSTERED
(
[SUBE_KODU] ASC
) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [ATER2008]
GO
ALTER TABLE [dbo].[TBLPARAM] WITH CHECK ADD CONSTRAINT [TBLPARAM_FKEY] FOREIGN KEY([SUBE_KODU])
REFERENCES [dbo].[TBLSUBELER] ([SUBE_KODU])
ON DELETE CASCADE
------------- MUHAMMET YILMAZ
0505 664 26 97
NETSİS PROJE UZMANI
|