Hi gang,

While I realize that's there's already been one "Tip of the Day" here's a bonus one.

If you've ever had to deal with parsing a "Table.Field" expression, VFP 6.0 added some functions that can make this easier. Of course, they weren't designed for this purpose, but they can be used to do this. The functions are JUSTSTEM(), JUSTEXT() and FORCEEXT(). Here are some sample:

lcalias = 'mytable'
lcfield = 'myfield'
lctableexpr = FORCEEXT(lcalias, lcfield) && returns 'mytable.myfield'
lcnewexpr = FORCEEXT(lctableexpr, 'yourfield') && 'mytable.yourfield'
lcjustalias = JUSTSTEM(lctableexpr) && 'mytable'
lcjustfield = JUSTEXT(lctableexpr) && 'myfield'