[firebase-br] Erro em Script

[Ederson Selvati]

tem uma virgula no ultimo campo da criacao da tabela
>    HISTORICO VARCHAR(250) CHARACTER SET WIN1252, //tire esta virgula

e a definicao do campo altura tb está errada ao invés de numeric(1,2) 
coloque numeric(9,2) ou (15,2)..

segue script corrigido


 SET SQL DIALECT 3;

 SET NAMES WIN1252;

 CREATE DATABASE 'c:\Dados.fdb'
 USER 'SYSDBA' PASSWORD 'masterkey'
 PAGE_SIZE 4096
 DEFAULT CHARACTER SET WIN1252;


 /**** Tabelas ****/
 CREATE TABLE REGISTRO (
    RG       VARCHAR(10 ) CHARACTER SET WIN1252 NOT NULL,
    NOME     VARCHAR(150) CHARACTER SET WIN1252 NOT NULL,
    CPF      VARCHAR(15) CHARACTER SET WIN1252 NOT NULL,
    CNH_CAT  VARCHAR(15) CHARACTER SET WIN1252,
    PRONTUARIO_CRIME  VARCHAR(15) CHARACTER SET WIN1252,
    PAI      VARCHAR(150) CHARACTER SET WIN1252,
    MAE      VARCHAR(150) CHARACTER SET WIN1252,
    DT_NASC  DATE,
    SEXO     VARCHAR(10) CHARACTER SET WIN1252,
    NATURALIDADE  VARCHAR(100) CHARACTER SET WIN1252,
    ESTADO_CIVIL  VARCHAR(15) CHARACTER SET WIN1252,
    PROFISSAO  VARCHAR(50) CHARACTER SET WIN1252,
    ENDERECO  VARCHAR(150) CHARACTER SET WIN1252,
    COR       VARCHAR(50) CHARACTER SET WIN1252,
    ALTURA    NUMERIC(15,2),
    OLHOS     VARCHAR(50) CHARACTER SET WIN1252,
    CABELOS   VARCHAR(50) CHARACTER SET WIN1252,
    SINAIS    VARCHAR(200) CHARACTER SET WIN1252,
    MODALIDADE_ACAO  VARCHAR(100) CHARACTER SET WIN1252,
    RUA       VARCHAR(100) CHARACTER SET WIN1252,
    BAIRRO    VARCHAR(100) CHARACTER SET WIN1252,
    CIDADE    VARCHAR(150) CHARACTER SET WIN1252,
    UF        VARCHAR(2) CHARACTER SET WIN1252,
    FONE_RES  INTEGER,
    FONE_COM  INTEGER,
    FONE_CEL  INTEGER,
    PATH_FOTO VARCHAR(150) CHARACTER SET WIN1252,
    HISTORICO VARCHAR(250) CHARACTER SET WIN1252
 );

 /**** Primary Keys ****/
 ALTER TABLE REGISTRO ADD CONSTRAINT PK_REGISTRO PRIMARY KEY (RG);

 /**** Triggers ****/
 SET TERM ^ ;


Ederson


"Pedro Leonardo" <pleonardomv em bol.com.br> 
escreveu na mensagem news:000701c4f8c6$7b39b8d0$0800a8c0 em bandgravacao...
> Pessoal oq tem de errado neste script?  Estou tentando roda-lo no IBExpert
> ele cria o banco mas sem a tabela REGISTRO
>
> SET SQL DIALECT 3;
>
> SET NAMES WIN1252;
>
> CREATE DATABASE 'D:\PGM\Dados\Dados.fdb'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 4096
> DEFAULT CHARACTER SET WIN1252;
>
>
> /**** Tabelas ****/
> CREATE TABLE REGISTRO (
>    RG       VARCHAR(10 ) CHARACTER SET WIN1252 NOT NULL,
>    NOME     VARCHAR(150) CHARACTER SET WIN1252 NOT NULL,
>    CPF      VARCHAR(15) CHARACTER SET WIN1252 NOT NULL,
>    CNH_CAT  VARCHAR(15) CHARACTER SET WIN1252,
>    PRONTUARIO_CRIME  VARCHAR(15) CHARACTER SET WIN1252,
>    PAI      VARCHAR(150) CHARACTER SET WIN1252,
>    MAE      VARCHAR(150) CHARACTER SET WIN1252,
>    DT_NASC  DATE,
>    SEXO     VARCHAR(10) CHARACTER SET WIN1252,
>    NATURALIDADE  VARCHAR(100) CHARACTER SET WIN1252,
>    ESTADO_CIVIL  VARCHAR(15) CHARACTER SET WIN1252,
>    PROFISSAO  VARCHAR(50) CHARACTER SET WIN1252,
>    ENDERECO  VARCHAR(150) CHARACTER SET WIN1252,
>    COR       VARCHAR(50) CHARACTER SET WIN1252,
>    ALTURA    NUMERIC(1,2),
>    OLHOS     VARCHAR(50) CHARACTER SET WIN1252,
>    CABELOS   VARCHAR(50) CHARACTER SET WIN1252,
>    SINAIS    VARCHAR(200) CHARACTER SET WIN1252,
>    MODALIDADE_ACAO  VARCHAR(100) CHARACTER SET WIN1252,
>    RUA       VARCHAR(100) CHARACTER SET WIN1252,
>    BAIRRO    VARCHAR(100) CHARACTER SET WIN1252,
>    CIDADE    VARCHAR(150) CHARACTER SET WIN1252,
>    UF        VARCHAR(2) CHARACTER SET WIN1252,
>    FONE_RES  INTEGER,
>    FONE_COM  INTEGER,
>    FONE_CEL  INTEGER,
>    PATH_FOTO VARCHAR(150) CHARACTER SET WIN1252,
>    HISTORICO VARCHAR(250) CHARACTER SET WIN1252,
> );
>
> /**** Primary Keys ****/
> ALTER TABLE REGISTRO ADD CONSTRAINT PK_REGISTRO PRIMARY KEY (RG);
>
> /**** Triggers ****/
> SET TERM ^ ;
>
> obrigado...
>
>
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
> Para editar sua configuração na lista, use o endereço 
> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
>