<html><body>
<p><font size="2" face="sans-serif">Hello Egbert. thanks for your answer.</font><br>
<br>
<br>
<font size="2" face="sans-serif">I'm not using winisis because I'm doing an integration with another system that will read a data file, compare it with the CPF and if this CPF does not exist in my isis database it will include data from an file input.txt. But for this I need to compare whether or not the CPF exists on the isis database. If the existing CPF does not make inclusion of the registry.</font><br>
<br>
<font size="2" face="sans-serif">How would the proc command in this case?</font><br>
<br>
<font size="2" face="sans-serif">Thanks</font><br>
<font size="2" face="sans-serif">____________________________________________<br>
Jacqueline Pawlowski Oliveira<br>
Divisão de Tratamento e Tecnologia da Informação<br>
Biblioteca Universitária/UFMG<br>
Tel: (031) 3409-4619</font><br>
<script language="JavaScript" type="text/javascript">
<!--
function _dSectionExpand(sec) {
document.getElementById("cSec"+sec).style.display = "none";
document.getElementById("xSec"+sec).style.display = "block";
}
function _dSectionCollapse(sec) {
document.getElementById("xSec"+sec).style.display = "none";
document.getElementById("cSec"+sec).style.display = "block";
}
// -->
</script>
<div id="cSec1"><a href="javascript:_dSectionExpand('1')" onclick="return _dSectionExpand('1');"><img src="/icons/expand.gif" border="0" alt="Mostrar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete"></a><a onclick="return _dSectionExpand('1');"><font size="2" color="#424282" face="sans-serif">De Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete</font></a></div><div id="xSec1"><a href="javascript:_dSectionCollapse('1')" onclick="return _dSectionCollapse('1');"><img src="/icons/collapse.gif" border="0" alt="Ocultar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete"></a><a onclick="return _dSectionCollapse('1');"><font size="2" color="#424282" face="sans-serif">De Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete</font></a><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">De: </font><font size="1" face="sans-serif">De Smet Egbert <egbert.desmet@uantwerpen.be></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Para: </font><font size="1" face="sans-serif">Jacqueline Pawlowski Oliveira <jackie@bu.ufmg.br>, "isis-users@iccisis.org" <isis-users@iccisis.org></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Data: </font><font size="1" face="sans-serif">12/04/2017 05:23</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Assunto: </font><font size="1" face="sans-serif">RE: [Isis-users] Criar novo registro na Base usando MX</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font size="2" face="Tahoma">Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete the records, in a separate database, which don't have the value '12345' as CPF and then import (append) that resulting set of records in your database.<br>
</font><br>
<font size="2" face="Tahoma">Egbert de Smet<br>
Universiteit Antwerpen</font><br>
<hr width="100%" size="2" align="left"><br>
<font size="2" face="Tahoma"><b>From:</b></font><font size="2" face="Tahoma"> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of Jacqueline Pawlowski Oliveira [jackie@bu.ufmg.br]</font><font size="2" face="Tahoma"><b><br>
Sent:</b></font><font size="2" face="Tahoma"> Wednesday, April 12, 2017 12:25 AM</font><font size="2" face="Tahoma"><b><br>
To:</b></font><font size="2" face="Tahoma"> isis-users@iccisis.org</font><font size="2" face="Tahoma"><b><br>
Subject:</b></font><font size="2" face="Tahoma"> [Isis-users] Criar novo registro na Base usando MX</font><font size="3" face="Roman"><br>
</font><br>
<font size="2" face="sans-serif">Boa Tarde,</font><font size="3" face="Roman"><br>
<br>
</font><font size="2" face="sans-serif"><br>
Preciso inserir dados em uma base de dados ISIS, acrescentando novos registros. (update). Mas tenho que fazer uma validação antes. Por exemplo: Se existir o dado de CPF= 12345 então não faça nada, se não, inserir um novo MFN com dados de campo 100, 245 e 300. Qual a melhor forma de fazer? Posso fazer usando o MX?</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Obrigada pela ajuda.</font><font size="3" face="Roman"><br>
<br>
</font><font size="2" face="sans-serif"><br>
_______________<br>
English</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
I need to insert data into an ISIS database, adding new records. (Update). But I have to do a validation before. For example: If the CPF data = 12345 then do nothing, else insert a new MFN with field v100(data), v245(data) and v300(data) . What is the best way to do it? Can I do it using MX?</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Thanks for help.</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Sorry my English :)<br>
____________________________________________<br>
Jacqueline Pawlowski Oliveira<br>
Divisão de Tratamento e Tecnologia da Informação<br>
Biblioteca Universitária/UFMG<br>
Tel: (031) 3409-4619</font></div>
<script language="JavaScript" type="text/javascript">
<!--
_dSectionExpand('1');
// -->
</script>
<br>
</body></html>