<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">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>
<br>
<div>
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF666391" style="direction: ltr;"><font color="#000000" size="2" face="Tahoma"><b>From:</b> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of Jacqueline Pawlowski Oliveira [jackie@bu.ufmg.br]<br>
<b>Sent:</b> Wednesday, April 12, 2017 12:25 AM<br>
<b>To:</b> isis-users@iccisis.org<br>
<b>Subject:</b> [Isis-users] Criar novo registro na Base usando MX<br>
</font><br>
</div>
<div></div>
<div>
<p><font size="2" face="sans-serif">Boa Tarde,</font><br>
<br>
<br>
<font size="2" face="sans-serif">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><br>
<br>
<font size="2" face="sans-serif">Obrigada pela ajuda.</font><br>
<br>
<br>
<font size="2" face="sans-serif">_______________</font><br>
<font size="2" face="sans-serif">English</font><br>
<br>
<font size="2" face="sans-serif">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><br>
<br>
<font size="2" face="sans-serif">Thanks for help.</font><br>
<br>
<font size="2" face="sans-serif">Sorry my English :)</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></p>
</div>
</div>
</div>
</body>
</html>