>What does the ^ (circumflex) in you snippets do? I couldn't find anything in my refs except some math thing, and on our computers the code broke. Ran without it (the circumflex).
I use it in VFP in two contexts.
1) For powers: 2^5 means 2*2*2*2*2 (repeated five times). Fractional and negative exponents can be used, and have the same meaning as in standard algebra: 2^0.5 means square root of 2, and 2^-3 means 1/2^3.
2) For date constants (VFP 6 or later): {^2001-01-30} (year-month-date, regardless of SET DATE).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)