<html><body>
<p><font size="2" face="sans-serif">Hello Piet, thanks for your answer.</font><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>
<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 dePiet De Keyser ---12/04/2017 05:13:40---You can do almost anything with MX, using a proc. But why don't you use your software (winisis? ABCD"></a><a onclick="return _dSectionExpand('1');"><font size="2" color="#424282" face="sans-serif">Piet De Keyser ---12/04/2017 05:13:40---You can do almost anything with MX, using a proc. But why don't you use your software (winisis? ABCD</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 dePiet De Keyser ---12/04/2017 05:13:40---You can do almost anything with MX, using a proc. But why don't you use your software (winisis? ABCD"></a><a onclick="return _dSectionCollapse('1');"><font size="2" color="#424282" face="sans-serif">Piet De Keyser ---12/04/2017 05:13:40---You can do almost anything with MX, using a proc. But why don't you use your software (winisis? ABCD</font></a><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">De: </font><font size="1" face="sans-serif">Piet De Keyser <piet.dekeyser@ucll.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:13</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="3" color="#1F497D" face="Calibri">You can do almost anything with MX, using a proc. But why don’t you use your software (winisis? ABCD?)</font><br>
<font size="3" color="#1F497D" face="Calibri"> </font><br>
<font size="3" color="#1F497D" face="Calibri"> </font><br>
<font size="3" color="#1F497D" face="Calibri">Piet de Keyser</font><br>
<font size="3" color="#1F497D" face="Calibri">UC Leuven, Belgium</font><br>
<font size="3" color="#1F497D" face="Calibri"> </font><br>
<font size="3" face="Calibri"><b>Van:</b></font><font size="3" face="Calibri"> isis-users [</font><font size="3" face="Calibri"><a href="mailto:isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org">mailto:isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org</a></font><font size="3" face="Calibri">] </font><font size="3" face="Calibri"><b>Namens </b></font><font size="3" face="Calibri">Jacqueline Pawlowski Oliveira</font><font size="3" face="Calibri"><b><br>
Verzonden:</b></font><font size="3" face="Calibri"> woensdag 12 april 2017 0:26</font><font size="3" face="Calibri"><b><br>
Aan:</b></font><font size="3" face="Calibri"> isis-users@iccisis.org</font><font size="3" face="Calibri"><b><br>
Onderwerp:</b></font><font size="3" face="Calibri"> [Isis-users] Criar novo registro na Base usando MX</font><br>
<font size="3" face="Times New Roman"> </font>
<p><font size="3" face="Arial">Boa Tarde,</font><font size="3" face="Times New Roman"><br>
<br>
</font><font size="3" face="Arial"><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="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
Obrigada pela ajuda.</font><font size="3" face="Times New Roman"><br>
<br>
</font><font size="3" face="Arial"><br>
_______________<br>
English</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><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="Times New Roman"><br>
</font><font size="3" face="Arial"><br>
Thanks for help.</font><font size="3" face="Times New Roman"><br>
</font><font size="3" face="Arial"><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>
<p></body></html>