[Gambas-user] SQLite3 table column won't update

[John Rose]

In my app, I can update one SQLite3 database's table's column (latitude)
OK but not another (site_number). 

Create table fragment:
Create Table site (_id Integer Primary Key AutoIncrement,
                   site_number Integer,
                   site Text Not Null,
                   latitude Float,

I have using ResultSite Dim as a SQL Result with a MoveTo method to the
appropriate row having executed:
  Print "SiteNumber Before=" & ResultSite!site_number
  Print "SiteNumber Change=" & SiteNumber
  ResultSite!site_number = SiteNumber
  Print "SiteNumber After=" & ResultSite!site_number
  Print "Lat Before=" & ResultSite!latitude
  Print "Lat Change=" & Latitude
  ResultSite!latitude = Latitude
  Print "Lat After=" & ResultSite!latitude

When running, I get on console:
SiteNumber Before=1
SiteNumber Change=8
SiteNumber After=1
Lat Before=46.857158
Lat Change=48.857158
Lat After=48.857158

What am I missing?