Re: MI Date: Mon, 3 Jul 2000 17:50:05 +0600

[Sujit Choudhury]

Thanks martin, I found the problem Apart fm thre polygon fall the polyline also have ID when I have made the table i have not thought of  this Ids but when checked the broswer after suggestion fm the listers. Now the problem is how to get rid of these zeros fm the table.   Is it possible in one stroke or I have to Change each and every one manually.   Cheers   Sujit -----Original Message----- From: Martin, Christopher (WSAMID Telford) <[EMAIL PROTECTED]> To: 'Sujit Choudhury' <[EMAIL PROTECTED]> Date: 04 July 2000 14:15 Subject: RE: MI Date: Mon, 3 Jul 2000 17:50:05 +0600 I know this might seem obvious, but do you have any zero values or blank fields?? Are both columns numeric? Check neither is text....     -----Original Message----- From: Sujit Choudhury [mailto:[EMAIL PROTECTED]] Sent: 03 July 2000 16:21 To: [EMAIL PROTECTED] Subject: MI Date: Mon, 3 Jul 2000 17:50:05 +0600 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.   Sujit