Al,
>>- you can inadvertently step on existing memvar values unless you carefully manage their names
The variables in the function are passed by value so don't affect existing variables.
>>- If you just have 2 possible INSERT statements, run the correct one via IF...ENDIF as you suggest
>>- If you have a few of them, use DO CASE...
In fact the question referred to field1
or any other meaning that a single IF does not answer the posed question. In fact you're into mathematical combinations or permutations needing at least 8 CASEs to cover all the possibilities for 3 fields. Hence my solution that cheerfully copes even as the number of fields increases past 3 and the CASEs rise into the hundreds.
What was interesting here was an OP suggesting that somebody trying to help, ought to be "constructive." An unusual attitude in VFP. I'll be sure not to offer my useless suggestions to such a person again. ;-)
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
