Hy everybody,
sorry for the stupid question but I cannot find my error.
Problem:
1 table with Lname field, Fname field, Codice field defined in field rules as calculated in this way: trim(Lname)+Trim(Fname) and other fields of no interest. Codice field must be unique (it's only an example; actually I would like to put also the date of birth to avoid duplicated entries)
2 On startup I want a Xdialogbox to appear asking for Lname and Fname.
3 If found, then show form (no entering record allowed)
4 If not found show form and enter new record
I have in action scripting:
- "display an xdialog box" with 2 character variables named cog and nom
- "set variable to constant or expression result", variable name cognum, set value to =trim(Var->cog)+trim(Var->nom)
- "open form" Entry, option hidden, records selected by a filter expression:(Codice = Var->cognom )
- "Set variable to form browse window info" number of records currently selected stored in recfound
- conditional activate form/browse window if Var->recfound>0
Till now everything goes well.
- Now I want a conditional "Display message box" if Var>recfound=0, but when i run the script i get the following messages:
"No records in query" and "The windows ':Entry' does not exists" aaaggghhhhh!!!
I would like:
-a message box with:"No records found"
-go to entry form and automatically insert the content of cog and nom variables into Lname and Fname
-go to next field.
What should i do?
Again sorry for my basic question but I have everything to learn in Alpha5.
Ciao everybody from Italy :-)
sorry for the stupid question but I cannot find my error.
Problem:
1 table with Lname field, Fname field, Codice field defined in field rules as calculated in this way: trim(Lname)+Trim(Fname) and other fields of no interest. Codice field must be unique (it's only an example; actually I would like to put also the date of birth to avoid duplicated entries)
2 On startup I want a Xdialogbox to appear asking for Lname and Fname.
3 If found, then show form (no entering record allowed)
4 If not found show form and enter new record
I have in action scripting:
- "display an xdialog box" with 2 character variables named cog and nom
- "set variable to constant or expression result", variable name cognum, set value to =trim(Var->cog)+trim(Var->nom)
- "open form" Entry, option hidden, records selected by a filter expression:(Codice = Var->cognom )
- "Set variable to form browse window info" number of records currently selected stored in recfound
- conditional activate form/browse window if Var->recfound>0
Till now everything goes well.
- Now I want a conditional "Display message box" if Var>recfound=0, but when i run the script i get the following messages:
"No records in query" and "The windows ':Entry' does not exists" aaaggghhhhh!!!
I would like:
-a message box with:"No records found"
-go to entry form and automatically insert the content of cog and nom variables into Lname and Fname
-go to next field.
What should i do?
Again sorry for my basic question but I have everything to learn in Alpha5.
Ciao everybody from Italy :-)
Comment