Arnaud, Thanks I did this: on error call - just make the error go away for every table for every field is this my "primary key' field? sql command as text to set primary key on the field execute immediate(above sql command) (trying to set a primary key, as primary key generates an error which is suppressed by the above on error call)
it works to do what I needed, it is fast, and it is done :) Chip On Sun, 5 Aug 2018 12:28:39 +0200, Arnaud de Montard via 4D_Tech wrote: > >> Le 3 août 2018 à 18:12, Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> a écrit : >> >> Thanks, >> I do not really use the online docs.... >> but it is nice to know > > SQL script example. > > ++++++++++ > /* tables and primary keys */ > > CREATE TABLE Agence > ( > PK INT32 NOT NULL UNIQUE AUTO_INCREMENT, > raisonSociale VARCHAR(80), > complementAdresse VARCHAR(80), > email VARCHAR(80), > comments TEXT, > PRIMARY KEY (PK) > ); > > CREATE TABLE ContactAgence > ( > PK INT32 NOT NULL UNIQUE AUTO_INCREMENT, > nom VARCHAR(80), > prenom VARCHAR(80), > fonction VARCHAR(80), > email VARCHAR(80), > FK_agence INT32, > comments TEXT, > PRIMARY KEY (PK) > ); > > /* indexes */ > > CREATE INDEX idx1 ON Agence (PK); > > CREATE INDEX idx2 ON ContactAgence (PK); > > /* relation */ > > ALTER TABLE ContactAgence ADD CONSTRAINT rel1 FOREIGN KEY (FK_agence) > REFERENCES Agence (PK); > ++++++++++ > > Note: I never create such relations… > > -- > Arnaud de Montard > > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************