Recent content by keepfoxing

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...

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..

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)

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

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...

it worked..thanks guys for helping!

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

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...

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

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

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...

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

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

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..

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..