At 08:16 PM 2/6/2008, Jay K. Rao wrote:
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 ???
At 04:18 PM 2/7/2008, Jay K. Rao wrote:
Subject: Is This A Software Bug Or ???
Jay,
Wow!
You sound so desperate for the answer that you even changed the
subject of your thread.
Please keep in mind that the dedicated folks on this list, who try to
reply and/or help,
not only chip in and bring forward their knowledge, but are busy with
R:BASE and taking
care of their businesses. Some may be traveling, teaching, visiting
customers on site,
may not have the luxury of instant reply and so on. On the other
hand, no one has any
obligation to reply instantly, even though some threads are answered
quickly. So, you
really have to be patient after posting a message and you don't have
to re-post the
exact same question(s) with different subject to draw unnecessary
attention. You can
always move on to the next area of your development and not stay stuck.
If you need personal assistance, you may always pick up the phone and
call the dedicated
support team at R:BASE Technologies (1+724.733.0053). You may also be
interested in
visiting http://www.rbase.com/support/ to explore additional product
support options, if
you wish.
While you are going through the R:Tutorial, I'm sure you will have a
lot of questions
while you learn. However, keep in mind that your lack of the software
knowledge does not
constitute a bug.
Now let me answer your questions, accordingly.
01. After you have established an existing Action within the
Application Designer
interface, you cannot edit that Action. You can add a new Action
or delete the
existing Action if it does not suit your needs.
Once you add a new Action, the WHERE Clause button is made available.
You may submit an enhancement request if you feel this area
requires increased
functionality. We are always listening for ways to improve. You
may submit any
request at http://www.rbase.com/rbg76rdcc/
02. The WHERE Clause value should look like the following:
WHERE emplastname LIKE @'Please Enter Employee Last Name:'
This will display a prompt for you to enter an employee's last name.
This usage is
known as a dynamic WHERE Clause. The WHERE Clause will constantly
change based upon
the last name you enter. When using a dynamic WHERE Clause, the "Test
Clause.."
button will always return an error as the clause is not a valid SQL
statement. Using
the above will give you the results you desire.
Hope that helps!
Very Best R:egards,
Razzak.
