Unhandle SQL Exception Thrown


Author
Message
Ben Kim
Ben Kim
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 99, Visits: 253
Hopefully this is my last question of the day!  Sorry to be so active here today!

This is not something I would do in production but... In my POC application, I changed the BrowseDialog1.MaximumReturnedRecords to 10,000.  When I do a search with no criteria (bring back the first 10,000 entries), I receive the attached exception regardless which record I select for edit, upon return to the entry form.  If I change the MaximumReturnedRecords back to 1,000 (the default), all is well.

Can someone shed some light on this error?

Thanks!

Ben

Attachments
SF_sqlexception.JPG (129 views, 93.00 KB)
SF_PriorToException.JPG (143 views, 77.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Ben Kim - 19 Years Ago
Trent L. Taylor - 19 Years Ago
Ben Kim - 19 Years Ago
Trent L. Taylor - 19 Years Ago
Ben Kim - 19 Years Ago
                         Take a close look at the debug log. It is the child table that is...
Ben Kim - 19 Years Ago
                         Well, I am confident that it is not within the framework but more than...
Trent L. Taylor - 19 Years Ago
                             The problem you are running into isn't the 10000 return results, if...
Trent L. Taylor - 19 Years Ago
                                 Do you have code to load up the child records automatically (i.e....
Trent L. Taylor - 19 Years Ago
                                     This is the only code I have which could be causing the issue I...
Ben Kim - 19 Years Ago
                                         This is your problem....and there is no way around it due to the SQL...
Trent L. Taylor - 19 Years Ago
                                             After looking at your previous post again, the relationship may not...
Trent L. Taylor - 19 Years Ago
                                         Forget it. I think I found my answer in one of the overloaded methods...
Ben Kim - 19 Years Ago
                                             Good to hear you're going :)
Trent L. Taylor - 19 Years Ago
                                                 Wen you mentioned "multi-key" I presume you were referring to Compound...
Trent L. Taylor - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search