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?
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gambas-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user
