Sergey
4 years agoContributor III
join statement in SQL command type data adapter/grid view
Hi all,
EDIT : I was able to sort this out with some more SQL 🙂
I wanted to confirm one point regarding data adapter using SQL statement.
Right now, I am using a data adapter with SQL command type, which is using a "join" statement to 2 other tables. When I test this data adapter, it is working as expected and I can see the columns coming from the other tables.
However, when I use this data adapter in a Grid View components, then the columns that are supposed to be from the joined tables do not appear. Are there any SQL restrictions when it comes to using SQL commande data adapter in gris view components ?
Many thanks,