StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
FillByParent
FillByParent
Post Reply
Like
0
FillByParent
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Paul Chase
Paul Chase
posted 16 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 414,
Visits: 2.8K
If I attempt to use the FillByParent Method where the Parent has more than 2100 records the method fails with the following exception. I may have a few places where it is possible that the user can select more than 2100 parent records and a fill by parent would be called. I havent looked into how the fillbyparent method works yet but was hoping for any suggestions on how to best handle this.
Thanks
Paul
InnerException: System.Data.SqlClient.SqlException
Class=16
ErrorCode=-2146232060
LineNumber=1
Message="The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."
Number=8003
Procedure=""
Server="ares"
Source=".Net SqlClient Data Provider"
State=1
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
FillByParent
Paul Chase
-
16 Years Ago
The FillByParent method creates a big query that fills by the foreign...
StrataFrame Team
-
16 Years Ago
If you go the CLR UDF route, your query would then look like this:...
StrataFrame Team
-
16 Years Ago
ThanksBen, I was thinking along the lines of the firstsuggestion you...
Paul Chase
-
16 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search