Thanks to Russ Lawley and Anitra Robinson for their help with my overflow error. The error seems to stem from performing the join on columns, one of which was Integer and the other Small Integer. Russel Lawley wrote: this is fairly common, so I agree...where's the @~#*£%$" help notes!. It happens if your table 'join' generates big numbers during "sum" operations and your table columns are only set up for "small" numbers. i.e., one of the columns is made of "Small integer" and the join results in the column having values in excess of 32,0000 (give or take a few). Thanks, Chris Perry Corporate Systems CoOrdinator Parks Victoria Melbourne, Australia Ph: 61 3 9816 6800 Fax: 61 3 9816 7222 [EMAIL PROTECTED] ...from 22 Jan 2001: Level 13 / 535 Bourke Street Melbourne Vic 3000 Ph: 61 3 8627 4600 Fax: 61 3 9619 0700 PERRY Chris wrote: > Hi Mappers, > > When trying to join 2 tables on a column using an SQL query we get the very > informative error "Overflow". This doesn't seem to be documented anywhere; > so can anyone shed some light as to what it means and what may be causing > this error. ********************************************************************** This message and any files transmitted with it are intended only for the addressee. This message may contain confidential or privileged information. If you are not the addressee of this message you must not read, copy, distribute this information or take an action in reliance on it. If you have received this message in error you are requested to immediately contact the sender or Parks Victoria at [EMAIL PROTECTED] and delete the original and any copies of this message and any files transmitted with it. The views expressed in this message are those of the individual sender, except where the sender has the authority and specifically states them to be the views of Parks Victoria. Parks Victoria accepts no liability for any damage caused in the transmission, receipt or opening of this message and any files transmitted with it. ********************************************************************** _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
