Alpha DevCon 2018
Results 1 to 3 of 3

Thread: wildcard??

  1. #1
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default wildcard??

    I am working on a database for a volunteer fire department district which will allow them to keep track of their calls for each local fire department (3 not including the whole district).

    I am trying to print a report which will show only the calls from a particular fire department (ie Mamou Fire Department). I call the table "events" and all the calls are listed in this table (for each of the three stations)

    Is there a way I can use query.filter " " where I can query the records according to the first letter of the event..ie M20162. I use the "M" to distinguish the Mamou Fire Dept call from the WC Reed call. (I would make the first letter of the call for WC Reed a "W"? I would use query.filter = (product_id = "M......" where .... represents the wildcard characters.

    Not even sure if this would work this way.

    Thanks,

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: wildcard??

    dbf or sql database?

    query.filter = "left(product_id,1)='M' "
    or
    Selected_Prefix="M" ' or it is set somewhere else...

    query.filter = "left(product_id,1)='"+var->Selected_Prefix-"'"

    ?query.filter
    = "left(product_id,1)='M'"
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Re: wildcard??

    Thanks for the advice. I ended up just using a filter which seemed to work. Running into other problems now.

Similar Threads

  1. 3 Domains - Wildcard SSL?
    By mvaughn in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 07-10-2017, 08:25 AM
  2. Wildcard for XBasic
    By John Cunradi in forum Alpha Five Version 10 - Desktop Applications
    Replies: 5
    Last Post: 08-22-2013, 02:53 PM
  3. Finding by Wildcard
    By lkatz1 in forum Alpha Five Version 5
    Replies: 4
    Last Post: 08-12-2011, 10:03 AM
  4. Wildcard (*?)
    By Robert Little in forum Alpha Five Version 8
    Replies: 2
    Last Post: 03-19-2008, 11:38 AM
  5. Wildcard searches
    By David Montalbano in forum Alpha Five Version 6
    Replies: 4
    Last Post: 11-03-2004, 09:40 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
  •