[Firebird-devel] (no subject)

[<luk...@tl...>]

Hello
I would like to know how can I INSERT values to table where one of
columns is an Array, and is there a possiblity using data net
provider (1.7) work with it.
to sure  I would put my tables as example.
-------------------first table-----------------------
CREATE TABLE SETTINGS(
SET_ID SMALLINT NOT NULL PRIMARY KEY,
SPEEDS DECIMAL (7,2)[1:20],
TIMERS DECIMAL (7,2)[1:20],
M_DATA DECIMAL (7,2)[1:20]
------------------second table---------------------
CREATE TABLE MAIN(
SET_ID SMALLINT,
LENGHT DECIMAL(5,2),
WIDTH DECIMAL(5,2)
.
.
.
PROGS SMALLINT,
QUEUE BIGINT NOT NULL PRIMARY KEY
FOREIGN KEY (SET_ID) REFERENCES SETTINGS (SET_ID)
ON UPDATE CASCADE ON DELETE CASCADE
);
and I would like to do such thing:
INSERT INT SETTINGS () ?? but I do not know HOW ??
SELECT * FROM MAIN JOIN SETTINGS ON (MAIN.SET_ID =3D SETTINGS.SET_ID)