Subject Re: [firebird-support] Digest Number 9396
Author
Post date 2016-11-21T07:37:50Z
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