SQLLite staement syntax

[aureolevoyager]

Returning to Basic after 25 years using Pascal ^Delphi, so grateful for help in specifying the syntax for an SQLLite update statement in BASIC

I want to update a record in the database where the values to be inserted in the fields are numbers - so

UPDATE SITES SET LATITUDE = fltLAT,LONGITUDE = fltLONG WHERE SITE = intSITE_ID

Gloval variables are

fltLAT and fltLONG are real
intSITE is an integer

I know BASIC is very tolerant of typing, but where do the ",',& go in the string I pass to CommandText?

Thanks in advance

Peter Y
UK

[badkarma]

try:

mystring = "UPDATE SITES SET LATITUDE = " & fltLAT & ", LONGITUDE = " & fltLONG & " WHERE SITE = " & intSITE_ID

then execute mystring

[aureolevoyager]

Thanks..it's slowly coming back to me