uf zamalo da uspe
evo sta kaze:
/*
ACTION is CREATE Table Osoba
*/
CREATE TABLE Osoba (
Polaznik\Nastavnik VARCHAR(20) NOT NULL,
Sif0 INTEGER NOT NULL,
Ime VARCHAR(20),
Prezime VARCHAR(20),
Telefon INTEGER,
Adresa VARCHAR(20),
Email VARCHAR(20),
Datum_rodjenja DATETIME
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
Execution Failed!
CREATE UNIQUE INDEX XPKOsoba ON Osoba
(
Polaznik\Nastavnik,
Sif0
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE INDEX statement.
Execution Failed!
/*
ACTION is CREATE Table jezik
*/
CREATE TABLE jezik (
SifraJ INTEGER NOT NULL,
Naziv VARCHAR(20),
Varijanta VARCHAR(20),
Plata_po_casu INTEGER
)
Execution Successful
CREATE UNIQUE INDEX XPKjezik ON jezik
(
SifraJ
)
Execution Successful
/*
ACTION is CREATE Table Kurs
*/
CREATE TABLE Kurs (
SifraK INTEGER NOT NULL,
SifraJ INTEGER NOT NULL,
Cena INTEGER NOT NULL,
Nivo VARCHAR(20),
Stepen INTEGER,
Broj_casova INTEGER
)
Execution Successful
CREATE UNIQUE INDEX XPKKurs ON Kurs
(
SifraK,
SifraJ
)
Execution Successful
/*
ACTION is CREATE Table Grupa
*/
CREATE TABLE Grupa (
SifraG INTEGER NOT NULL,
SifraK INTEGER NOT NULL,
SifraJ INTEGER NOT NULL,
Polaznik\Nastavnik VARCHAR(20),
Sif0 INTEGER,
Datum_pocetka DATETIME,
Datum_kraja DATETIME,
Odrzano_casova DATETIME
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
Execution Failed!
CREATE UNIQUE INDEX XPKGrupa ON Grupa
(
SifraG,
SifraK,
SifraJ
)
[Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.
Execution Failed!
/*
ACTION is CREATE Table Pohadja
*/
CREATE TABLE Pohadja (
Polaznik\Nastavnik VARCHAR(20) NOT NULL,
Sif0 INTEGER NOT NULL,
SifraJ INTEGER NOT NULL,
SifraK INTEGER NOT NULL,
SifraG INTEGER NOT NULL
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
Execution Failed!
CREATE UNIQUE INDEX XPKPohadja ON Pohadja
(
Polaznik\Nastavnik,
Sif0,
SifraJ,
SifraK,
SifraG
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE INDEX statement.
Execution Failed!
/*
ACTION is CREATE Table UplataIsplataProfaktura
*/
CREATE TABLE UplataIsplataProfaktura (
UplataIsplataProfaktura CHAR(18) NOT NULL,
SifraUIP INTEGER NOT NULL,
SifraG INTEGER,
SifraK INTEGER,
SifraJ INTEGER,
Sif0 INTEGER,
Polaznik\Nastavnik CHAR(18),
Iznos INTEGER,
Datum DATETIME
)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
Execution Failed!
CREATE UNIQUE INDEX XPKUplataIsplataProfaktura ON UplataIsplataProfaktura
(
UplataIsplataProfaktura,
SifraUIP
)
[Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.
Execution Failed!
Schema Generation Complete
4 queries succeeded. 8 queries failed.
------------------------------------------------------------------------------
i kao sto se vidi preneo mi je u access samo tabelu jezik i kursa
sta dalje ...........