French Robert,

<<2. How to you create a counter field in Firebird?>>

If you mean by "Counter" a generator:

CREATE GENERATOR ELTON_JOHN_WAYNE_NEWTON_ID_GEN;
SET GENERATOR ELTON_JOHN_WAYNE_NEWTON_ID_GEN TO 93000000;

Clay Shannon,
Dimension 4 Software