Steve, As you cursor down the file list you could accumulate the byte total in a variable. Use the variable as a condition in your while statement:
Set vTtlBytes integer = 0 Dec cur open cur fetch.... include Bytes Col ... While sqlCode <> 100 and vTtlBytes < 7000000 Then Do Stuff Fetch... include Bytes Col Set v vTtlBytes = (.vTtlBytes + .bytesAtCursor) EndWhile Ben Petersen On 25 Jun 2002, at 11:43, Steve Durham 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/ > ================================================ 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/
