Show us what query is being made in the SQL trace monitor as well as the DFM
text for the component.

It likely has to do with KeyLinks that don't have the table prefix on it.

Jason Wharton

> -----Original Message-----
> From: james_027 [mailto:james_027@...]
> Sent: Wednesday, November 10, 2004 6:06 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] ib_query with left join invalidaterownum() problem
>
> 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