SQLLite staement syntax

aureolevoyager

Member
Licensed User
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
 
Last edited:
Top