These errors mostly appear because you have a variable with the same name as your columns. This is a good reason why you should use some kind of prefix for your variables, eg. Hungarian notation like: Dim szText as String Dim nNumber as Integer Dim dToDay As Date Dim fValue As Float Dim oLine As Object ...
So try to see if you have a variable with one of these names: - ovlpperc - temppop - proport - pop HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: Neil Gibson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 10:44 AM To: [email protected] Subject: MI-L Update column statement? I have three columns in a table, all floats. I want to update the third column with the values of the first two using this statement... update ovlpperc set temppop = proport*pop This works fine when you use 'update column' in mapinfo, but returns a 'Numeric Values Required' error when run in a mapbasic program. Does anyone know why this is, or a way around this? Thanks Neil - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MICROVISION: VOTED NEW DIRECT UK/INTERNATIONAL PRODUCT OF THE YEAR 2004 IDMF DM Business Awards - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - _________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15014 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15015
