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

  Sx_VFGet():

   Syntax:  Sx_VFGet( <cExpr>, <nLen> )

            <cExpr> = A CHARACTER field name or string expression to be
              evaluated.

            <nLen> = The length to pad or trim the result of the evaluated
              expression.

  Returns:  Returns the evaluated expression padded or trimmed to the
            specified length.

  Description:  To be used in creating index orders on more (or less) bytes
                than the amount defines as 'significant' in a weakly-typed
                "V" field holding character data.  For example, if you have a
                CITY field declared as "V,0", so that all data is stored in
                the memo file, this would typically not be indexable at all.
                Yet, you could build your index on Sx_VFGet( CITY, 10 ) to
                allow you to do SEEKs for values up to 10 bytes long.

  Example:  // Create new database with first 4 bytes 'signifigant'
            RDDSetDefault( "SIXNSX" )
            dbCreate( "TEST", {{"FLD1","V",10,0}} )
            USE test EXCL

            // Can only SEEK for first 4 bytes of field value
            INDEX ON test->FLD1 TAG ORD1

            // Can seek up to 12 bytes of field value
            INDEX ON Sx_VFGet( test->FLD1, 12 ) TAG ORD2