I am using D3 and IBO3.

with TIBOQuery.Create(Self) do
try
databaseName:='cb4db';
sql.Add('select');
sql.Add('y_mov,');
sql.Add('d_mov,');
sql.Add('n_mov,');
sql.Add('tip_doc,');
sql.Add('n_doc,');
sql.Add('d_doc,');
sql.Add('note,');
sql.Add('serie,');
sql.Add('prezzo,');
sql.Add('qta,');
sql.Add('um,');
sql.Add('cod_acc');
sql.Add('from mv_hd, mv_dl, mv_li, mv_dg, art'); {1}
Prepare;
...
finally
Free;
end;

When the Prepare command is executed, I get the error "column not found
MV_HD".

It seems that IBO changes the code above adding the following line to {1}

mv_hd, mv_dl, mv_li, mv_dg, art.rdb$db_key

Why does IBO do that and what's wrong with my code ?

Thank you

Duilio Foschi