Alpha Video Training
Results 1 to 2 of 2

Thread: Help with a Query Filter

  1. #1
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default Help with a Query Filter

    I am trying to recreate a "query by table" in an XBasic Query Filter.
    the QBT values are:

    Type_code="GRUMMAN0089"

    C_Number= 001c..338c ie. a range between 001C and 338C

    C_Number= *C* I'm only after the C_Numbers that Contains "C"

    I first had query_filter="Type_code="GRUMMAM0089" .and. between(C_Number,"001C","338C")

    which works just fine.

    when I add ".add. contains(C_number,"C")

    I get "No Records found"

    TIA

  2. #2
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,632

    Default RE: Help with a Query Filter

    try this:

    query_filter="Type_code='GRUMMAM0089' .and. between(C_Number,'001C','338C').and. ('C' $ C_number)"


    - Steve

Similar Threads

  1. query filter
    By dik_coleman in forum Alpha Five Version 6
    Replies: 1
    Last Post: 10-05-2004, 07:29 AM
  2. Keep a Name while Filter or Query
    By forskare in forum Alpha Five Version 4
    Replies: 4
    Last Post: 05-12-2001, 05:31 AM
  3. query.filter -- Where?
    By forskare in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-11-2001, 05:38 AM
  4. Query filter
    By Jeff Moses in forum Alpha Five Version 4
    Replies: 8
    Last Post: 11-01-2000, 04:59 AM
  5. query filter using *ANY
    By Gary Smith in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-10-2000, 08:22 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
  •