Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by keepfoxing

  1. keepfoxing

    Error "Alias table not found"

    sorry for the late response, kind of busy.. i have already solved that problem but in connection to it, im using one table in two forms, when i load the first form there is no error, but when i load the 2nd form, the grid displays nothing or blank when the 1st form was closed. any solution to...
  2. keepfoxing

    Displaying records in a grid if value = x

    i used the code you gave SELECT distinct Name FROM TheTable WHERE name NOT in (SELECT name FROM TheTable WHERE AgeOfChild <= 12 and AgeOfChild = value) and added the code: INTO TABLE "c:\System\Data\sampletable.dbf" how to make the id_no available for searching or making it index..
  3. keepfoxing

    Displaying records in a grid if value = x

    it worked.. can i add another condition to that like this one? SELECT distinct Name FROM TheTable WHERE name NOT in (SELECT name FROM TheTable WHERE AgeOfChild <= 12 and AgeOfChild = value)
  4. keepfoxing

    Displaying records in a grid if value = x

    thankx for the response. here is the output: name ---- doe john fox there is still doe's name there.
  5. keepfoxing

    Displaying records in a grid if value = x

    another thing since they are with the same title i 'll just put it here... i have this table: name |status|children|ageofchild ------------------------------- doe |single|marry |11 doe |single|name2 |15 doe |single|name5 |18 john |single|name |13 john |single|name3 |15 fox...
  6. keepfoxing

    Displaying records in a grid if value = x

    it worked..thanks guys for helping!
  7. keepfoxing

    connot find the bilder program

    yeah..very much thanks.. you really saved me today..
  8. keepfoxing

    Displaying records in a grid if value = x

    here is the sample code: set filter to othercondition = "something" and othercondition2 = "something2" and status = "Married" or status = "Single" and the one im telling you that ignores the condition is the first 2 condition.. so it will be F,F,T,T on the grid it shows all records with status...
  9. keepfoxing

    Displaying records in a grid if value = x

    it did filter but ignores the first condition.. i want to display only on the grid where status is equal to married and single..
  10. keepfoxing

    Displaying records in a grid if value = x

    I'm sorry guys for the late response.. actually what i want is that to filter a table in a one field only.. i want to filter single and married. I'm trying to do it like this: set filter to status = "Married" and status = "Single" but it wont work.. plz help
  11. keepfoxing

    Error &quot;Alias table not found&quot;

    hello everyone! i am using a table in all my forms and my problem is when i'm loading a form, the error message: "Alias table not found". for example: i have 3 forms (splash,login,main) when i run the forms from splash -> login -> main then that is the time the error will popup but if i run...
  12. keepfoxing

    Displaying records in a grid if value = x

    what i want is to display only the records being filtered with the value on the field of single and male. how to do this using set filter? thanks in advance
  13. keepfoxing

    run a prg file every monday

    thanks for your replies.. still newbie in vfp, could you pls give example of it.
  14. keepfoxing

    If then else problem

    that worked. but if the user choose to any yr and all majors on the 2 combo box, it says there is no record but actually it has.. that is the only instance that im getting into wrong..
  15. keepfoxing

    If then else problem

    im sprry here is the error message: "an if | else | endif statement is missing" and last else is highlighted. even if i delete the endif on the above it still got the error..
See more

Part and Inventory Search

Back
Top