Re: MI Updating an integer and/or character column

[peter . corlett]

Yes Michael,
                         MapInfo is treating the expression Landuse = "2"
as a Boolean expression and is giving you the answer F for "false". What
you need to do is just put 2 in the Value.

Cheers,

Pete.



                                                                                       
                                  
                    Michael Goldberg                                                   
                                  
                    <[EMAIL PROTECTED]        To:     "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>                         
                    x.us>                      cc:                                     
                                  
                    Sent by:                   Subject:     MI Updating an integer 
and/or character column               
                    owner-mapinfo-l@lis                                                
                                  
                    ts.csn.net                                                         
                                  
                                                                                       
                                  
                                                                                       
                                  
                    23/05/00 08:38 AM                                                  
                                  
                                                                                       
                                  
                                                                                       
                                  






Dear List,

I'm having trouble updating an integer column in one of my MapInfo tables.
I want to add a number 2 to a column titled LandUse.� I go to Table Update
Column, select the appropriate table and column.� Then in the value section
I put LandUse = 2.� I don't get any results or error messages.� The LandUse
column appears just as before with a 0 in every field.� I then converted
the LandUse column to a character and tried to update the column that way.
This time in Table Update Column in the value section I put LandUse = "2".
This time MI updates the column with an "F".� No matter what character I
try to update the column with I get an F.� Does anybody have a clue to what
is going on here (for the integer and character column)?� Any help would be
greatly appreciated.

Thanks,

Michael Goldberg
GIS Analyst
City of San Antonio, Planning Department
[EMAIL PROTECTED]
(210) 207-6533





----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]