Re[4]: [RBASE-L] - Using System Variables

Bruce Chitiea Tue, 15 Aug 2017 08:35:19 -0700

Thank you. I had not read thoroughly.

Bruce


------ Original Message ------
Sent: 8/15/2017 8:33:09 AM
Subject: RE: Re[2]: [RBASE-L] - Using System Variables
From: "Stephen Markson" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:

The # is necessary for some system variables and not others.



See Reference Index / System Variables in help.





Regards,



Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251

From:[email protected] [mailto:[email protected]] OnBehalf Of Bruce Chitiea

Sent: August-15-17 11:17 AM
To:[email protected]
Subject: Re[2]: [RBASE-L] - Using System Variables



... even system VARs?



for example:



SET VAR vHumpty = #date

SHOW VAR vHumpty



    (returns '#date')



SET VAR vHumpty = .#date

SHOW VAR vHumpty



    (returns '08/15/2017')





Bruce Chitiea

SafeSectors, Inc.

909.238.9012 Mobile



------ Original Message ------

Sent: 8/15/2017 8:11:06 AM

Subject: RE: [RBASE-L] - RBTI_RowsUpdated

From: "Stephen Markson" <[email protected]>

To: "[email protected]" <[email protected]>

Cc:



You are welcome.



Actually, the var without the # is correct. I use it all the time.





Regards,



Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251

From:[email protected] [mailto:[email protected]] OnBehalf Of Chaya Goldberg

Sent: August-15-17 11:07 AM
To:[email protected]
Subject: RE: [RBASE-L] - RBTI_RowsUpdated

Thanks, Bruce and Stephen, for your suggestions. Changing the statementdidn’t work, unfortunately. I think the foreign data source is probablythe issue.




Thanks.

Chaya

From:[email protected] [mailto:[email protected]] OnBehalf Of Stephen Markson

Sent: Tuesday, August 15, 2017 9:30 AM
To:[email protected]
Subject: RE: [RBASE-L] - RBTI_RowsUpdated



Hi Chaya,

My guess is that rbti_rowsUpdated does not work for foreign datasources.






Regards,



Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251

From:[email protected] [mailto:[email protected]] OnBehalf Of Chaya Goldberg

Sent: August-14-17 11:24 AM
To: '[email protected]'
Subject: RE: [RBASE-L] - RBTI_RowsUpdated



Hi Everyone,

I’m trying to get the value of RBTI_RowsUpdated, but keep getting theerror “Unrecognized global variable in expression”. Using the codebelow, the SSQL UPDATE works fine… any ideas?




CLEAR VAR vupdatescounted

SET VAR vupdatescounted INTEGER = 0

SET FEEDBACK ON



SSQL UPDATE …..



SET VAR vupdatescounted = .rbti_rowsupdated

PAUSE 1 USING .vupdatescounted

SET FEEDBACK OFF





Thanks.

Chaya

--