AD (728x60)

Tecnologia do Blogger.

Followers

Total de visualizações

Archives

segunda-feira, 20 de janeiro de 2014

Table unknown SISACFOP

Dynamic SQL Error SQL error code = -204
Table unknown 
SISACFOP
At line 1, column 136




Execute a seguinte procedure no CTRL+ F12:
/******************************************************************************/
/*                 Generated by IBExpert 20/01/2014 14:33:10                  */
/******************************************************************************/

/******************************************************************************/
/*        Following SET SQL DIALECT is just for the Database Comparer         */
/******************************************************************************/


/******************************************************************************/
/*                                   Tables                                   */
/******************************************************************************/



CREATE TABLE SISACFOP (
    OPCFO         INTEGER NOT NULL,
    OPGRUPO       SMALLINT,
    OPCODIGO      SMALLINT,
    OPDESCRICAO   VARCHAR(200),
    OPAPLICACAO   BLOB SUB_TYPE 0 SEGMENT SIZE 80,
    OPIND_INDUST  CHAR(1),
    OPIND_ICMS    CHAR(1),
    OPIND_OPSEQ   CHAR(1),
    OPIND_ESTOQ   CHAR(1),
    OPIND_FIN     CHAR(1)
);




/******************************************************************************/
/*                                Primary Keys                                */
/******************************************************************************/

ALTER TABLE SISACFOP ADD CONSTRAINT PK_SISACFOP PRIMARY KEY (OPCFO);


/******************************************************************************/
/*                                 Privileges                                 */
/******************************************************************************/


/* Privileges of users */
GRANT ALL ON SISACFOP TO ADMGER;
GRANT SELECT ON SISACFOP TO AFERICAO;
GRANT ALL ON SISACFOP TO CHEFE;
GRANT SELECT ON SISACFOP TO EMIXZ;
GRANT ALL ON SISACFOP TO LOJA;
GRANT ALL ON SISACFOP TO PISTA;
GRANT ALL ON SISACFOP TO REPLICATOR;
GRANT ALL ON SISACFOP TO TESTE;

Se o erro persistir, contate um facilitador.
Tags: , , ,

Postado por

Um novo sistema que auxilia técnicos da SoftPlus a executarem um trabalho mais rápido e fácil. Desenvolvido e alimentado pelos próprios técnicos.

0 comentários:

Postar um comentário

 

Mais Vistos

Adicionados Recentes

Copyright © SoftFácil | Desenvolvido por Rahel William