From: Helen B. <he...@tp...> - 2009-06-25 14:30:52
|
At 06:26 PM 25/06/2009, you wrote: >If I understand correctly we're using form a), and it's still causing >problems. Form a) was not in either of your examples. For form b) I made a typo when I copy/pasted, as well. It should be b) using aliases only: select o.id, m.id from marker m, object o where m.id = o.id >The Firebird database is not the one "complaining" but the "provider" >itself. Are you saying that you get the message like [an item with the same key has already been added] when you perform a SELECT? >I mean, I don't have an issue due to syntax a) or b) or mixing them. The >issue is because the Firebird provider can't handle (at least what >showed up debugging the code) something like: > >select o.id, m.id > >since they both use the name "ID" as column name. The provider could not work for anybody if that were true. >Is it clear now? It seems there are some facts missing from your case. Helen |