Group: Forum Members
Posts: 524,
Visits: 30K
|
Tried using a view with the extra column for the BD, but when it does a select for the main BO it still does not create that column.
Am I really being that thick? I want a calculated column in a BO to persist after a BD gets records.
I am going to try the approach I outline below but I would still appreciate any insight on how to get data from a BD without redefining the structure of the currentdatatable back to the SQL table defined columns
In my biggest SF app to get around this problem I grab the PKs of the BD result, create a datatable that I pass to tablevalued parameter in an SP to get my records ( posted how to do this in user contributed samples a couple years ago. )
Works great for a single key. The problem here is that I have a compound key ... so as i am writing this, it occurs to me that since I have the mykey in my BD result I can use that single value to pass in as a TVP to an SP that will return my records - and will have the row !
Will report my results.
|