Razzak, Thank you for your help!
The following works: rate IN d_rates WHERE client = .vclient AND carrier = 99 AND truck_type = .vtrucktype AND (category BETWEEN .vadjmileage AND (.vadjmileage + 10)) FYI, before I corrected a couple of mismatched variable types and added all the parens, the error message was Nulls cannot be used in comparisons... Now I can go forward... Thanks again for helping me see the error of my ways! -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, December 27, 2004 11:38 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Form Expression At 11:04 PM 12/27/2004 -0600, Claudine Robbins wrvote: >I tried all of your suggestions and still cannot make this >work. It's starting to look like d�j� vu all over again... >Gotta be simple, no doubt. Claudine, Follow these steps and see what you find: 01. Pre-define all Global Variables with appropriate data types being used in form expression 02. At the R> prompt: SET MESSAGES ON SET ERROR MESSAGES ON FORM formname -- This will leave the R> Prompt window open in the background while using form designer 03. Define the exact expression, select appropriate table and then click on [Add] button If you still cannot save, click on [Cancel] button 04. While in the from designer, switch back to R> Prompt window Do you see any -ERROR- messages? Very Best R:egards, Razzak.
