Re[2]: sql problems wth JTDS and SQL Server

[Bartłomiej Knabel]

Hi Jakob,


JB> i mean did you enter the select in a gui-application that calls 
JB> ms-sqlserver ?

it was SQL Querry analyzer

JB> i would like to know which column alias caused the 
JB> problem because the query looks ok to me. (except 'zp_czznd', is this an
JB> indirection table ?)

zp_czznd is an indirection table.

this is full SQL script, whitch generates sql database :

drop table ZestawZlozony;
drop table CzescZlozona;
drop table CzescAtomowa;
drop table ElementProjektowy;
drop table Dokument;
drop table Modul;
drop table Polaczenie;
drop table Manual;
drop table ZestawPodstawowy;
drop table zp_czznd;
drop table zp_czzd;
drop table Parametry;

create table Parametry (
   par_id integer not null identity,
   par_IloscCzANaCzZ integer,
   par_IloscPolaczenNaAtom integer,
   par_DlugoscDokumentu integer,   
   par_DlugoscManuala integer,
   par_IloscCzZlozNaModul integer,
   par_IloscZestWZestZl integer,  
   par_IloscPoziomow integer,
   par_IloscCzZWZestPdst integer,
   par_IloscModulow integer,        
   primary key (par_id)
);

create table Dokument (
   dok_id integer not null identity,
   dok_czzId integer,
   dok_tekst text null,
   dok_tytul varchar(40),
   primary key (dok_id)
);

create table Manual (
   man_id integer not null identity,
   man_tytul varchar(40),
   man_tekst text null,
   man_dlTekstu integer not null,
   man_modId integer,
   primary key (man_id)
);
create table Polaczenie (
   pol_id integer not null identity,
   pol_dlugosc integer not null,
   pol_typ varchar(10),
   polZAtomowej integer,
   polDoAtomowej integer,
   primary key (pol_id)
);
create table ElementProjektowy (
   ep_id integer not null identity,
   ep_typ varchar(10),
   ep_data datetime not null,
   primary key (ep_id)
);

create table CzescAtomowa (
   cza_id integer not null ,
   cza_x integer not null,
   cza_y integer not null,
   cza_dokId integer not null,
   cza_czId integer,
   primary key (cza_id)
);
create table CzescZlozona (
   czz_id integer not null ,
   czz_glAtid integer not null,
   czz_dokId integer not null,
   primary key (czz_id)
);
create table Modul (
   mod_id integer not null ,
   mod_manId integer,
   mod_zzId integer,
   primary key (mod_id)
);

create table ZestawPodstawowy (
   zp_id integer not null,
   zp_zz_id integer,
   primary key (zp_id)
);

create table ZestawZlozony (
   zz_id integer not null,
   zz_modId integer,
   zz_zz_id integer,
   primary key (zz_id)
);

create table zp_czzd (
   czz_zp_zpIdd integer not null,
   czz_zp_czpIdd integer not null
);

create table zp_czznd (
   czz_zp_zpIdnd integer not null,
   czz_zp_czpIdnd integer not null
);

create index IndexDokumentTytul on Dokument (dok_tytul);
create index IndexCzaDokId on CzescAtomowa (cza_dokId);


now You can generate my database and chceck it.

Maybye I dont have some SP? I use just SP3 for SQL Server 200, but I
didin't install SP1 and SP2...

-- 
 Bartłomiej Knabel


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]