SQLLite staement syntax

Discussion in 'Questions (Windows Mobile)' started by aureolevoyager, Apr 2, 2008.

  1. aureolevoyager

    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: Apr 2, 2008
  2. aureolevoyager

    aureolevoyager Member Licensed User

    Thanks..it's slowly coming back to me
     
Loading...