<p><font size="2" face="Verdana">Hallo,<br>
Wie kann ich innerhalb einer SQL Anweisung der Division durch 0
vorbeugen ?</font></p>
<table border="1" cellspacing="0">
<tr>
<td><font size="2" face="Verdana">A</font></td>
<td><font size="2" face="Verdana">B</font></td>
<td valign="top" rowspan="5"><font size="2"
face="Verdana">SELECT Test.A, Test.B, [A]/[B] AS ERG<br>
FROM Test liefert:</font><table border="1"
cellspacing="0">
<tr>
<td align="center"><font size="2" face="Verdana">A</font></td>
<td align="center"><font size="2" face="Verdana">B</font></td>
<td align="center"><font size="2" face="Verdana">ERG</font></td>
</tr>
<tr>
<td align="center"><font size="2" face="Verdana">23,3</font></td>
<td align="center"><font size="2" face="Verdana">4</font></td>
<td align="center"><font size="2" face="Verdana">5,825</font></td>
</tr>
<tr>
<td align="center"><font size="2" face="Verdana">23,3</font></td>
<td align="center"><font size="2" face="Verdana">4</font></td>
<td align="center"><font size="2" face="Verdana">5,825</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><font size="2" face="Verdana">23,3</font></td>
<td><font size="2" face="Verdana">4</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">34</font></td>
<td><font size="2" face="Verdana">0</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">23</font></td>
<td><font size="2" face="Verdana">0</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">354</font></td>
<td><font size="2" face="Verdana">35</font></td>
</tr>
</table>
<p><font size="2" face="Verdana">Interessanterweise ist
Query.Recordcount=4 !!!</font></p>
<p><font size="2" face="Verdana">Ist es möglich, dass Ich bei der
Division durch 0 im Feld ERG den Wert 0 erhalte?</font></p>
<p><font size="2" face="Verdana">:-) Jens Schumann</font></p>
Wie kann ich innerhalb einer SQL Anweisung der Division durch 0
vorbeugen ?</font></p>
<table border="1" cellspacing="0">
<tr>
<td><font size="2" face="Verdana">A</font></td>
<td><font size="2" face="Verdana">B</font></td>
<td valign="top" rowspan="5"><font size="2"
face="Verdana">SELECT Test.A, Test.B, [A]/[B] AS ERG<br>
FROM Test liefert:</font><table border="1"
cellspacing="0">
<tr>
<td align="center"><font size="2" face="Verdana">A</font></td>
<td align="center"><font size="2" face="Verdana">B</font></td>
<td align="center"><font size="2" face="Verdana">ERG</font></td>
</tr>
<tr>
<td align="center"><font size="2" face="Verdana">23,3</font></td>
<td align="center"><font size="2" face="Verdana">4</font></td>
<td align="center"><font size="2" face="Verdana">5,825</font></td>
</tr>
<tr>
<td align="center"><font size="2" face="Verdana">23,3</font></td>
<td align="center"><font size="2" face="Verdana">4</font></td>
<td align="center"><font size="2" face="Verdana">5,825</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><font size="2" face="Verdana">23,3</font></td>
<td><font size="2" face="Verdana">4</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">34</font></td>
<td><font size="2" face="Verdana">0</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">23</font></td>
<td><font size="2" face="Verdana">0</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana">354</font></td>
<td><font size="2" face="Verdana">35</font></td>
</tr>
</table>
<p><font size="2" face="Verdana">Interessanterweise ist
Query.Recordcount=4 !!!</font></p>
<p><font size="2" face="Verdana">Ist es möglich, dass Ich bei der
Division durch 0 im Feld ERG den Wert 0 erhalte?</font></p>
<p><font size="2" face="Verdana">:-) Jens Schumann</font></p>
Comment