Error compiling 6.01

Discussion in 'Questions (Windows Mobile)' started by magi6162, Jan 14, 2008.

  1. magi6162

    magi6162 Active Member Licensed User

    this line:

    cmd.CommandText = "SELECT Tipo,Data,Motivo FROM Calendario WHERE Data >= '" & aai & "-" & RiempiStringa(mmi,2) & "-" RiempiStringa(ggi,2) & "' AND Data <= '" & aaf & "-" & RiempiStringa(mmf,2) & "-" & RiempiStringa(ggf,2) & "' ORDER BY Tipo,Data"

    compiling 6.01 syntax error

    compiling 5.80 all OK

    why?:sign0085:
     
  2. agraham

    agraham Expert Licensed User

    You are missing an ampersand (in bold) which is the usual source of this problem. Also you may be missing a single quote at the very end of the string.
     
  3. magi6162

    magi6162 Active Member Licensed User

    I use SQLite and string SQL all OK
    if i compile with b4ppc 5.8 all OK
     
  4. agraham

    agraham Expert Licensed User

    That still doesn't alter the fact that you ARE missing an ampersand as I indicated! 5.80 will compile without it 6.01 will not!
     
  5. magi6162

    magi6162 Active Member Licensed User

    All ok

    tnkyvm
     
Loading...