Error compiling 6.01

[magi6162]

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:

 

[agraham]

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.

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"

 

[magi6162]

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

 

[agraham]

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

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!

 

[magi6162]

All ok

tnkyvm