Devart Forums

i have oraQuery with :

select * from mat_dostawy MD left join indeksy_dla_kontrahentow IDK on
idk.indeks_czesci = md.indeks_czesci
inner join kontrahenci plat on md.numer_kontrahenta=plat.numer_kontrahenta
inner join kontrahenci odbior on md.numer_odbiorcy=odbior.numer_kontrahenta
where numer_lif like :par_numer_lif


in delphi i have

with OraQuery1 do begin
if Active = True then Close;
ParamByName('par_numer_lif').asString = 'test5';
Prepare;
Open;
end;

result is one record with nothing data.


when i edit text on oraQuery to

select * from mat_dostawy MD left join indeksy_dla_kontrahentow IDK on
idk.indeks_czesci = md.indeks_czesci
inner join kontrahenci plat on md.numer_kontrahenta=plat.numer_kontrahenta
inner join kontrahenci odbior on md.numer_odbiorcy=odbior.numer_kontrahenta
where numer_lif like 'test5'

i see one record with data.

Why my first resolution dont give any record??

We could not reproduce this problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.