HI Chaya, Welcome. :)
Ken On Thu, May 25, 2017 at 5:02 PM, Chaya Goldberg <[email protected]> wrote: > Thanks, Karen and Bill! I will try the suggestions. > > > > *From:* [email protected] [mailto:bdownall@ > downallconsulting.com] *On Behalf Of *Bill Downall > *Sent:* Thursday, May 25, 2017 4:22 PM > *To:* [email protected] > *Subject:* Re: [RBASE-L] - count updates, save excel file > > > > 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 <%28718%29%20998-1415%20%20ext.%20103> > [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. > > -- > 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.
