0

In my xml dataset, I've two fields with the same name coming from two different tables. How can I use both fields in the field list?

SJaka
  • 712
  • 13
  • 40

2 Answers2

1

You can't - you'll need to rename one of them.

If you think about it, it makes no sense to have two fields with the same name in one dataset...it would be impossibly ambiguous, you wouldn't be able reliably fetch the data that you need because when you refer to that field it would be impossible to tell which one you meant.

Dan Scally
  • 1,922
  • 1
  • 19
  • 31
  • That is correct, but can I qualify it with table name or something? I need both fields and I can't change field names in the database since it is from the ERP provider. Is there a way to define aliases etc.? – SJaka Oct 20 '16 at 16:56
0

If you are using stored procedures then you can give two different alias names to fields with same name.

Ravi Matani
  • 804
  • 1
  • 8
  • 21