Page view counter

SQLGridSelectView Drill down

Last post 04-24-2006 7:08 AM by PScarlett. 2 replies.

Sort Posts:

  • SQLGridSelectView Drill down

    04-21-2006, 1:07 AM
    • Loading...
    • bs_kc
    • Joined on 11-05-2004, 10:08 AM
    • Kansas City
    • Posts 37
    • Points 185

    I am having a problem with the SQLGridSelectView module "Wait on Above" option. I have three dropdowns with the Second waiting on the First and the Third waiting on the second. After I select a value from the first, it correctly filters the second. When I select the second, the sql for the third reads, "Select field from table where And  X = Parm1 and Y = Parm2" it seems to insert an extra "And" after the "Where".

    I have tried about every combination but, it seems to always be the 3rd parm.

     

    Any ideas?

    Brian

     

  • Re: SQLGridSelectView Drill down

    04-22-2006, 6:41 PM
    • Loading...
    • PScarlett
    • Joined on 04-19-2004, 5:36 AM
    • Ontario, CANADA
    • Posts 331
    • Points 1,665

    I have exchanged e-mails with Brian and believe the issue requires the last filter not to have the Wait on Above feature enabled.

    Paul.

     

    Paul Scarlett - Ontario, Canada
    www.tressleworks.ca
    www.tz3p9v.ca
  • Re: SQLGridSelectView Drill down

    04-24-2006, 7:08 AM
    • Loading...
    • PScarlett
    • Joined on 04-19-2004, 5:36 AM
    • Ontario, CANADA
    • Posts 331
    • Points 1,665

    Well  I was wrong, Brian had set the module correctly.  He had discovered a "feature". 

    I have released a bug-fix for "Wait on Above" featrue of SQLGridSelectedView (V3.4f).  So if you want to usses this feature or are having trouble getting it to work - download the modules from www.tressleworks.ca

    /Paul.

    Paul Scarlett - Ontario, Canada
    www.tressleworks.ca
    www.tz3p9v.ca
Page 1 of 1 (3 items)