Subject ib_query with left join invalidaterownum() problem
Author james_027
I have ib_query containing the following sql ...

SELECT M.*,
(select description from account_titles_details d where d.id =
m.expense_type) as Account_Title,
D2."InvNo"
FROM CHECKVOUCHER_DETAILS M LEFT JOIN "invoice" d2 on d2.id = m.doc_id

What I want to achieve here is that after posting a new record I want
the new record to immediately display the d2.InvNo column. My problem
is that after the post the d2.InvNo value is not display until the
ib_query is close and open. What I did is to perform
ib_query.invalidaterownum(ib_query.recno) or ib_query.refresh but Iam
getting an error saying ambiguous field name between table
checkvoucher_details and table invoice ID.

Has anybody come across this kind of situation? Any tips?

Thanks.


Regards,
James