|
Izradio sam sledecu bazu u FireBird-u:
"-----------------------------------------------------
SET SQL DIALECT 3;
CREATE DATABASE 'C:\BAZA.GDB'
USER 'SYSDBA' PASSWORD '1'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1250;
/* Tables definitions */
CREATE TABLE "sPartner" (
"PartnerID" INTEGER NOT NULL,
"Partner" VARCHAR (40) CHARACTER SET WIN1250 NOT NULL COLLATE WIN1250);
/* Primary keys definition */
ALTER TABLE "sPartner" ADD CONSTRAINT "PK_Partner" PRIMARY KEY ("PartnerID");
"------------------------------------------------------------------------------------
Kada sam pokušao da povezem iz BDP2006 sa alatom bdpConnection prijavio mi je grešku:
Ambiguous field name between table RDB$RELATION_CONSTRAINTS and table RDB$RELATIONS
RDB$RELATION_NAME
problemi su sa navodnicima i malim slovima.
QuotedObject = true ali to je naslovu tabele dodalo navodnike ali poljima ne.
|
