Ouch! Doubles treated as Currency?

1

That hurts …

2

… at least the old ways work (in 2018 R3):

Dim db As New SQLiteDatabase

If db.Connect Then
  
  db.SQLExecute("CREATE TABLE test (id INT NOT NULL PRIMARY KEY, lat DOUBLE, lon DOUBLE);")
  db.SQLExecute("INSERT INTO test (id, lat, lon) VALUES (1, 3.145678909, 41.22559977);")
  
  Dim data As RecordSet = db.SQLSelect("SELECT * FROM test;")
  
  If data <> Nil Then
    
    While Not data.EOF
      Dim rowlat As Double = data.Field("lat").DoubleValue
      Dim rowslat As Double = data.Field("lat").DoubleValue
      Dim rowlon As Double = data.Field("lon").DoubleValue
      Dim rowslon As Double = data.Field("lon").DoubleValue
      Break
      data.MoveNext
    Wend
    data.Close
    
  End If
  
End If
3

Oh Oh, maybe we shouldn’t mention Xojo anywhere close to words like “Professional” or “Enterprise”

1 Like
4

Such an obvious example of “never tested”
And its not restricted to JUST desktop apps
It hits ANY API 2 app

ugh

5

I wonder if this is a Mac issue since I don’t see the problem on Windows 11 with Xojo 2021r3.1. There is no indication in the TOF thread of what version/OS is seeing the issue.

6

Xojo will likely say it’s not right, but it’s been that way, so fixing it will break apps, so nah…

7

it happens on all xojo 2022r1, any platform.

8

Marked as fixed. Hope it gets into a dot release ASAP.