[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Why my system created variable keeps on changing?



Hi SQR Experts,

I have just created my  first  program (*.srm) in Brio Report Builder V6 were input variables are system generated ( see source code below). My problem is this variable keeps on changing (from $_I104_EUR_ERP_EVENT_EUR_NON_PROD_FLG to $_I204_EUR_ERP_EVENT_EUR_NON_PROD_FLG ....$_I904_EUR_ERP_EVENT_EUR_NON_PROD_FLG
everytime I open/close my program. Since I am referencing this variable, I usually dont get the correct output. This is because the variable I am referencing had already been renamed by the system.  Appreciate if you can give me advice on this.

Also, does SQR v6 no longer supports dates lower than year 2000? (When I tried to use the strtodate($date,'MM/DD/YYYY') command, the $date = '9/01/1999' is being converted to 09/01/2099)

*** Code generated by the system.
....
Label_204_EUR_ERP_EVENT_EUR_NON_PROD_FLG:
Input $_I204_EUR_ERP_EVENT_EUR_NON_PROD_FLG 'Enter a value for EUR_NON_PROD_FLG' MaxLen=1  Type=Char
If IsNull($_I204_EUR_ERP_EVENT_EUR_NON_PROD_FLG) or IsBlank($_I204_EUR_ERP_EVENT_EUR_NON_PROD_FLG)
  Goto Label_204_EUR_ERP_EVENT_EUR_NON_PROD_FLG
End-If
....
** Added code which I manually created

 Let $_I104_EUR_ERP_EVENT_EUR_NON_PROD_FLG= upper($_I104_EUR_ERP_EVENT_EUR_NON_PROD_FLG)

   evaluate $_I104_EUR_ERP_EVENT_EUR_NON_PROD_FLG
    when = 'N'
    Let  $_I104_EUR_ERP_EVENT_EUR_NON_PROD_FLG  = 'Y'
    Let  $PRODUCT_TYPE ='Non-product'

Thanks in advance.

Best Regards,
Emil

begin:vcard
n:Galicinao ;Emil Jr
tel;work:(632) 8078455 ext 120
x-mozilla-html:FALSE
org:Motorola Communications Philippines Inc.;Regional Development Center
version:2.1
title:Systems Analyst
adr;quoted-printable:;;9/F Alabang Businness tower=0D=0A1216 Acacia Ave.,MAdrigal Business Park=0D=0AAyala Alabang;Muntinlupa City;;1780;Philippines
end:vcard