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]] On Behalf 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 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]' 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]. For more options, visit https://groups.google.com/d/optout.
