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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice