Adriana, Thanks for your reply. According to Razzak's reply to this post yesterday, the syntax with the single quotes is correct and will work ok even though testing it returns an error. Regarding editing the WHERE clause within the Application Designer...apparently, the WHERE clause can't be edited (once you hit OK). I submitted an enhancement request yesterday for this. Would be nice to have an EDIT feature for the WHERE clause since quite often we need to alter the WHERE clause within the Application Designer after we first construct it.
Jay ----- Original Message ----- From: Adriana Montano To: RBASE-L Mailing List Sent: Friday, February 08, 2008 9:51 AM Subject: [RBASE-L] - RE: Is This A Software Bug Or ??? Jay, Try putting a space after LIKE then the at symbol then a single quote then your dialog text then another single quote like so: EDIT USING empform WHERE emplastname LIKE @'Please Enter Employee Last Name' Don't worry if you get the "Your Query Does Not Test Properly" error message because I think the program is expecting an actual name instead of the dialog. Make sure that on your Main Menu tab, your Action (select it and hit the Edit Selected Item to get the Menu Item Editor) has the correct Action selected on the Action list. I normally don't create applications, so the only way I know to edit an action is to go on the Actions tab, select the action, hit the Edit button, then adding or deleting actions. So if I did not like the previous action (like EDIT USING empform WHERE emplastname LIKE "@'Please enter name'", I delete it and add a new one; then I make sure that the Main menu item has the correct action selected (see last paragraph). Hopefully this will get you to the next part of the tutorial J. Have fun! ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jay K. Rao Sent: Thursday, February 07, 2008 3:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Is This A Software Bug Or ??? 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
