About sequences that works BAD !!!!

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hello everyone:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">We are working with serials fields and we found a problem with then: When we insert in a
tablethat has e unique restrict, and this makes insert fails, the sequence increments anyway…¿What we can do about
it?</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">We hope you can help us…..</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt">AlexisPalma Espinosa</span></font>. <p class="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt">Ingeniero en Informática.</span></font><p class="MsoNormal"><i><font face="Times New Roman" size="4"><span
lang="EN-GB"style="font-size:14.0pt;font-style:italic">"If you are not part of the solution...you are part of the
problem"</span></font></i><i><fontsize="4"><span lang="EN-GB"
style="font-size:14.0pt;font-style:italic"></span></font></i><pclass="MsoNormal"><font face="Times New Roman"
size="3"><spanlang="EN-GB" style="font-size:12.0pt"> </span></font></div>