Search results for query: *

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

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

i have modified it and i got an error on the last else of the code. Select stud_table If Empty(Thisform.cmb_yr.DisplayValue) Or Empty(Thisform.cmb_major.DisplayValue) Messagebox("Please fill the fields required.",64,"Info") Thisform.cmb_yr.SetFocus Return Else Locate For...

this is my code to print list if conditions are met and my problem is, it always give me the message: "There are no enrollees for this year level1". i knew how to construct if then else if there are few conditions but this one makes me confused. can anybody help me reconstruct my if then else...

yeah, it worked.. but how to get that record into an existing table.. should i use loop on it?

i have a grid with a checkbox column and what i want is when a user selects as many records from the grid, all records selected will be save to another table.. tnx