Alpha Video Training
Results 1 to 4 of 4

Thread: Filter Help

  1. #1
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Filter Help

    Hi,

    Can anyone help me with fixing this filter. The 'vFilter_By' is being captured from a dropdown which gives it the field to filter on. This bit works fine.

    I also want to exclude any data where the del_hide field is equal to .t. - Thats the bit i need a bit of help on please.

    Code:
    append.t_filter = ""+vFilter_By+" = "+ quote(session.vPart_No) + "\" .and. del_hide <> .t."
    Thanks in advance.

    Denis

  2. #2
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Filter Help

    Bump!

  3. #3
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Filter Help

    Its ok. I resolved it.

    Code:
    append.t_filter = ""+vFilter_By+" = "+ quote(session.vPart_No) + " .and. del_hide <> .t."
    Denis

  4. #4
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: Filter Help

    Well done Denis.

    A little experimentation goes a long way.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

Similar Threads

  1. File filter does not filter files?
    By Roderick in forum Alpha Five Version 9 - Desktop Applications
    Replies: 7
    Last Post: 02-07-2009, 03:59 PM
  2. "Simple" filter problem using week() Function to filter grid
    By Scholin in forum Application Server Version 9 - Web/Browser Applications
    Replies: 2
    Last Post: 01-04-2009, 09:37 PM
  3. Base Filter / User Filter - V8 vs. V7
    By Sbrowning in forum Alpha Five Version 7
    Replies: 1
    Last Post: 04-25-2008, 01:00 PM
  4. Date Based dropdown list filter does not filter
    By Steve Bovino in forum Web Application Server v6
    Replies: 17
    Last Post: 10-15-2005, 08:36 AM
  5. Quick Filter used to filter a report
    By Jane Matheson in forum Alpha Five Version 4
    Replies: 10
    Last Post: 12-07-2004, 11:42 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
  •