ambiguous columname 'ID'

[norwegen60]

Hello,
with TUniQuery I have following Problem:

Code: Select all

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

Code: Select all

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

Code: Select all

MasterFields = ''

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

thanks
Gerd

[AlexP]

Hello,

To resolve the problem you should set the DetailFiled property like

DetailFiled := 'S.ID';

[norwegen60]

To resolve the problem you should set the DetailFiled property like

DetailFiled := 'S.ID';

Perfect! Now it runs

Thanks, Gerd

[AlexP]

Hello,

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