Subject Re: [IBO] strange error message re JOIN
Author Lele Gaifax
>>>>> On Fri, 22 Mar 2002 11:00:30 -0000, "duilio_f" <dedalus@...> said:

df> SQL.Add('mv_li.cod_mag="'+GetBtwPar(MovArtFrm.CodMagBox.Text)
df> +'"'); SQL.Add('order by cod_art, d_mov'); Prepare;

You shouldn't be using Double Quotes there! The condition must be
something like:

mv_li.cod_mag = 'BLABLA'

and Not

mv_li.cod_mag = "BLABLA"

This at least under Dialect 3, where you use double quotes for fancy
field names.

I would suggest using QuoteStr for that too :)

hth,
bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.