Alpha Video Training
Results 1 to 2 of 2

Thread: Tom Cone

  1. #1
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,952

    Default Tom Cone

    In a previous post, that I lost somewhere in the shuffle,I was talking about using a variable as a query filter, and your article regarding syntax in filters. First off, I can not tell you how much I appreciate your article. One of your explanations immediately cleared up a lot of the "mystery," - that "+ +" are seen as delimiters. As soon as I stopped trying to conceptualize all those quotes and half quotes literally, and saw the pairs as delimiters, I understood the whole thing. Thank's much.

    I have discovered, also, that the following is correct, and that you can also add to the filter on-the-fly:


    dim names[9] as c
    tbl=table.open("findby")
    tbl.index_primary_put("findby")
    tbl.fetch_first()
    n=tbl.records_get()
    for i=1 to n
    names[i]=tbl.findby
    tbl.fetch_next()
    next
    dim temp as c
    ans=ui_get_list_array("Choose value to search by",1,"names")
    if ans=""
    end
    end if
    tbl.fetch_find(ans)
    '--------temp now contains [amount_due > 0]
    temp=tbl.description + " .and. left(fullname,5) 'Cash,'"
    '--------temp now contains
    '--- [amount_due > 0 .and. left(fullname,5) 'Cash,']
    query.filter=temp
    'note that temp is not enclosed in quotes
    works like a dream

    thank's

    see ya tomorrow



  2. #2
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,952

    Default RE: Tom Cone

    sorry - posted on the wrong site

Similar Threads

  1. Stan Matthews and Tom Cone
    By urbanski in forum Alpha Five Version 6
    Replies: 0
    Last Post: 09-12-2005, 04:20 PM
  2. posting error revisited (for tom cone)
    By eeetee in forum Alpha Five Version 4
    Replies: 4
    Last Post: 12-19-2002, 11:15 AM
  3. for Tom Cone...
    By Bill Warner in forum Alpha Five Version 4
    Replies: 8
    Last Post: 03-07-2002, 05:51 AM
  4. Tom Cone
    By martinwcole in forum Alpha Five Version 4
    Replies: 0
    Last Post: 11-18-2000, 07:25 AM
  5. TOM CONE! I could kiss ya.
    By Jamin Dunivan in forum Alpha Five Version 4
    Replies: 1
    Last Post: 06-03-2000, 02:15 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
  •