I'm going through Lesson 7 (Creating and Using an Applicaton) in the 7.6
tutorial.
I've already successfully added the actions for Add Employee, Add Customer, and
Add Flight. Now I'm working on Modify Employee. I followed the instructions
to create the action and used the WHERE Builder and I do see the action in my
"Add Actions to Your Application" window as follows:
Action4[Modify Employee]
EDIT USING empform WHERE emplastname LIKE @Please Enter Employee Last
Name:
MY 2 QUESTIONS:
1 If I want to edit the WHERE clause, I don't seem to able to get to the
WHERE builder screen. What I've tried is:
a) selecting Modify Employee
b) selecting Edit
c) I see the EDIT USING clause and selected it but am not able to
edit it (I even tried cliking on Edit Custom...though I'm not
sure if this button is meant for editing the EDIT USING clause I previously
constructed).
What do I need to do to edit the EDIT USING clause ???
2. In building the WHERE clause for # 1 above, the tutorial says "At the end
of "LIKE" enter "@'Please Enter Employee Last Name:'"
My actual WHERE clause now looks like:
emplastname LIKE @Please Enter Employee Last Name:
Obviously, I omitted the " " and I wasn't sure about the single quotes
' ' and tried it both ways (with and without). However, in both
cases, when I clicked on Test Clause, I received an Error...-ERROR- Invalid
TEXT value (2418) & Your Query Does Not Test Properly!
What is wrong with my syntax ???
THANKS IN ADVANCE FOR YOUR HELP !!!
Jay
