Devart Forums

Posted: **Mon 21 Feb 2011 14:51**

Hello,
with TUniQuery I have following Problem:

SQL = 'select * from Ser_Nr'
DetailFiled ='ID'
MasterFields = 'ID'
MasterSource = 'dbdsTable2'

Everything is OK and I can open the SQL without problems. But then, if I change

SQL = SELECT S.*, E.Name as defErstUser
FROM Ser_nr S
LEFT OUTER JOIN Who_Gru1 E on E.ID = S.ErstUserID

I get the message "Mehrdeutiger Spaltenname 'ID'" No problem again, if I set

MasterFields = ''

This was no problem with ADODataset. What´s wrong?

thanks
Gerd

Posted: **Tue 22 Feb 2011 08:27**

Hello,

To resolve the problem you should set the DetailFiled property like

DetailFiled := 'S.ID';

Posted: **Sun 27 Feb 2011 14:57**

AlexP wrote:To resolve the problem you should set the DetailFiled property like

DetailFiled := 'S.ID';

Perfect! Now it runs

Thanks, Gerd

Posted: **Mon 28 Feb 2011 07:13**

Hello,

It is good to see that this problem was solved. If any other questions come up, please contact us.

ambiguous columname 'ID'