Subject | Re: [IBO] strange error message re JOIN |
---|---|
Author | Lele Gaifax |
Post date | 2002-03-22T11:12:42Z |
>>>>> 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.