>>>I looked in SCATTER, GATHER, OLDVAL(), GETFLDSTATE(), plus some others and still don't know how to do this. I have a form with already
INSERT INTO auth (id) VALUES (person.id). Now, the form has all the fields from the AUTH table but the person table remains selected (
SELECT person). Then there is a
Combobox.InteractiveChange that need to clear all the fields (along with disabling/enabling the textboxes), how to I clear the fields which have not been updated (only that the AUTH table has the appended record waiting for TableRevert() or TableUpdate()).
>>>
>>>Chuck
>>
>>Not quite sure, if this is an answer, but look at the BLANK command at Help.
>
>Thanks Nadya. This one helped me out too. I'm working in FPW 2.6 and had been doing a SCATTER TO aTemp MEMO BLANK and then a GATHER FROM aTemp MEMO. I checked the help file and the BLANK command is valid there as well.
>
>............Rich
Great! BTW, I picked this advice from here too some time ago. As I recall, it was Cindy, who suggested it.
If it's not broken, fix it until it is.
My Blog