Skip to Content
avatar image
Former Member

Issue With Query In SQ01

Hi All,

We are Using SQ01 query to Generate On report, But the Problem is when iam Trying to Retrive Large amount of data, Few Commercial Contracts are not printing on the query out put, But if i execute to retrive small amount of Data That time iam Getting proper out put with out missing any commercial contract numbers..... Could any body suggest us what could be the problem,

Thank you very much

Bhupal

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 10, 2014 at 10:57 AM

    With this much information, it may not be possible to identify issue, a quick and dirty solution could be to debug and see why the particular data is not being selected. It must be getting omitted for a reason.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 10, 2014 at 11:43 AM

    Hi Abhijit,

    Thanks for your Quick responce but in debugging no problem at all, but still few lines are missing Commercial contract number...... My only Question is for the same element only for few lines are missing is there any reason beyond ?

    Any idea can share please.

    Thank you very much

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      There is no reason for the query to miss any record but nothing happens by chance and it must be our program which is causing this.

      Just to help me understand, when you debug possibly put a breakpoint on select <main table> and check if the commercial contract which is not appearing in the list is being selected. if it is being selected in select then is it being dropped before Endselect or it is not being selected by select query.

      Regards