Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    199

    Unanswered: Problem with SP & Sorting in ADP

    problem:
    Suppose we have an MS ADP <-> MS SQL and in ADP we have a Continous Form on a Stored Procedure with parameters (related to controls on the Form to Filter rowset). Same time I need to sort the data shown on the Form and I use OrderBy & OrderByOn from VBA.
    Now, if I Sort form this way and change the Control referenced to a SP Parameter, Parameter changing doesn't take efect, even if I use Requery or Refresh, Somehow ADP doesn't recognizes changes of the controls related to Parameters after I use OrderByOn=true.
    I checked it via SQL Profiler and figured out that ADP sends SP command with older parameters even after Requery of the Form.

    solution:
    I find an interesting solution - update InputParameters property of the Form this way

    AFTER CONTROL UPDATES (control that is related to parameter)
    Code:
    
    DIM flg as Boolean
    flg=OrderByOn
    OrderByOn=False
    InputParameters=InputParameters
    OrderByOn=flg
    
    My question is - Is there any other way?

  2. #2
    Join Date
    Feb 2004
    Posts
    199
    No ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •