Alpha Video Training
Results 1 to 2 of 2

Thread: query filter

  1. #1
    "Certified" Alphaholic
    Real Name
    Richard Coleman
    Join Date
    Oct 2000
    Franklin, TN

    Default query filter

    query.options = ".t."
    query.filter = ".t."
    query.order = "Cus_name_last+Cus_name_spouse_1+Cus_name_spouse_2"
    frm.=:form.ViewQueried("cusform_simple",query.filter,query.order,"")' display form

    I understand the 'options' (cause query to be discarded)
    I understand the 'order' (just an index to sort by)
    Why is the filter set to .t.??
    Will the form open if you do not specify the filter?
    ie ("cusform_simple","",query.order,"")
    Will the form open if the filter is set to .f.?????

    It's not an earth-shattering problem, I'm just curious as to why??????
    I don't want to experiment and crash my system...
    Been there, done that, not pleasant!!!!!!!


  2. #2
    Alpha Software Employee AaronBBrown's Avatar
    Real Name
    Aaron Brown
    Join Date
    Feb 2001
    Waltham, MA

    Default RE: query filter

    The filter is a logical expression. If you want to see *all* records, just set it to .T., otherwise set it to an expression that will return a logical value, like

    query.filter = "firstname = 'aaron'"

    Without the query.filter set, the form will open, but it will show whatever the default or last filter expression was.

Similar Threads

  1. Query Filter
    By Louis Nickerson in forum Web Application Server v6
    Replies: 4
    Last Post: 03-08-2005, 07:07 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


Posting Permissions

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