Chaya, Welcome.
For #1: SET VAR vUpdatesCounted INTEGER = NULL SET FEEDBACK ON UPDATE tablename .... SET VAR vUpdatesCounted = .RBTI_RowsUpdated Bill On Thu, May 25, 2017 at 4:12 PM, Chaya Goldberg <[email protected]> wrote: > Hi, thanks for this list. It’s my first time writing in. > > I have two questions: > > 1. Is there a way to get a count of updated records? I have a SQL > UPDATE statement and would like to display a message with the count of > updates. Right now I’m counting the fields in a temporary table – which > works, but is not 100% accurate, in that it’s counting pending updates and > not actual updates. Is there a way to directly count the updates? > > 2. I’m doing a gateway export into excel. Is there a way to > automatically save the generated excel document in a predetermined location? > > Thanks, > Chaya > > > Chaya Goldberg > Omni Childhood Center > (718) 998-1415 ext. 103 > [email protected] > _______________________________________ > Confidentiality Notice: This e-mail communication and any attachments may > contain confidential and privileged information for the use of the > designated recipients named above. If you are not the intended recipient, > you are hereby notified that you have received this communication in error > and that any review, disclosure, dissemination, distribution or copying of > it or its contents is prohibited. If you have received this communication > in error, please notify me immediately by replying to this message and > deleting it from your computer. > > -- > 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. > -- 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.
