Estou no início de eliminar minha multitabela.
Por enquanto pensei em separar o que se refere a legislação, e o resto.
E não é que tem tabela de lei demais.
São só algumas, por enquanto.
Ainda decidindo se faço assim mesmo.
Moderador: Moderadores
#define AUX_BANCO "BANCO." // bancos
#define AUX_CADCTL "CADCTL" // Contábil para Cadastro
#define AUX_CARCOR "CARCOR" // códigos de carta de correção
#define AUX_CCUSTO "CCUSTO" // centros de custo
#define AUX_CLIGRU "CLIGRU" // Cliente - Grupos
#define AUX_CNAE "CNAE.." // CNAE
#define AUX_CTAADM "CTAADM" // contas administrativas
#define AUX_EDICFG "EDICFG" // configuracao de edi
#define AUX_FILIAL "FILIAL" // filiais
#define AUX_FINOPE "FINOPE" // financeiro - operações
#define AUX_FINPOR "FINPOR" // financeiro - portadores
#define AUX_IPIENQ "IPIENQ" // IPI Enquadramento
#define AUX_LICTIP "LICTIP" // Tipo de licença
#define AUX_LICOBJ "LICOBJ" // Tipo de objeto
#define AUX_MIDIA "MIDIA." // Midia, forma por onde chegou o cliente
#define AUX_MODFIS "MODFIS" // Modelo de documento fiscal
#define AUX_MOTIVO "MOTIVO" // Motivo de cancelamento
#define AUX_ORIMER "ORIMER" // origem da mercadoria
#define AUX_PISCST "PISCST" // PIS CST
#define AUX_PISENQ "PISENQ" // PIS Enquadramento
#define AUX_PPRECO "PPRECO" // percentuais de tabelas de preço
#define AUX_PROUNI "PROUNI" // Produto unidade
#define AUX_QUAASS "QUAASS" // Qualificação do Assinante
#define AUX_TABAUX "TABAUX" // Tabelas Auxiliares
#define AUX_TRICAD "TRICAD" // Tributação de Cadastros
#define AUX_TRIEMP "TRIEMP" // Tributação de empresa
#define AUX_TRIPRO "TRIPRO" // Tributação de produtos
#define AUX_TRIUF "TRIUF." // Tributação de UFs
" LEFT JOIN JPAUXILIAR AS AUXTRIUF ON AUXTRIUF.AXTABELA=" + StringSQL( AUX_TRIUF ) + " AND AUXTRIUF.AXCODIGO = JPIMPOSTO.IMTRIUF" + ;
" LEFT JOIN JPAUXILIAR AS AUXTRICAD ON AUXTRICAD.AXTABELA=" + StringSQL( AUX_TRICAD ) + " AND AUXTRICAD.AXCODIGO = JPIMPOSTO.IMTRICAD" + ;
" LEFT JOIN JPAUXILIAR AS AUXTRIPRO ON AUXTRIPRO.AXTABELA=" + StringSQL( AUX_TRIPRO ) + " AND AUXTRIPRO.AXCODIGO = JPIMPOSTO.IMTRIPRO" + ;
" LEFT JOIN JPTABTRIUF ON JPTABTRIUF.IDTRIUF = JPIMPOSTO.IMTRIUF" + ;
" LEFT JOIN JPTABTRICAD ON JPTABTRICAD.IDTRICAD = JPIMPOSTO.IMTRICAD" + ;
" LEFT JOIN JPTABTRIPRO ON JPTABTRIPRO.IDTRIPRO = JPIMPOSTO.IMTRIPRO" + ;
" LEFT JOIN JPAUXILIAR AS AUXTRIUF ON AUXTRIUF.AXTABELA=" + StringSQL( AUX_TRIUF ) + " AND AUXTRIUF.AXCODIGO = JPIMPOSTO.IMTRIUF" + ;
" LEFT JOIN JPTABTRICAD ON JPTABTRICAD.IDTRICAD = JPIMPOSTO.IMTRICAD" + ;
#define AUX_CADCTL "CADCTL" // Contábil para Cadastro
#define AUX_CARCOR "CARCOR" // códigos de carta de correção
#define AUX_CCUSTO "CCUSTO" // centros de custo
#define AUX_CNAE "CNAE.." // CNAE
#define AUX_CTAADM "CTAADM" // contas administrativas
#define AUX_EDICFG "EDICFG" // configuracao de edi
#define AUX_LICTIP "LICTIP" // Tipo de licença
#define AUX_LICOBJ "LICOBJ" // Tipo de objeto
#define AUX_MODFIS "MODFIS" // Modelo de documento fiscal
#define AUX_ORIMER "ORIMER" // origem da mercadoria
#define AUX_PISCST "PISCST" // PIS CST
#define AUX_PISENQ "PISENQ" // PIS Enquadramento
#define AUX_PPRECO "PPRECO" // percentuais de tabelas de preço
#define AUX_QUAASS "QUAASS" // Qualificação do Assinante
#define AUX_TABAUX "TABAUX" // Tabelas Auxiliares
WITH OBJECT cnSQL
:cSQL := "SELECT * FROM JPAUXILIAR"
:Execute()
DO WHILE ! :Eof()
DO CASE
CASE :String( "AXTABELA" ) == "PRODEP"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDPRODEP", :Number( "AXCODIGO" ) )
:QueryAdd( "PRODEPNOME", :String( "AXDESCRI" ) )
:QueryAdd( "PRODEPINFINC", :String( "AXINFINC" ) )
:QueryAdd( "PRODEPINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABPRODEP", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "PRODEP" ) + " AND AXCODIGO=" + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "PROGRU"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDPROGRU", :Number( "AXCODIGO" ) )
:QueryAdd( "PROGRUNOME", :String( "AXDESCRI" ) )
:QueryAdd( "PROGRUINFINC", :String( "AXINFINC" ) )
:QueryAdd( "PROGRUINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABPROGRU", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "PROGRU" ) + " AND AXCODIGO=" + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "PROSEC"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDPROSEC", :Number( "AXCODIGO" ) )
:QueryAdd( "PROSECNOME", :String( "AXDESCRI" ) )
:QueryAdd( "PROSECINFINC", :String( "AXINFINC" ) )
:QueryAdd( "PROSECINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABPROSEC", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "PROSEC" ) + " AND AXCODIGO=" + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "PROLOC"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDPROLOC", :Number( "AXCODIGO" ) )
:QueryAdd( "PROLOCNOME", :String( "AXDESCRI" ) )
:QueryAdd( "PROLOCINFINC", :String( "AXINFINC" ) )
:QueryAdd( "PROLOCINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABPROLOC", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "PROLOC" ) + " AND AXCODIGO=" + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "CFOP.."
IF ! Empty( :String( "AXCODIGO" ) )
:QueryCreate()
:QueryAdd( "IDCFOP", :String( "AXCODIGO" ) )
:QueryAdd( "CFOPNOME", :String( "AXDESCRI" ) )
:QueryAdd( "CFOPINFINC", :String( "AXINFINC" ) )
:QueryAdd( "CFOPINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABCFOP", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "CFOP.." ) + " AND AXCODIGO=" + StringSQL( :String( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "ICMCST"
IF ! Empty( :String( "AXCODIGO" ) )
:QueryCreate()
:QueryAdd( "IDICMCST", :String( "AXCODIGO" ) )
:QueryAdd( "ICMCSTNOME", :String( "AXDESCRI" ) )
:QueryAdd( "ICMCSTINFINC", :String( "AXINFINC" ) )
:QueryAdd( "ICMCSTINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABICMCST", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "ICMCST" ) + " AND AXCODIGO=" + StringSQL( :String( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "IPICST"
IF ! Empty( :String( "AXCODIGO" ) )
:QueryCreate()
:QueryAdd( "IDIPICST", :String( "AXCODIGO" ) )
:QueryAdd( "IPICSTNOME", :String( "AXDESCRI" ) )
:QueryAdd( "IPICSTINFINC", :String( "AXINFINC" ) )
:QueryAdd( "IPICSTINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABIPICST", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "IPICST" ) + " AND AXCODIGO=" + StringSQL( :String( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "IPIENQ"
IF ! Empty( :String( "AXCODIGO" ) )
:QueryCreate()
:QueryAdd( "IDIPIENQ", :String( "AXCODIGO" ) )
:QueryAdd( "IPIENQNOME", :String( "AXDESCRI" ) )
:QueryAdd( "IPIENQINFINC", :String( "AXINFINC" ) )
:QueryAdd( "IPIENQINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABIPIENQ", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "IPIENQ" ) + " AND AXCODIGO=" + StringSQL( :String( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "PROUNI"
IF ! Empty( :String( "AXCODIGO" ) )
:QueryCreate()
:QueryAdd( "IDUNIDADE", :String( "AXCODIGO" ) )
:QueryAdd( "UNIDNOME", :String( "AXDESCRI" ) )
:QueryAdd( "UNIDINFINC", :String( "AXINFINC" ) )
:QueryAdd( "UNIDINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABUNIDADE", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA=" + StringSQL( "PROUNI" ) + " AND AXCODIGO=" + StringSQL( :String( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "TRICAD"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDTRICAD", :Number( "AXCODIGO" ) )
:QueryAdd( "TRICADNOME", :String( "AXDESCRI" ) )
:QueryAdd( "TRICADINFINC", :String( "AXINFINC" ) )
:QueryAdd( "TRICADINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABTRICAD", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "TRICAD" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "TRIPRO"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDTRIPRO", :Number( "AXCODIGO" ) )
:QueryAdd( "TRIPRONOME", :String( "AXDESCRI" ) )
:QueryAdd( "TRIPROINFINC", :String( "AXINFINC" ) )
:QueryAdd( "TRIPROINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABTRIPRO", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "TRIPRO" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "TRIUF."
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDTRIUF", :Number( "AXCODIGO" ) )
:QueryAdd( "TRIUFNOME", :String( "AXDESCRI" ) )
:QueryAdd( "TRIUFINFINC", :String( "AXINFINC" ) )
:QueryAdd( "TRIUFINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABTRIUF", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "TRIUF." ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "TRIEMP"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDTRIEMP", :Number( "AXCODIGO" ) )
:QueryAdd( "TRIEMPNOME", :String( "AXDESCRI" ) )
:QueryAdd( "TRIEMPINFINC", :String( "AXINFINC" ) )
:QueryAdd( "TRIEMPINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABTRIEMP", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "TRIEMP" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "BANCO."
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDBANCO", :Number( "AXCODIGO" ) )
:QueryAdd( "BANCONOME", :String( "AXDESCRI" ) )
:QueryAdd( "BANCOINFINC", :String( "AXINFINC" ) )
:QueryAdd( "BANCOINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABBANCO", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "BANCO." ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "CLIGRU"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDCADGRU", :Number( "AXCODIGO" ) )
:QueryAdd( "CADGRUNOME", :String( "AXDESCRI" ) )
:QueryAdd( "CADGRUINFINC", :String( "AXINFINC" ) )
:QueryAdd( "CADGRUINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABCADGRU", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "CLIGRU" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "FILIAL"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDFILIAL", :Number( "AXCODIGO" ) )
:QueryAdd( "FILIALNOME", :String( "AXDESCRI" ) )
:QueryAdd( "FILIALINFINC", :String( "AXINFINC" ) )
:QueryAdd( "FILIALINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABFILIAL", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "FILIAL" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "FINOPE"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDFINOPE", :Number( "AXCODIGO" ) )
:QueryAdd( "FINOPENOME", :String( "AXDESCRI" ) )
:QueryAdd( "FINOPEINFINC", :String( "AXINFINC" ) )
:QueryAdd( "FINOPEINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABFINOPE", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "FINOPE" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "FINPOR"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDFINPOR", :Number( "AXCODIGO" ) )
:QueryAdd( "FINPORNOME", :String( "AXDESCRI" ) )
:QueryAdd( "FINPORINFINC", :String( "AXINFINC" ) )
:QueryAdd( "FINPORINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABFINPOR", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "FINPOR" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "MIDIA."
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDMIDIA", :Number( "AXCODIGO" ) )
:QueryAdd( "MIDIANOME", :String( "AXDESCRI" ) )
:QueryAdd( "MIDIAINFINC", :String( "AXINFINC" ) )
:QueryAdd( "MIDIAINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABMIDIA", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "MIDIA." ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
CASE :String( "AXTABELA" ) == "MOTIVO"
IF :Number( "AXCODIGO" ) != 0
:QueryCreate()
:QueryAdd( "IDMOTIVO", :Number( "AXCODIGO" ) )
:QueryAdd( "MOTIVONOME", :String( "AXDESCRI" ) )
:QueryAdd( "MOTIVOINFINC", :String( "AXINFINC" ) )
:QueryAdd( "MOTIVOINFALT", :String( "AXINFALT" ) )
:QueryExecuteInsert( "JPTABMOTIVO", .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "MOTIVO" ) + " AND AXCODIGO = " + NumberSQL( :Number( "AXCODIGO" ) ) )
ENDCASE
:MoveNext()
Inkey()
ENDDO
:CloseRecordset()
STATIC FUNCTION Update0903B()
LOCAL oItem, xCodigo
LOCAL cnSQL := ADOClass():New( AppConexao() )
IF AppConexao() == NIL
RETURN NIL
ENDIF
SayScroll( "2020.09.03 Separação de tabelas" )
WITH OBJECT cnSQL
:cSQL := "SELECT * FROM JPAUXILIAR"
:Execute()
DO WHILE ! :Eof()
FOR EACH oItem IN { ;
{ "JPTABPRODEP", "IDPRODEP", "PRODEPNOME", "PRODEPINFINC", "PRODEPINFALT", "PRODEP", "N" }, ;
{ "JPTABPROGRU", "IDPROGRU", "PROGRUNOME", "PROGRUINFINC", "PROGRUINFALT", "PROGRU", "N" }, ;
{ "JPTABPROSEC", "IDPROSEC", "PROSECNOME", "PROSECINFINC", "PROSECINFALT", "PROSEC", "N" }, ;
{ "JPTABPROLOC", "IDPROLOC", "PROLOCNOME", "PROLOCINFINC", "PROLOCINFALT", "PROLOC", "N" }, ;
{ "JPTABCFOP", "IDCFOP", "CFOPNOME", "CFOPINFINC", "CFOPINFALT", "CFOP..", "C" }, ;
{ "JPTABICMCST", "IDICMCST", "ICMCSTNOME", "ICMCSTINFINC", "ICMCSTINFALT", "ICMCST", "C" }, ;
{ "JPTABIPICST", "IDIPICST", "IPICSTNOME", "IPICSTINFINC", "IPICSTINFALT", "IPICST", "C" }, ;
{ "JPTABIPIENQ", "IDIPIENQ", "IPIENQNOME", "IPIENQINFINC", "IPIENQINFALT", "IPIENQ", "C" }, ;
{ "JPTABPROUNI", "IDPROUNI", "PROUNINOME", "PROUNIINFINC", "PROINIINFALT", "PROUNI", "C" }, ;
{ "JPTABTRICAD", "IDTRICAD", "TRICADNOME", "TRICADINFINC", "TRICADINFALT", "TRICAD", "N" }, ;
{ "JPTABTRIPRO", "IDTRIPRO", "TRIPRONOME", "TRIPROINFINC", "TRIPROINFALT", "TRIPRO", "N" }, ;
{ "JPTABTRIUF", "IDTRIUF", "TRIUFNOME", "TRIUFINFINC", "TRIUFINTALT", "TRIUF.", "N" }, ;
{ "JPTABTRIEMP", "IDTRIEMP", "TRIEMPNOME", "TRIEMPINFINC", "TRIEMPINFALT", "TRIEMP", "N" }, ;
{ "JPTABBANCO", "IDBANCO", "BANCONOME", "BANCOINFINC", "BANCOINFALT", "BANCO.", "N" }, ;
{ "JPTABCADGRU", "IDCADGRU", "CADGRUNOME", "CADGRUINFINC", "CADGRUINFALT", "CLIGRU", "N" }, ;
{ "JPTABFILIAL", "IDFILIAL", "FILIALNOME", "FILIALINFINC", "FILIALINFALT", "FILIAL", "N" }, ;
{ "JPTABFINOPE", "IDFINOPE", "FINOPENOME", "FINOPEINFINC", "FINOPEINFALT", "FINOPE", "N" }, ;
{ "JPTABFINPOR", "IDFINPOR", "FINPORNOME", "FINPORINFINC", "FINPORINFALT", "FINPOR", "N" }, ;
{ "JPTABMIDIA", "IDMIDIA", "MIDIANOME", "MIDIAINFINC", "MIDIAINFALT", "MIDIA.", "N" }, ;
{ "JPTABMOTIVO", "IDMOTIVO", "MOTIVONOME", "MOTIVOINFINC", "MOTIVOINFALT", "MOTIVO", "N" } }
IF :String( "AXTABELA" ) == oItem[ 6 ]
xCodigo := :String( "AXCODIGO" )
IF oItem[ 7 ] == "N"
xCodigo := Val( xCodigo )
ENDIF
IF ! Empty( xCodigo )
:QueryCreate()
:QueryAdd( oItem[ 2 ], iif( oItem[ 7 ] == "N", :Number( "AXCODIGO" ), :String( "AXCODIGO" ) ) )
:QueryAdd( oItem[ 3 ], :String( "AXDESCRI" ) )
:QueryAdd( oItem[ 4 ], :String( "AXINFINC" ) )
:QueryAdd( oItem[ 5 ], :String( "AXINFALT" ) )
:QueryExecuteInsert( oItem[ 1 ], .T. )
ENDIF
:ExecuteCmd( "DELETE FROM JPAUXILIAR WHERE AXTABELA = " + StringSQL( "MOTIVO" ) + " AND AXCODIGO = " + StringSQL( :String( oItem[ 2 ] ) ) )
ENDIF
NEXT
:MoveNext()
Inkey()
ENDDO
:CloseRecordset()
SayScroll( "2020.09.03 Cadastrando em tabelas vazias" )
IF ADORecCount( "JPTABUNIDADE" ) == 0
FOR EACH oItem IN SEFAZ_UNIDADE
:QueryCreate()
:QueryAdd( "IDUNIDADE", oItem[ 1 ] )
:QueryAdd( "UNIDNOME", oItem[ 2 ] )
:QueryExecuteInsert( "JPTABUNIDADE", .T. )
NEXT
ENDIF
IF ADORecCount( "JPTABCFOP" ) == 0
FOR EACH oItem IN SEFAZ_CFOP
:QueryCreate()
:QueryAdd( "IDCFOP", oItem[ 1 ] )
:QueryAdd( "CFOPNOME", oItem[ 2 ] )
:QueryExecuteInsert( "JPTABCFOP", .T. )
NEXT
ENDIF
IF ADORecCount( "JPTABICMCST" ) == 0
FOR EACH oItem IN SEFAZ_ICMCST
:QueryCreate()
:QueryAdd( "IDICMCST", oItem[ 1 ] )
:QueryAdd( "ICMCSTNOME", oItem[ 2 ] )
:QueryExecuteInsert( "JPTABICMCST", .T. )
NEXT
ENDIF
IF ADORecCount( "JPTABIPICST" ) == 0
FOR EACH oItem IN SEFAZ_IPICST
:QueryCreate()
:QueryAdd( "IDIPICST", oItem[ 1 ] )
:QueryAdd( "IPICSTNOME", oItem[ 2 ] )
:QueryExecuteInsert( "JPTABIPICST", .T. )
NEXT
ENDIF
FOR EACH oItem IN { ;
{ "JPTABCADGRU", "IDCADGRU", 1, "CADGRUNOME", "GERAL" }, ;
{ "JPTABCADSTA", "IDCADSTA", 1, "CADSTANOME", "GERAL" }, ;
{ "JPTABFILIAL", "IDFILIAL", 1, "FILIALNOME", "MATRIZ" }, ;
{ "JPTABFINOPE", "IDFINOPE", 1, "FINOPENOME", "GERAL" }, ;
{ "JPTABFINPOR", "IDFINPOR", 1, "FINPORNOME", "GERAL" }, ;
{ "JPTABFORPAG", "IDFORPAG", 1, "FORPAGNOME", "GERAL" }, ;
{ "JPTABIPIENQ", "IDIPIENQ", "999", "IPIENQNOME", "OUTROS" }, ;
{ "JPTABMIDIA", "IDMIDIA", 1, "MIDIANOME", "GERAL" }, ;
{ "JPTABMOTIVO", "IDMOTIVO", 1, "MOTIVONOME", "GERAL" }, ;
{ "JPTABPRODEP", "IDPRODEP", 1, "PRODEPNOME", "GERAL" }, ;
{ "JPTABPROGRU", "IDPROGRU", 1, "PROGRUNOME", "GERAL" }, ;
{ "JPTABPROLOC", "IDPROLOC", 1, "PROLOCNOME", "GERAL" }, ;
{ "JPTABPROSEC", "IDPROSEC", 1, "PROSECNOME", "GERAL" }, ;
{ "JPTABTRICAD", "IDTRICAD", 1, "TRICADNOME", "GERAL" }, ;
{ "JPTABTRIEMP", "IDTRIEMP", 1, "TRIEMPNOME", "GERAL" }, ;
{ "JPTABTRIPRO", "IDTRIPRO", 1, "TRIPRONOME", "GERAL" }, ;
{ "JPTABTRIUF", "IDTRIUF", 1, "TRIUFNOME", "GERAL" } }
IF ADORecCount( oItem[ 1 ] ) == 0
:QueryCreate()
:QueryAdd( oItem[ 2 ], oItem[ 3 ] )
:QueryAdd( oItem[ 4 ], oItem[ 5 ] )
:QueryExecuteInsert( oItem[ 1 ] )
ENDIF
NEXT
ENDWITH
RETURN NIL
IF AppVersaoSQLAnt() < 20200905
IF :TableExists( "JPANPATI" )
:ExecuteCmd( "DROP TABLE JPANPATI" )
ENDIF
IF :TableExists( "JPLEIANPATI" )
:ExecuteCmd( "DROP TABLE JPLEIANPATI" )
ENDIF
IF :TableExists( "JPAUXANPATI" )
:ExecuteCmd( "DROP TABLE JPAUXANPATI" )
ENDIF
IF :TableExists( "JPTABANPATI" )
:ExecuteCmd( "DROP TABLE JPTABANPATI" )
ENDIF
ENDIF
Usuários vendo este fórum: Nenhum usuário registrado online e 6 visitantes