Lynda Posted August 3, 2023 Report Share Posted August 3, 2023 I have a VERY complex Submission data page. Right now it's working but it's taking 8 seconds to load and 4 seconds to recalculate. Because it is a Submission, I do not have the luxury of a view. The FoodID is passed to the DP. Because I cannot do a single call to the table and retrieve multiple fields (I tried and was blocked), I must do individual calls for each field that I need: 3 tables, 36 calls I am wondering if I can take this out of the DP and put this into a script, do the database calls, load the virtual fields and then put them back into play within that DP. Any ideas? Lynda Quote Link to comment Share on other sites More sharing options...
DrSimi Posted August 3, 2023 Report Share Posted August 3, 2023 Hi Lynda, I have not tried this myself, but have you looked into using FOR XML PATH and STUFF? It allows you to put multiple rows' data into one field, though I am not sure if it will work with multiple columns too. Check out this post Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.