Thnaks Mats! I checked and found that apart from the numeric data Iimported
from Excel for polygons lots 0 has come atomatically for corrosponding Id of
lines. Actually i imported these DXF files from Autocad as polygon. Apart
from manualy changing the values can u suggest something so that the table
showing numeric data shows only <>0values.
Thanks a ton.
Sujit
-----Original Message-----
From: Mats Elfstr�m <[EMAIL PROTECTED]>
To: Sujit Choudhury <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 04 July 2000 05:19
Subject: Re: MI Date: Mon, 3 Jul 2000 17:50:05 +0600
>> Sujit Choudhury wrote:
>>
>> Every time in SQL query I wanted to devide a column by another column
>> with a condition (although it is showing syntax is correct) it shows
>> an error msg Try to devide by zero.
>>
>> Can any one help me.
>
>Well Sujit, a number of things to check here:
>Is the column numeric? Probably, else you would not have attempted to do
>what you are trying to.
>Then, check that all records have a value in this column, else the
>expression will fail when it encounters a zero value.
>To avoid this, pre-select all records with a value <> 0 before the
>division, or add a small fraction such as 0.0001 to all values thus
>removing any zero value.
>
>HTH Mats.E
>--
>:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>:Email/ [EMAIL PROTECTED] ICQ#9517386 :
>:---------------------------------------------------------------------:
>:Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN:
>:Phones: +46 46 145959, +46 70 595 3935 :
>:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
