Paul, I notice you are using the syntax "le" instead of "<=" the "le" syntax is obsolete also I would do an explicit data typing for vThis_Hubset set var vThis_Hub integer = 100001 Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293
----- Original Message ---- From: Paul <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, December 16, 2009 8:45:36 PM Subject: [RBASE-L] - Re: Displaying Message On Form on Initial Entry of Data I tried a temp table and inserted 5 rows from 99998 to 100003 and set var v1 int = 100000 and also tried 100001 I tried <= & >= and both worked fine. If you want the sample db send a private email. It is rather simple db, but the var do work. In fact I copied your code and only changed the table/column names. Paul D. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Breen Sent: Wednesday, December 16, 2009 8:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Displaying Message On Form on Initial Entry of Data I wondered the same thing but no. I wish it were that simple. It has me stumped R>show var vthis_hub Variable = Value Type ------------------ ------------------------------ -------- vThis_Hub = 100001 INTEGER ________________________________ From: [email protected] on behalf of Paul InterlockInfo Sent: Wed 12/16/2009 8:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Displaying Message On Form on Initial Entry of Data set var vThis_Hub = 100001 try: Clear var vThis_Hub set var vThis_Hub Int = 100001 It might be seeing a text value vs. int and <= is failing. Run trace and see what the value is for vThis_Hub I am almost sure it is 'Text' Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of Steve Breen Sent: Wednesday, December 16, 2009 7:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Displaying Message On Form on Initial Entry of Data Karen, Please note I have been diligent in testing and as long as I do a "= to" for vThis_Hub then I get the desired results. Message 'Stop and review the data now' is returned. But if I try a "<=" I always get the second result. It is almost like I can not use the <- on a variable. Note: The vthisparentcustid works great also. Anyone have any ideas? -- W2.rmd -- Set variable vMessage2 -- Used to remind a user to Check A Spread Sheet for Customer Equipment Verification -- Major Assumption - var This_CustNub2 is set on form entry -- Major Assumption - var vThis_hub is set on form entry Clear var vWarranty Clear var vthis_parentcustid Clear var vThis_Hub set var vthis_parentcustid integer = 193 set var vThis_Hub = 100001 -- If vthis_Hub = 100001 then - This works great If vthis_Hub le 99999 then - This will not work -- If vthis_parentcustid = 105 then - This works great SET VAR vMessage2 = 'Stop and review the data now' ELSE SET VAR vMessage2 Text = 'test2' ENDIF RECALC VAR RETURN ________________________________ From: [email protected] on behalf of [email protected] Sent: Wed 12/16/2009 12:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Displaying Message On Form on Initial Entry of Data Your "if" clause is valid. You can put as many conditions as you want in an If clause. Karen Karen and Bill can you combine variable's ? Such as follows: If vMessageDisplayed = 'yes' and vMessageDisplayed1 <= 100 THEN SET VAR vMessage = 'Stop and review the data now' ELSE SET VAR vMessage TEXT = NULL ENDIF RECALC VAR
