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]] On Behalf 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]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Chaya Goldberg Sent: August-15-17 11:07 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - RBTI_RowsUpdated Thanks, Bruce and Stephen, for your suggestions. Changing the statement didn’t work, unfortunately. I think the foreign data source is probably the issue. Thanks. Chaya From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Tuesday, August 15, 2017 9:30 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - RBTI_RowsUpdated Hi Chaya, My guess is that rbti_rowsUpdated does not work for foreign data sources. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Chaya Goldberg Sent: August-14-17 11:24 AM To: '[email protected]<mailto:[email protected]>' Subject: RE: [RBASE-L] - RBTI_RowsUpdated Hi Everyone, I’m trying to get the value of RBTI_RowsUpdated, but keep getting the error “Unrecognized global variable in expression”. Using the code below, 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 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
