Hey Jim, Well that could work, but here I am doing a disaster recovery program, and the reason for the accurate count of megs, is that I am automating the data to burn to CD. When the bytes reach 700 megs in the destination folder, I will then a have a program that will burn those files to a blank cd waiting in the cd burner. Then Rbase, using RMail of course will send out an email notifying the proper people to properly label and store the cd, then replace it with a blank cd. Being that this is the program database, the file size is constantly growing. So I need to sum the bytes. Auto numbering would not work. Also, I am using a temporary table.
>From: Jim Limburg <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: Declaring a cursor >Date: Tue, 25 Jun 2002 10:17:16 -0700 (PDT) > >Hey Steve > >Just a thought.. If you autonumberd a column in the table the file >information is in.. then you could use a SELECT statement to add >the totals from 1 to the current row you are on and compare that to >your 7000000???? total... > >Jim Limburg > >--- Steve Durham <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > I am working with a cursor. I have Rbase moving files from one directory >to > > another. Now, I only want Rbase to move 700 megs of files, oldest to >newest > > into the destination folder. Rbase is using a temp table that is loaded >with > > information such as filename text, and bytes integer. Is it possible to >set > > the cursor to a limit of 700 megs of files? I know I can run a check on >the > > destination folder, upload that information into another temporary >table, > > and when it reaches 700, set the cursor to end. I would like to see what > > other options Rbase offers for completing this task. > > > > Thank you all, > > SD > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp. > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >__________________________________________________ >Do You Yahoo!? >Yahoo! - Official partner of 2002 FIFA World Cup >http://fifaworldcup.yahoo.com >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
