Click above to get retro games delivered to your door ever month!

RANDFILE()

    If you use a lot of temporary files (for example, subsets of larger
    databases), you will find RANDFILE() handy.  It ensures a unique
    filename in a multi-user system.

    Syntax

    RANDFILE(<filename>)

    Required Parameter

    <filename> is a character string representing the name of an of
    existing .dbf file.  This file must already exist for the
    function to work properly!

    Return Value

    A character string representing a random filename.

    Sample Usage

    SELECT invoices                               
    mfile = RANDFILE('invoices')                  
    COPY TO (mfile) WHILE comp_code==m->>comp_code
    USE (mfile)                                   
    DBEDIT()                                      
    USE                                           
    ERASE (mfile + '.dbf')