Hi All,
I'm trying a very simple program to record my GPS location every minute and/or 5 meters.
The Location_Changed function is providing the data but where I included an SQL function to insert
data into the database I'm getting 2 records for the same location. It appears as if the function is holding a value and when a new location comes along it fires the SQL because the old location has changed and then finds that the new value now exists and fires it a second time. I've had to resolve using an alternating boolean value. Any ideas what exactly is happening and proper resolution?
Second issue i have is that I'm storing the data in a table using dbutils ExecuteHTML. The Lat and Lon fields only display to 4/5 decimal places - I want to display 8 decimal places. Can someone please explain the use of HTMLCSS noted with this function and better still provide a simple working example. Others have requested this option explained and "Search the forums " is not a helpful answer.
Richard
I'm trying a very simple program to record my GPS location every minute and/or 5 meters.
The Location_Changed function is providing the data but where I included an SQL function to insert
data into the database I'm getting 2 records for the same location. It appears as if the function is holding a value and when a new location comes along it fires the SQL because the old location has changed and then finds that the new value now exists and fires it a second time. I've had to resolve using an alternating boolean value. Any ideas what exactly is happening and proper resolution?
Second issue i have is that I'm storing the data in a table using dbutils ExecuteHTML. The Lat and Lon fields only display to 4/5 decimal places - I want to display 8 decimal places. Can someone please explain the use of HTMLCSS noted with this function and better still provide a simple working example. Others have requested this option explained and "Search the forums " is not a helpful answer.
Richard
