using data adaptors
-
I am a little confused on this subject. If a person has a a few tables that they have to join, and they do this through a dataAdaptor, are the update, insert, etc statements that are generated good for all the tables? Only one table out of the tables that are joined needs to be updated, so if it is included in the dataAdaptor, will it be properly updated. The reason that I am confused is that I am reading Francesco Balena's book (very good book) and there is discussion of either using seperate queries for the tables then performing the join on the client side, or making a single query then manually extacting some of the queried data into the seperate tables on the client side. So I am a little confused with what dataAdaptors can and can't do. Thanks for the help.
-
I am a little confused on this subject. If a person has a a few tables that they have to join, and they do this through a dataAdaptor, are the update, insert, etc statements that are generated good for all the tables? Only one table out of the tables that are joined needs to be updated, so if it is included in the dataAdaptor, will it be properly updated. The reason that I am confused is that I am reading Francesco Balena's book (very good book) and there is discussion of either using seperate queries for the tables then performing the join on the client side, or making a single query then manually extacting some of the queried data into the seperate tables on the client side. So I am a little confused with what dataAdaptors can and can't do. Thanks for the help.
-
ok I see that after you make the join that the other queries are not created for you, so I guess you can't do it that way.