Error compiling 6.01

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

  1. magi6162

    magi6162 Well-Known 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 Well-Known 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 Well-Known Member Licensed User

    All ok

    tnkyvm
     
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