Re: [RBASE-L] - count updates, save excel file

Chaya, First, welcome to R:BASE world! It was certainly a pleasure meeting you at the R:BASE SAT session in Monroeville, PA. Now to your question #2, as you have already received the answers and examples for question #1. When exporting data as Excel using GATEWAY EXPORT command, you can

Re: [RBASE-L] - count updates, save excel file

HI Chaya, Welcome. :) Ken On Thu, May 25, 2017 at 5:02 PM, Chaya Goldberg wrote: > Thanks, Karen and Bill! I will try the suggestions. > > > > *From:* bdown...@downallconsulting.com [mailto:bdownall@ > downallconsulting.com] *On Behalf Of *Bill Downall > *Sent:*

RE: [RBASE-L] - count updates, save excel file

Thanks, Karen and Bill! I will try the suggestions. From: bdown...@downallconsulting.com [mailto:bdown...@downallconsulting.com] On Behalf Of Bill Downall Sent: Thursday, May 25, 2017 4:22 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - count updates, save excel file Chaya, Welcome.

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 wrote: > Hi, thanks for this list. It’s my first time writing in.

Re: [RBASE-L] - count updates, save excel file

Welcome! 1. First, if you SET FEEDBACK ON, then after your insert/update/delete you issue this command: SET VAR vCount = . RBTI_RowsDeleted (inserted/updated) 2. Not sure if this is what you mean, but you can include the drive in the gateway export filename: gateway export xls

[RBASE-L] - count updates, save excel file

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 –

RE: [RBASE-L] - Open File

Rbase X for windows I am using the function CHKFILE to see if a file exists. If it does, I want to rename it before creating a new file by the same name. I am running into problems on our network if the file is open by another user. Is there a method to check if a file is OPEN? Thanks.