Alpha Video Training
Results 1 to 2 of 2

Thread: Query on filtered table

  1. #1
    Member trackmanpete's Avatar
    Real Name
    Pete Schuder
    Join Date
    Sep 2005
    Location
    Mansfield, MA
    Posts
    592

    Default Query on filtered table

    Happy New Year. I have used a multi-state button for states (50) to select specific records from a particular state. I then set up an XDialog Box with radio buttons to select "track events" within the state selected. I did this instead of the Custom Query (which works, but lists all the fields in the browse layout). However, the following code does not work. Although seasoned, I am a rookie here (as you could guess from my other questions), but I am hanging in there. Any help would be appreciated, as I am still learning X-basic. (My reasons for the radio buttons is that the events have specific names and I don't want to type in "100m" for 100, etc.

    Thanks for your help... Pete Schuder

    Code:
    'Create an XDialog dialog box to prompt for parameters.
    DIM SHARED vselectevent as C
    DIM SHARED varC_result as C
    ok_button_label = "&OK"
    cancel_button_label = "&Cancel"
    varC_result = ui_dlg_box("Select Event",<<%dlg%
    {region}
    {region}Select Event:{endregion}|
    {region}(vselectevent:100);
    (vselectevent:200);
    (vselectevent:400);
    (vselectevent:800);{endregion};
    ;
    {endregion};
    {line=1,0};
    {region}
    <*15=ok_button_label!OK> <15=cancel_button_label!CANCEL>
    {endregion};
    %dlg%)
    
    'Default comment text.
    DIM records_found as N
    records_found = topparent.queryrun("Event =Var->varC_result","Sequence","","No","<Cross Level>",.f.)

  2. #2
    Member trackmanpete's Avatar
    Real Name
    Pete Schuder
    Join Date
    Sep 2005
    Location
    Mansfield, MA
    Posts
    592

    Default Results!

    I discovered that I was using the wrong variable in finding the events. I was using the variable that selected the "OK" button instead of using the Var->vselectevent button. Wow. I figured it out, another breakthrough.

    Pete

Similar Threads

  1. Filtered Combo Box from External Table
    By Tom Cone Jr in forum Code Archive
    Replies: 0
    Last Post: 07-21-2005, 05:46 PM
  2. Parent table based on query of child table.
    By edward.mattison@scbhn.org in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-25-2005, 04:14 PM
  3. query on filtered index
    By russ Boehle in forum Alpha Five Version 5
    Replies: 17
    Last Post: 01-26-2003, 06:48 AM
  4. Query by Table
    By Arthur Casse in forum Alpha Five Version 4
    Replies: 13
    Last Post: 09-23-2000, 07:43 PM
  5. Scrolling Screen query table and update table
    By mpierce in forum Alpha Five Version 4
    Replies: 2
    Last Post: 09-21-2000, 09:38 AM

Bookmarks

Posting Permissions

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