This is how I create my temporary tables :
create global temporary table TEMP_112233
(
id : INTEGER,
name : CHAR(20)
)
on commit preserve rows
I also do some create views :
CREATE OR ALTER VIEW CAUT_PRODUSE_VIEW_4982590
(
COD_PRODUS,
ID_PRODUS
)
AS
select
produse.cod_produs,
produse.id_produs
from produse
inner join sortiment on (sortiment.id_sortiment + 0 = produse.id_sortiment)
where
denumire_sortiment <> 'N '
I do not know about any domain definitions, this should be an internal
FireBird thing.
if I have RDB$1 defined this way :
CREATE DOMAIN RDB$1 AS INTEGER
whenever I create another table with an Integer field, this domain should be
used, am I wrong ?
is there a command
create table TEMP_112233
(
id : INTEGER use domain RDB$1
)
?
BTW, I am located in Romania.
Thank you,
Tiberiu
