Thanks Steve,
I will consider that. My program seems to work fine, but you opened a few doors I did not consider looking in for trouble. >From: "J. Stephen Wills" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: <[EMAIL PROTECTED]> >Subject: RE: Declaring a cursor >Date: Tue, 25 Jun 2002 13:44:51 -0500 > >Steve, unless I'm wrong, about this, you should probably do it at appx >540MB. The reason is readability. Although my experience may be narrow, >I've found that I can get the 640-700MB available on a CD, unless I want it >to be readable in ALL PC's by ALL CD-ROM drives. Apparently it's a >formatting issue related to how the FAT is allocated/written to the CD and >whether or not the media is CD-R or CD-RW. Anyway, I ain't no expert here, >so I've attached a couple of links f/you, just in case you need to check >this out. If you already know all this, please accept my apologies >f/serving as a brief time-sink against your available labor resources. > >http://www.howstuffworks.com/cd3.htm > >http://www.cdrfaq.org/ > >Later, >Steve in Memphis > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Steve Durham > > Sent: Tuesday, June 25, 2002 12:57 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Declaring a cursor > > > > > > 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/ > > > >================================================ >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/ _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.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/
