Get started for free

none
What can I do to fix a LightSwitch HTML Client error "Request failed with status code '400' and status text 'Bad Request'." when accessing large SQL Azure data set? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a dataset with a lot of records and I think that might be why I'm getting this error.

    I used a Browse Data screen template.

    Maybe that's not the best template type to use.

    I'd really like to be able to start with a search field, then use a Browse Data screen for the results.

    I have verified that the SQL Azure data is present.

    "We're all in it together, kid." - Harry Tuttle, Heating Engineer

    Friday, September 6, 2013 1:50 PM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You can try breaking when an exception is thrown, that may cause the debugger to break when the data access exception happened on the server. You can get more information about the data error and make sure that it's not something else.

    To load data by query, you can follow this MSDN article. To ensure that no queries are executed when a parameter is not filled, you can make the parameter Required (not optional).

    Best regards,
    Huy

    • Proposed as answer by Angie Xu Wednesday, September 11, 2013 3:09 AM
    • Marked as answer by Angie Xu Wednesday, September 18, 2013 4:29 AM
    Monday, September 9, 2013 9:37 PM
    |